Tally Chapter 174 TDL for Party Wise Last selling Price Column By Rajiv Mishra Computer Class

 

Few lines are missing here.

Pls watch the Full video first.

[#Line: EI ColumnOne] ;; Invoice Column Headings1 without class

Option : Global EI ColumnOne : @@IsSales

[#Line: EI ColumnOne]

Add : Right Fields : Before: VCH Qtytitle : PrevRate

Local : Field : Default : Align : Left

Local : Field : PrevRate : Info : "Prev. Rate"

[Field: PrevRate]

Use : Short Name Field

Width : 8

Align : Center

Invisible : NOT ##VrVarC1

Skip on : $$IsEnd:$StockItemName

[#Line: EI InvInfo]

Add : Right Fields : Before: VCH BilledQty : PrevRate1

Local : Field : Default : Align : Left

; Local: Field: default : Set as: $Prevrate1

[Collection: VCHSourceColl]

Type : Vouchers : VoucherType

Child of : $$VCHTypeSales

[Collection: VCH Summary Collection]

Source Collection : VCHSourceColl

Walk : Inventory Entries

By : Partyled : $PartyLedgerName

By : ItemName : $StockItemName

By : VoucherNo : $$Owner:$VoucherNumber

By : MasterId : $MasterId

Aggr Compute : RateValue : Sum : $Rate

Sort : Default : -$MasterId

[Field: PrevRate1]

Set as : $$FilterValue:$RateValue:VCHSummaryCollection:1:partyItemCheck

Width:20 mms

PartyItemCheck : $Partyled=$$ReqObject:($$Owner:$PartyLedgername) and $ItemName=#VCHStockItem