I have created TCP to get the "Day wise groups" data from tally using TCP file but it is not giving data as I want. I need data as attached image ( In Tally, We can add the "auto column" as "Daily" using auto column button and can get day wise groups data in "group summary" report. ) Please find my TDL code below [#Report: Group Summary] Set : GroupName:$$SysName:"Sales Accounts" Add: Set: DSPRepeatCollection: "Period Collection New" Add: Set: SVPeriodicity : "Day" Add:Variable:SVFromDate,SVToDate Add:Repeat: SVFromDate,SVToDate [#Form: Group Summary] Option : Set Auto Option 1 : $$SetAutoColumns:SVFromDate [!Form: Set Auto Option1] [Collection: Period Collection New] Type : Period Repeat : "Daily" Please help me with this.
C Certain reports in Tally (e.g. the Group Summary) cannot be overridden by another code except for cosmetic changes like colors, fonts etc. You will have to make your own report and duplicate all the conditions of the original "Group Summary", but only change will be your AutoColumn settings.
ThankYou Amit, I have created TCP for this but not getting proper data. Not able to change the date in order and balance is also not coming related to date. can you please help me with this? Please find New code below. [#Menu : Gateway of Tally] Item : MyTest : Display : MyColReportNew [Report : MyColReportNew] Form : PSColReportNew Variable: DosetAutoColumn,DspRepeatCollection,SVFromDate,SVToDate ;;PSVariable Set : DosetAutoColumn : yes Repeat : SVFromDate,SVToDate ;;PSVariable Set : DspRepeatCollection : PSStockitemCollection Set : SVFromDate : $Booksfrom:Company:##SVCurrentCompany Set : SVToDate : ##SVCurrentDate [Form SColReportNew] Part SColReportNew,PSColReportNewBody Bottom Part : PSColReportNewBodyBTM ;;Option : Set Auto Option : $$SetAutoColumnsSVariable Option : Set Auto Option : $$SetAutoColumns:SVFromDate [Part SColReportNew] Line SColReportNew Border : Column Titles [Line SColReportNew] Field : PSColReportNew,PSColSalesQty Repeat : PSColSalesQty Local : Field : PSColSalesQty : Align : Center [Field SColReportNew] Use : Name Field Set As : "Particulars" [Field SColSalesQty] Use : Name Field ;;Set As : ##PSVariable Set As : ##SVFromDate Border : Thin Left [Part : PSColReportNewBody] Line : PSColReportNewBody Repeat : PSColReportNewBody : PSCustomers Scroll : Vertical Total : PSColSalesQty Common Border : yes [Line SColReportNewBody] Field : PSColReportNew,PSColSalesQty Repeat : PSColSalesQty Local : Field : PSColReportNew : Set As : $Name Local : Field : PSColSalesQty : Type : Amount Local : Field : PSColSalesQty : Align : Right Local : Field : PSColSalesQty : Set AS : $$NettAmount$BSClosing:Group:$Name)$ForexClosing:Group:$Name) [Part : PSColReportNewBodyBTM] Use : PSColReportNew Local : Field : PSColReportNew : Set As : $$TotalSColReportNew Local : Field : PSColSalesQty: Set As : $$TotalSColSalesQty Local : Line SColReportNew : Local : Field : PSColSalesQty : Align : Right [Collection : PSStockitemCollection] Type : Groups ;;Compute : PSVariable : $Booksfrom:Company:##SVCurrentCompany set : SVFromDate : $Booksfrom:Company:##SVCurrentCompany Repeat : SVFromDate + 1 ;;[Variable : SVFromDate] ;; Repeat : ##DspRepeatCollection ;;[Variable : PSVariable] ;; Repeat : ##DspRepeatCollection [Collection : PSCustomers] Type : Groups set : SVFromDate : $Booksfrom:Company:##SVCurrentCompany Repeat : SVFromDate + 1 [System:Formula] SalesAccounts : $$NettAmount$BSClosing:Group:"Sales Accounts")$ForexClosing:Group:"Sales Accounts") SalesTotVal : $ClosingBalance:Group:$$GroupSales Output :
When you submit codes, please remove all commented items (not needed), as it confuses us, until we see the sign. Why have you put SET of SVFromDate in the Collections??
I am on learning stage. I created this file based on another example. It is very closed to end but i am not much familier with repeat. Please help me to finish this tcp.
I have used "Period Collection" but the date is not increasing upto till date and also not coming balance as per date [#Menu : Gateway of Tally] Item : MyTest : Display : MyColReportNew [Report : MyColReportNew] Form : PSColReportNew Variable: DosetAutoColumn,DspRepeatCollection,SVFromDate1 Repeat : SVFromDate1 Set : DosetAutoColumn : yes Set : DspRepeatCollection : "Period Collection" Set : SVPeriodicity : "Day" Set : SVFromDate1 : $Booksfrom:Company:##SVCurrentCompany [Form SColReportNew] Part SColReportNew,PSColReportNewBody Bottom Part : PSColReportNewBodyBTM Option : Set Auto Option : $$SetAutoColumns:SVFromDate1 [Part SColReportNew] Line SColReportNew Border : Column Titles [Line SColReportNew] Field : PSColReportNew,PSColSalesQty Repeat : PSColSalesQty Local : Field : PSColSalesQty : Align : Center [Field SColReportNew] Use : Name Field Set As : "Particulars" [Field SColSalesQty] Use : Name Field Set As : ##SVFromDate1 Border : Thin Left [Part : PSColReportNewBody] Line : PSColReportNewBody Repeat : PSColReportNewBody : PSCustomers Scroll : Vertical Total : PSColSalesQty Common Border : yes [Line SColReportNewBody] Field : PSColReportNew,PSColSalesQty Repeat : PSColSalesQty Local : Field : PSColReportNew : Set As : $Name Local : Field : PSColSalesQty : Type : Amount Local : Field : PSColSalesQty : Align : Right Local : Field : PSColSalesQty : Set AS : $$NettAmount$BSClosing:Group:$Name)$ForexClosing:Group:$Name) [Part : PSColReportNewBodyBTM] Use : PSColReportNew Local : Field : PSColReportNew : Set As : $$TotalSColReportNew Local : Field : PSColSalesQty: Set As : $$TotalSColSalesQty Local : Line SColReportNew : Local : Field : PSColSalesQty : Align : Right [Variable : SVFromDate1] Repeat :##DspRepeatCollection [Collection : PSCustomers] Type : Groups [System:Formula] SalesAccounts : $$NettAmount$BSClosing:Group:"Sales Accounts")$ForexClosing:Group:"Sales Accounts") SalesTotVal : $ClosingBalance:Group:$$GroupSales