Dear Experts, I have tdl to do "Debtors wise stock group wise sales" i achieved "stock group wise sales", but if i select ledger group (say south debtors) it is not filtered. Requesting to know, what to do with my collection to get it filtered. Code: ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara [#Menu: Gateway of Tally] Add: Item: StockGroup Report : Display: Smpl Stk Grp Rep Add: Item: Debtors StockGrop Report : Display Collection: LedgerGroup : NOT $$IsEmpty:$$SelectedCmps [Collection: LedgerGroup] Use : Group Analysis Delete : Report: Group Analysis Add: Report : Smpl Stk Grp Rep [Report: Smpl Stk Grp Rep] Form : Smpl Stk Grp Rep Use : Dsp Template Title : "Stock Group Report" Variable: ExplodeFlag, Stock Group Name, Group Name [Form: Smpl Stk Grp Rep] Part : Smpl Stk Grp Rep Background : White, Light Orange Button : Change Period, Print Button, Explode Flag Keys : Form Remove Line, Form Show Last Removed Line Height : 100 % Screen Width : 100 % Screen [Part: Smpl Stk Grp Rep] Parts : Form SubTitle, Smpl Stk Grp Rep Details Local : Field : Form SubTitle : Set as : "Stock Group Report For the Period " + @@DspDateStr + " (For : " + ##GroupName + ")" Vertical: Yes [Part: Smpl Stk Grp Rep Details] Lines : Smpl Stk Grp Rep Title, Smpl Stk Grp Rep Details Bottom Line : Smpl Stk Grp Rep Total Repeat : Smpl Stk Grp Rep Details : Smpl Stk Grp and Item Coll Total : Smpl Stk Grp Rep Item Qty, Smpl Stk Grp Rep Item Value Scroll : Vertical [Line: Smpl Stk Grp Rep Details] Fields : Smpl Stk Grp Rep Item Name, Smpl Stk Grp Rep Item SaleQty Right Field : Smpl Stk Grp Rep Item Qty, Smpl Stk Grp Rep Item Value Explode : Smpl Stk Grp Item Details : $$IsStockGroup AND (##ExplodeFlag OR $$KeyExplode) Option : Smpl IsStock Item : $$IsStockItem [!Line: Smpl IsStock Item] Local : Field : Default : Style : Normal Italic [Part: Smpl Stk Grp Item Details] Line : Smpl Stk Grp Item Details Repeat : Smpl Stk Grp Item Details : Smpl Stk Grp and Item Coll [Line: Smpl Stk Grp Item Details] Use : Smpl Stk Grp Rep Details [Line: Smpl Stk Grp Rep Total] Use : Smpl Stk Grp Rep Details Local : Field : Default : Type : String Local : Field : Smpl Stk Grp Rep Item Name : Align : Center Local : Field : Smpl Stk Grp Rep Item Name : Set As : "Total" Local : Field : Smpl Stk Grp Rep Item Qty : Set As : $$Total:SmplStkGrpRepItemQty Local : Field : Smpl Stk Grp Rep Item Value : Set As : $$Total:SmplStkGrpRepItemValue Border : Totals [Line: Smpl Stk Grp Rep Title] Use : Smpl Stk Grp Rep Details Local : Field : Default : Type : String Local : Field : Smpl Stk Grp Rep Item Name : Align : Center Local : Field : Smpl Stk Grp Rep Item Name : Set As : "Particulars" Local : Field : Smpl Stk Grp Rep Item SaleQty : Set as : "Sales Quantity" Local : Field : Smpl Stk Grp Rep Item Qty : Set As : "Closing Balance" Local : Field : Smpl Stk Grp Rep Item Value : Set As : "Closing Value" Border : Column Titles [Field: Smpl Stk Grp Rep Item Name] Use : Name Field Set As : $Name Option : Smpl Stk Grp Item Name : $$IsStockItem Option : Smpl Stk Grp Name : $$IsStockGroup [!Field: Smpl Stk Grp Name] Variable: Stock Group Name Display : Smpl Stk Grp Rep Alter : Stock Group Variable: StockGroupName [!Field: Smpl Stk Grp Item Name ] Variable: Stock Item Name Display : Item Monthly Summary Alter : Stock Item [Field: Smpl Stk Grp Rep Item SaleQty] Use : Qty Primary Field Width : @@NameWidth Set as : $SaleQty [Field: Smpl Stk Grp Rep Item Qty] Use : Qty Primary Field Width : @@NameWidth Set As : $ClosingBalance [Field: Smpl Stk Grp Rep Item Value] Use : Amount Field Width : @@NameWidth Set As : $ClosingValue [Collection: Smpl Stk Grp and Item Coll] Collection : Smpl Stk Grp Coll, Smpl StkGrp Items [Collection: Smpl Stk Grp Coll] Type : Stock Group Child Of: #StockGroupName Fetch : Name, SaleQty, Closing Balance, Closing Value [Collection: Smpl StkGrp Items] Type : Stock Item Childof : #StockGroupName Fetch : Name, SaleQty, Closing Balance, Closing Value Please look into the matter, and guide me resolve it. Thanks to All.
Dear Experts I need to know Collection Name exact, which one is used for Group Analysis (Display > Inventory Books > Movement Analysis > Group Analysis > Select a group from List) Can any one, know on this, i also attached here image.
