Dear All, As a Chartered Accountant We have to Print/Export following reports again and again many times a day. 1) Balance Sheet 2) Profit & Loss Account 3) Trial Balance Can anyone Provide Solution to above problem? Can't We have just one code or menu or anything from where in a Single Click with given parameters We can Download all these reports at once. It can be in Excel or PDF. It will save lots of time. Thanks in Advance
Dear Mr. Vinit Shah Try this code [#Menu : Gateway Of Tally] Add : Button : TallytoExcel [Button : TallytoExcel] Key : Alt + T Action : Call : TallytoExcel Title : Tally - Excel [Function : TallytoExcel] 10 : Delete File : @@TallyConfigSF + "BalaceSheet Excel.xlsx" 20 : Delete File : @@TallyConfigSF + "TrailBalance Excel.xlsx" 30 : Delete File : @@TallyConfigSF + "ProfitLoss Excel.xlsx" 40 : Call : TE BalaceSheet Master 50 : Call : TE TrailBalance Master 60 : Call : TE ProfitLoss Master [System : Formulae] TallyConfigSF : $$ApplicationPath + "\Export\" [Function : TE BalaceSheet Master] Variable : SVExportLanguage : String Local Formula : ExpFilePath : $$ApplicationPath + "\Export\BalaceSheet Excel" 02 : SET : SVExportLanguage : "Default (All Languages)" 04 : SET : SVEXPORTFORMAT : $$SysName:Excel 05 : SET : SVOpenFileAfterExport : No 06 : SET : SVExportLocation : No 07 : SET : SVPRINTFILENAME : $$MakeExportNameExpFilePath:##SVExportFormat 08 : Export : Balance Sheet : True 10 : Return [Function : TE TrailBalance Master] Variable : SVExportLanguage : String Local Formula : ExpFilePath : $$ApplicationPath + "\Export\TrailBalance Excel" 02 : SET : SVExportLanguage : "Default (All Languages)" 04 : SET : SVEXPORTFORMAT : $$SysName:Excel 05 : SET : SVOpenFileAfterExport : No 06 : SET : SVExportLocation : No 07 : SET : SVPRINTFILENAME : $$MakeExportNameExpFilePath:##SVExportFormat 08 : Export : Trial Balance : True 10 : Return [Function : TE ProfitLoss Master] Variable : SVExportLanguage : String Local Formula : ExpFilePath : $$ApplicationPath + "\Export\ProfitLoss Excel" 02 : SET : SVExportLanguage : "Default (All Languages)" 04 : SET : SVEXPORTFORMAT : $$SysName:Excel 05 : SET : SVOpenFileAfterExport : No 06 : SET : SVExportLocation : No 07 : SET : SVPRINTFILENAME : $$MakeExportNameExpFilePath:##SVExportFormat 08 : Export : Profit and Loss : True 10 : Return
Dear Sir Use this one [#Key: PrintButton] Key : Alt+P Title : $$LocaleString:"Print" Type : PrintButton Inactive: $$InCreateMode Action : Print Report