NEED HELP FOR THIS CODE

Discussion in 'Free Source Codes' started by ONKAR, Aug 30, 2018.

    
  1. ONKAR

    ONKAR Active Member


    this code is perfectly working but one problem in this tdl , balance sheet and profit & loss working good means export directly from tally to excel with all amounts , but trial balance not exported with amount so please help for this all expert ( this tdl code is already uploaded on forum - mr.D.Lokesh sir )
    see this tdl code here ,


    [#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 : $$MakeExportName:mad:ExpFilePath:##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 : $$MakeExportName:mad:ExpFilePath:##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 : $$MakeExportName:mad:ExpFilePath:##SVExportFormat
    08 : Export : Profit and Loss : True
    10 : Return

     


  2. ONKAR

    ONKAR Active Member


    dear @Amit Kamdar sir, you are a boss, thank you so much, sir , it's perfectly working
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    replace with this code..........

    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
    60 : Call : TE ProfitLoss Master
    70 : Call : TE TrailBalance Master
    
    [System : Formulae]
    
    TallyConfigSF : $$ApplicationPath + "\Export\"
    
    [Function : TE BalaceSheet Master]
    
    Variable : SVExportLanguage : String
    
    Local Formula : ExpFilePath : $$ApplicationPath + "\Export\BalaceSheet Excel.xlsx"
    
    02 : SET : SVExportLanguage : "Default (All Languages)"
    04 : SET : SVEXPORTFORMAT : $$SysName:Excel
    05 : SET : SVOpenFileAfterExport : No
    06 : SET : SVExportLocation : No
    07 : SET : SVPRINTFILENAME : $$MakeExportName:@ExpFilePath:##SVExportFormat
    08 : Export : Balance Sheet : True
    10 : Return
    
    [Function : TE TrailBalance Master]
    
    Variable : SVExportLanguage : String
    Variable : DSPShowClosing: Logical
    
    Local Formula : ExpFilePath : $$ApplicationPath + "\Export\TrailBalance Excel.xlsx"
    
    02 : SET : SVExportLanguage : "Default (All Languages)"
    04 : SET : SVEXPORTFORMAT : $$SysName:Excel
    05 : SET : SVOpenFileAfterExport : No
    06 : SET : SVExportLocation : No
    07 : SET : DSPSHOWCLOSING: Yes
    10 : SET : SVPRINTFILENAME : $$MakeExportName:@ExpFilePath:##SVExportFormat
    11 : Export : Trial Balance : True
    12 : Return
    
    [Function : TE ProfitLoss Master]
    
    Variable : SVExportLanguage : String
    
    Local Formula : ExpFilePath : $$ApplicationPath + "\Export\ProfitLoss Excel.xlsx"
    
    02 : SET : SVExportLanguage : "Default (All Languages)"
    04 : SET : SVEXPORTFORMAT : $$SysName:Excel
    05 : SET : SVOpenFileAfterExport : NO
    06 : SET : SVExportLocation : No
    07 : SET : SVPRINTFILENAME : $$MakeExportName:@ExpFilePath:##SVExportFormat
    08 : Export : Profit and Loss : True
    10 : Return
     
    sekharchana and Jaydeep Shah like this.


  4. ONKAR

    ONKAR Active Member


    dear @Amit Kamdar sir, you are a boss, thank you so much, sir, it's perfectly working
     


  5. santoshrokhade

    santoshrokhade New Member


    100: SET: requestURL1: "http://localhost:8383/PDFupload/upload.php"
    130: SET: SVExportFormat: $$SysName:XML
    150: SET: SVPrintFileName: $$MakeHTTPName:##requestURL1:No:"":"":"ABC Company"
    160: Upload REPORT: . : TRUE

    Sir if i upload/Export in XML format the Company address is not coming in XML but company address is visible if i upload/Export as PDF format
     
    Last edited: Dec 14, 2018


Share This Page