hello every one, i want to show last sale price of item in sale voucher stock list with inventory details. in simple terms add last sale price to stock item while item list open in sale voucher entry. thank you.
Add a field and in the write the below method [Field: My Field] Use: Rate Field Set As: $LastSalePrice:StockItem:$StockItemName
Thanks Sir, however, could you please let us know how to get last sales price for the particular party?
First of all create a collection with type voucher. Then write a second collection with first collection as source collection. In second collection walk by inventory entries. put key = $LedgerName + $StockItemName. Then You can use $$colllectionFieldbykey function to get last rate for a stock item belonging to a particular party. You can put filter for voucher type in first collection
****************************************************** *********** Last Rate of the Party **************** ****************************************************** [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 ;; Endof File