Dear Experts! Need help to export the trial in Detailed Format with Expand All Level Details. In the Code attached only Detailed format is exported (without Expand All Level) Code: [#Menu: Gateway of Tally] Add: Button: TallytoExcel [Button: TallytoExcel] Key: Alt + T Action: Call: TallytoExcel Title: Tally - Excel [Function: TallytoExcel] 10: Call: TE TrailBalance [System: Formulae] TallyConfigSF: $$ApplicationPath + "\Export\" [Function: TE TrailBalance] Variable: SVExportLanguage: String Variable: DSPShowClosing: Logical Local Formula: ExpFilePath:$$ApplicationPath+"\Export\TrailBalance Excel.xlsx" 01: Set: ExplodeFlag: "Yes" 02: Set: SVExportLanguage: "Default (All Languages)" 03: Set: SVExportFormat: $$SysName:Excel 04: Set: SVOpenFileAfterExport: Yes 05: Set: SVExportLocation: No 06: Set: DSPSHOWCLOSING: Yes 07: Set: SVPRINTFILENAME: $$MakeExportName:@ExpFilePath:##SVExportFormat 08: Export: Trial Balance: True 09: Set: ExplodeFlag: "No" 10: Return
Another Approach used is Trigger as under: [#Menu: Gateway of Tally] Add: Button: G1 [Key: G1] TITLE: "Trial" Key: Alt + T Action: trigger Key: DT,F12,Enter,Enter,Enter,Enter,Enter,Enter,Enter,Enter,Y,Enter,Alt+F1,Alt+E
Through Function, what you could have done....is DONE..... nothing more can be done. For further expansion, you will have to study the report : Trial Balance and find the variable associated with that....to expand all. Also check out the COLLECTION .......... if there are any Filters, you can tweak to get a full report.
If this serves your purpose, it is good. If for learning purpose you want to do, you can try my above mentioned steps.
Sir, both gives result, but in first method the user is only at GoT and no need to do any other effort. Whereas in second at end user have to accept and then quit from the report i.e. trial. I have checked about explode but not able to get how to get expand all level detail. I am searching for the same from default tdl also. If you or the experts may suggest any thing it will be a great help.
Yes true....sometimes for a given requirement, there are multiple choices/methods. I presumed that along with detailed breakup you would be requiring -- the sub-Groups and also the Ledgers with 0 balances too. In that case you need to tweak the Collection and include the zero items. If that is not required then you need not do anything more. Always better to work on dummy data as well as working on separate report, rather than modifying the default Tally's, if one is in learning mode.
The woods are lovely, dark and deep, But I have promises to keep, And miles to go before I sleep, And miles to go before I sleep Thanks for inspiration sir!
Example of date range in Function... [Function: ComputeUDFValue] Parameter : PSVFromDate : Date Parameter : PSVToDate : Date Variable : TotalVal : Amount : 0 Variable : Temp Date : Date Variable : SearchKey : String Variable : SVFromDate : Date Variable : SVToDate : Date RETURNS : Amount 00 : SET : TempDate : ##PSVFromDate 10 : WHILE : (##TempDate <= ##PSVToDate) 20 : SET : SearchKey : #PartyName + $$String:##TempDate 30 : SET : TotalVal : + $$ReportObject:$$CollectionFieldByKey:$CustomUDF:##SearchKey:ExtractVchColl + ##TotalVal 40 : SET : TempDate : ##TempDate + 1 50 : END WHILE 60 : RETURN : ##TotalVal /* The Summary Collection needs to be defined with SearchKey Attribute which is a combination of Party Name Method and Voucher Date. */