/* Dear members, can any one help me with this code. i need stockitem value also with quantity. Currently it is showing only quantity. */ [#Menu: Gateway of Tally] Add : Key Item :Before : @@locQuit : Partywise Itemwise Sales : I : Display : GWLW Rep [Report: GWLW Rep] Use : DSP Template Form : GWLW Rep Variable : DoSetAutoColumn, PName Repeat : PName Set : DoSetAutoColumn : Yes Set : DSPRepeatCollection : "GWLW Party" Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate [Form: GWLW Rep] Use : DSP Template Parts : GWLW Rep Option : Set Auto Vch Option : ##DoSetAutoColumn AND $$SetAutoColumnsName [!Form: Set Auto Vch Option] [Part: GWLW Rep] Lines : GWLW Rep Title, GWLW Rep Details BottomLines : GWLW Rep Total Repeat : GWLW Rep Details : Smp Stock Item Scroll : Vertical CommonBorder: Yes Total : GWLW Rep Party, GWLW Rep Col Total [Line: GWLW Rep Title] Use : GWLW Rep Details Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : GWLW Rep Name : Set as : "Particulars" Local : Field : GWLW Rep Name : Widespaced: Yes Local : Field : GWLW Rep Party : Set as : ##PName Local : Field : GWLW Rep Party : Lines : 0 Local : Field : GWLW Rep ColTotal : Set as : "Total" Border : Flush Totals [Line: GWLW Rep Details] Fields : GWLW Rep Name, GWLW Rep Party, GWLW Rep Col Total Repeat : GWLW Rep Party Total : GWLW Rep Party [Field: GWLW Rep Name] Use : Name Field Set as : $IName Display : Stock Vouchers Variable : Stock Item Name [Field: GWLW Rep Party] Use : Qty Primary Field Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQtyMyFormula:GWLWSummVoucher MyFormula : ##PName + #GWLWRepName Format : "NoZero" Border : Thin Left [Field: GWLW Rep Col Total] Use : Qty Primary Field Set as : $$Total:GWLWRepParty Border : Thin Left [Line: GWLW Rep Total] Fields : GWLW Rep Name, GWLW Rep Party, GWLW Rep Col Total Repeat : GWLW Rep Party Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : GWLW Rep Name : Set as : "Total" Local : Field : GWLW Rep Name : Widespaced: Yes Local : Field : GWLW Rep Party : Set as : $$Total:GWLWRepParty Local : Field : GWLW Rep ColTotal : Set as : $$Total:GWLWRepColTotal Border : Thin Top ;; Collection Definition [Collection: GWLW Voucher] Type : Voucher Filter : IsSalesVT [Collection: GWLW Summ Voucher] Source Collection : GWLW Voucher Walk : Inventory Entries By : PName : $PartyLedgerName By : IName : $StockItemName Aggr Compute : BilledQty : SUM : $BilledQty Search Key : $PName + $IName [Collection: Smp Stock Item] Source Collection : GWLW Voucher Walk : Inventory Entries By : IName : $StockItemName Aggr Compute : BilledQty : SUM : $BilledQty Filter : NonEmptyQty [Collection: GWLW Party] Source Collection : GWLW Voucher Walk : Inventory Entries By : PName : $PartyLedgerName Aggr Compute : BilledQty : SUM : $BilledQty Filter : NonEmptyQty ;; Variable Definition [Variable: PName] Type : String Repeat : ##DSPRepeatCollection ;; System Formula [System: Formula] IsSalesVT : $$IsSales:$VoucherTypeName NonEmptyQty : NOT $$IsEmpty:$BilledQty ;; End-of-File
This is made by Goodwill Learning......... They are EXPERTS........ you must approach them for any help regarding this, since they have made this.