1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

last rate

Discussion in 'Requests' started by NITIN, Sep 3, 2012.

    
  1. NITIN

    NITIN New Member


    i want last item rate of party during sales
     
    NITIN, Sep 3, 2012
    #1


  2. Gunasekaran

    Gunasekaran Member


    Dear Nitin:

    Try this code

    $_lastSalePrice:Stockitem:$StockitemName

    Thanks And Regards
    Gunasekaran.S
     
    Gunasekaran, Sep 5, 2012
    #2


  3. NITIN

    NITIN New Member


    Sir
    find last sale rate of item in party account????
    if no last sale rate of item in party account then i use $_lastSalePrice:Stockitem:$StockitemName this
     
    NITIN, Sep 7, 2012
    #3


  4. admin

    admin Administrator Staff Member


    For the Party Accounts, You do not have any direct Method.

    You can achieve this by writing the Collection for Party Vouchers containing This Stock Item..

    From there you can get Last Sale Price :)
     
    admin, Sep 8, 2012
    #4


  5. Girdhar

    Girdhar Member


    Yes, admin guided you correctly.
     
    Girdhar, Sep 8, 2012
    #5


  6. NITIN

    NITIN New Member


    how to use collection of vouchers to find last rates??
     
    NITIN, Sep 12, 2012
    #6


  7. admin

    admin Administrator Staff Member


    [Collection : MyLedSalesColl]
    Type : Vouchers: Stock Item
    Child of : $StockItemName
    Filter : Is Same Party
    Sort : @@Increasing : $MasterId
    Compute :ItemOutrate : ($$AsCrAmt:$OutVchAmt) / ($$AsOutQty:$$NettQty:$ItemOutAccQty:$ItemInActQty)
    [System : Formula]
    IsSameParty : $PartyLedgerName = #EIConsignee (Partyname in Ledger)


    ;; Method to get Last Rate

    $$CollectionField:$ItemOutrate : (-1):MyLedSalesColl


    Try this
     
    admin, Sep 15, 2012
    #7


  8. Aniket

    Aniket New Member


    Sir I tried out this, its not working. With the same item if we process rates for different parties, the item rate last used is coming and the item rate last use OF THAT PARTICULAR PARTY is not coming. Please help me...
     
    Aniket, Sep 23, 2012
    #8


  9. NITIN

    NITIN New Member


    Please correct this code:

    i want only last rate without list collection, please help me


    [System : Formula]
    IsSameParty : $PartyLedgerName = #EIConsignee

    [#Field: VCHBATCH Rate]
    ;Delete : Set by Condition : (($$Line = 1) AND NOT $$IsEmpty:mad:TableRate) AND ($$IsEmpty:$$Value OR $$IsFieldEdited:VCHBATCHTrack OR $$IsFieldEdited:VCHBATCHOrder) : @TableRate
    Table : MyLedSalesColl2, New Number
    Trigger : New Number : $$IsSysNameEqual:NewNumber:$$EditData


    [Collection : MyLedSalesColl2]
    Use : DSD Batches VCH Extract2
    ;Filter : Is Same Party2
    ;Child of : ##SVLedgerName

    [Collection: DSD Batches VchSrc2]
    Type : Vouchers : VoucherType
    Child Of : "Sales"
    Belongs To : Yes
    Fetch : LedgerEntries.* , LedgerEntries.MasterID , LedgerEntries.AllInventoryEntries.*,LedgerEntries.AllInventoryEntries.BatchAllocations.*
    Filter : Is Same Party
    Sort : @@Increasing : $MasterId

    [Collection : DSD Batches VCH Extract2]
    Title : "List Of Serial Numbers"
    Source Collection : DSD Batches VchSrc2
    Walk : InventoryEntries,BatchAllocations
    BY : Ledger Name : $LedgerEntries.LedgerName
    By : Master ID : $LedgerEntries.MasterID
    By : StockItemName : $StockItemName
    By : Batch Rate : $BatchRate
    ;By : BatchName : $BatchName
    ;By : Godown Name : $GodownName
    SubTitle : "Batch Rate"
    SubTitle : "Ledger Name"
    SubTitle : "StockItem Name"
    ;SubTitle : "Batch Name" ;;Serial number
    ;SubTitle : "Godown Name"
    Full Height : Yes
    Align : right
    Format : $BatchRate,15
    Format : $Ledger Name ,20
    Format : $StockItemName ,20
    ;Format : $BatchName,20
    ;Format : $Godown Name ,20
     
    NITIN, Dec 19, 2012
    #9


Share This Page