party item wise last rate

[#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

 

no display Rate

 

their is an error , experts kindly check and help..

thanks in advance

 

Not working.

 

error in the code need to be corrected....

 

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

 

i m not getting your point

 

what is this

 

Here i attached screen shot, always do write code in code section, so it will not convert (some characters) in emoji.

 

Only like to inform, insert code in code section for more clarity, plz. check above screenshot

 

not working

 

thanx

 

thanx

 

Cant we get it inclusive of GST??

 

PARTY WISE ITEM WISE LAST RATE SHOW IN SALES ENTRY IN TALLY PRIME