Print Financials at Once

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

 

Thanks for sharing

 

Great.

 

it is run in tally rel 1.1 please

 

i have accuerd error in tdl
"function : tally to excel LABAL 10:Unknown action Delet File

 

how to control sales voucher accept then print. don`t print before accepting voucher. Please help

 

Dear Sir

Use this one

[#Key: PrintButton]
Key : Alt+P
Title : $$LocaleString:"Print"
Type : PrintButton
Inactive: $$InCreateMode
Action : Print Report

 

receivng bad formula error $$MakeExportNameExpFilePath:##SVExportFormat

 

Thanks D Lokesh Sir. Problem solve.

 

Sir my problem, sales voucher total amount under discount above 10% control. Help me.