[#Field: VCH BilledQty] Sub Form:ItemlastSale [#Field:VCHBATCH BilledQty] Sub Form:ItemlastSale [Report: Itemlastsale] Form: Itemlastsale [Form: ItemlastSale] No Confirm: yes Part: ItemlastSale Option: Small size form Background:white [Part: Itemlastsale] Line: Itemlastsale [Line: Item last Sale] Field: Itemselect, Priceratefield [Field: Itemselect] Use:Name Field Set as:"Last sale Cost / Std. Cost :" Color:RED Style:Verdana Bold Italic Skip:Yes [Fieldriceratefield] Use:Rate Price Field Set as:saler Width:15 Style:Normal Bold Italic Set always : Yes Format : "Symbol,Forex" Type: Rate ;;____________________________________________________________________ [System: Formula] saler: $CollectionField:$Rate:1reviousRateList [Collection : Previous Rate List SRC] Type : Voucher Fetch : Date,VoucherTypeName ,PartyLedgerName, InventoryEntries.* Filter : PreviousRate [Collection : Previous Rate List] Source Collection : Previous Rate List SRC Walk : InventoryEntries Fetch : Rate, Date, VoucherTypeName, PartyLedgerName, StockItemName Filter : RateFilter Sort : Default : -$Date [System : Formula] PreviousRate : $$IsSales:$VoucherTypeName RateFilter : $PartyLedgerName = #EIConsignee AND $StockItemName = #VCHStockItem
Use this code to get party item wise last rate : [Collection : SaleVchColll] Type : Voucher Filter : VchSales [System : Formulae] VchSales : $$IsSales:$VoucherTypeName [Collection : PartyColl] Source Collection : SaleVchColll Walk : InventoryEntries By : Pname : $PartyLedgerName by:item:$stockitemname Aggr Compute : Rate : sum : $Rate [#Field: VCH NrmlRate] Set as : $$FilterValue:$RateartyColl:1artyItemCheck [System: Formula] PartyItemCheck : $Pname=$$ReqObject$$Owner:$PartyLedgername) and $item=#VCHStockItem
Hi VDS Pune, Code is correct, but always insert code, using insert code button, for more clarity in tdl. Regards
Here i attached screen shot, always do write code in code section, so it will not convert (some characters) in emoji.