party last sales rate and discount in invoice

[Collection: Salesvou]

Type : Vouchers : VoucherType
Child Of : $$VchTypeSales
Belongs To : Yes
Fetch : Date, VoucherTypeName, LedgerName, Voucher Number, Amount,DISCOUNT, MasterID, LedgerEntries.BillAllocations.*

[Collection: PartyItemRate]

Source Collection : Salesvou
Walk : InventoryEntries
By : MasterID : $..MasterID
Compute : LedgerName : $..PartyLedgerName
Compute : VoucherNumber : $..VoucherNumber
Compute : Amount : $Amount
Compute : Rate : $Rate
Compute : DISCOUNT :$DISCOUNT
Compute : ItemName : $StockItemName
Sort : @@Default : -$VoucherNumber
Search Key : $LedgerName+$ItemName

;Select $VoucherNumber, $Rate,$DISCOUNT,$ItemName,$LedgerName from PartyItemRate

[#Field: VCH batch Rate]
Delete: Set By Condition
Delete: Set as
Delete: Inactive
add:Set As $$AsRate:$$CollectionFieldByKey:$RateStkPartyRtartyItemRate)
StkPartyRt$LedgerEntries[1].LedgerName+$StockItemName)
Set Always : yes
[#Field: VCH batch discount]
Delete: Set By Condition
Delete: Set as
Delete: Inactive
add:Set As $$AsRate:$$CollectionFieldByKey:$DISCOUNTStkPartyRtartyItemRate)
StkPartyRt$LedgerEntries[1].LedgerName+$StockItemName)
Set Always : yes

 

error relating to StkPartyRt is coming... please
and if possible whatsapp me on 9829014051

 

check the code

 

Thank you Vivin. It Worked. It was really long awaited for me.

 

sir not seen anywhere in tally...how this activate..and where did i get this option?

 

not fetch last rate only fetch first rate party wise rate not last rate and discount please correct this tdl

 

Excellent .... thanks....

 

Good code vivin. Thanks for sharing... really helpful

 

Excellent.