Auto XML Sales Invoice

Discussion in 'Free Source Codes' started by HVPatel, Nov 20, 2013.

    

  1. nice use full thanx
     



  2. how to use multi voucher export datewise ?? date xxx to xxx ??
     



  3. How to Auto Email ....??
     


  4. Anshul Jain

    Anshul Jain New Member



    Friend

    Yes the code is Correct..
    But its not exporting the file to set location
    Please quote your kind suggestions
     


  5. Sawan Zanwar

    Sawan Zanwar New Member


    Hi, Mr. Patel,

    Code is very nice and useful, thanks a lot for this.
    AutoXML is working perfectly fine for me but facing with AutoPDF.

    Getting error as below,

    Error in TDL.
    'Form:printed Invoice'
    Vertical Page Breaks are too big!

    Can you rectify this please?

    I am using below code

    ----------------------------------------------------------------------------------------------------
    [#Form: Sales Color]
    On : Form Accept : $$InAlterMode : CALL : SALES Export Report
    On : Form Accept : $$InCreateMode : CALL : SALES Export Report

    ;; Function Definition begins

    [Function: SALES Export Report]

    Variable: TempStr : String
    Variable: VoucherId : String

    020 : IF : $$InCreateMode
    030 : SET : TempStr : $Cmpvchid:Company:##SVCurrentCompany;$$CollectionField:$MasterId:mad:@LastItem:CompanyVouchers
    040 : SET : VoucherID : "ID:" + ##TempStr
    050 : ELSE
    060 : SET : VoucherID : "ID:" + $$String:$MasterId
    070 : END IF
    080 : SET : SVExportLocation : $(AppINIConfig, "AppINIConfig").ExportPath
    80a : SET : SVExportFormat : $$IsSysNameEqual:English:#DSPExportLanguage OR @@EnglishLanguageId = ##SVCurrentUILangu
    090 : SET : SVExportFormat : $$SysName:pDF
    100 : Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber
    110 : SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat
    111 : Set : SVOpenFileAfterExport : No
    120 : EXPORT REPORT : . : TRUE
    ;; End of File

    ----------------------------------------------------------------------------------------------------
     

    Attached Files:



  6. Rupesh Mor

    Rupesh Mor New Member


    This code works fine for the current invoice, however the output XML doesn't have the mobile number.
    In manual XML export, if we set "Show dependent Masters Also" as Yes. the export includes Mobile number as well.

    how could we do that automatically, with code above?
     


  7. Anshul Jain

    Anshul Jain New Member


    Dear Mr HV Patel,

    Thanks in Advance ,

    I am looking to forward Sales Invoice in PDF Format to concerned parties through whatsapp web.

    Presently i am getting the PDF Created in the Tally Folder. Looking for the PDF files to be created at a desired location with party name & Invoice Number as the name of PDF File.
     


  8. Anshul Jain

    Anshul Jain New Member


    Dear Mr HV Patel,

    Thanks in Advance ,

    I am looking to forward Sales Invoice in PDF Format to concerned parties through whatsapp web.

    Presently i am getting the PDF Created in the Tally Folder. Looking for the PDF files to be created at a desired location with party name & Invoice Number as the name of PDF File.
     


  9. Anshul Jain

    Anshul Jain New Member


    Dear Mr HV Patel,

    Thanks in Advance ,

    I am looking to forward Sales Invoice in PDF Format to concerned parties through whatsapp web.

    Presently i am getting the PDF Created in the Tally Folder. Looking for the PDF files to be created at a desired location with party name & Invoice Number as the name of PDF File.
     


  10. HVPatel

    HVPatel Active Member


    To Make different file name for exported file, modify below line, and use required method name instead of $vouchernumber
    Code:
    100 : Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber
    and to make PDF, already suggested, please check in this post.
     


  11. Anshul Jain

    Anshul Jain New Member



    True its getting exported in PDF but
    1. Problem is its not getting exported at the desired location.
    2. Exported File name should contain Party Ledger Name.

    Thanks for such a kind and early reply
     


  12. Anshul Jain

    Anshul Jain New Member



    True its getting exported in PDF but
    1. Problem is its not getting exported at the desired location.
    2. Exported File name should contain Party Ledger Name.

    Thanks for such a kind and early reply
     


  13. HVPatel

    HVPatel Active Member


    1.
    Change here, and try with hard code between " "
    Code:
    080 : SET : SVExportLocation : $(AppINIConfig, "AppINIConfig").ExportPath
    2.
    Check previous reply, already suggested, to change method name.
     


  14. Anshul Jain

    Anshul Jain New Member


    Sir,

    Please suggest proper code. The File is not getting exported to the desired location.

    Thanks

    [#Form: Sales Color]
    On : Form Accept : $$InAlterMode : CALL : SALES Export Report
    On : Form Accept : $$InCreateMode : CALL : SALES Export Report

    ;; Function Definition begins

    [Function: SALES Export Report]

    10: SET : SVExportLocation : "E:\TallyExportFile" ; Export Location path
    20: SET : SVExportFormat : $$SysName:pDF
    30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber+"_"+$$String:$PartyName
    40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat
    50: Set : SVOpenFileAfterExport : No
    60: EXPORT REPORT : . : TRUE
    ;; End of File
     


  15. Anshul Jain

    Anshul Jain New Member


    Sir,

    Please suggest proper code. The File is not getting exported to the desired location.

    Thanks

    [#Form: Sales Color]
    On : Form Accept : $$InAlterMode : CALL : SALES Export Report
    On : Form Accept : $$InCreateMode : CALL : SALES Export Report

    ;; Function Definition begins

    [Function: SALES Export Report]

    10: SET : SVExportLocation : "E:\TallyExportFile" ; Export Location path
    20: SET : SVExportFormat : $$SysName:pDF
    30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber+"_"+$$String:$PartyName
    40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat
    50: Set : SVOpenFileAfterExport : No
    60: EXPORT REPORT : . : TRUE
    ;; End of File
     


  16. Anshul Jain

    Anshul Jain New Member


    Sir,

    I have tried all possible ways. I am unable to export file to any other folder than Tally Folder. Please Help me
     


  17. nasir

    nasir Member


    how we can export files from tally in version 9.1.1 kindly provide code
    thanks
     


  18. HVPatel

    HVPatel Active Member


    Kindly update tally to latest if you want to use this tdl.
     


  19. ramkumar.pandian

    ramkumar.pandian New Member


    I want to Create XML File for Delete a Voucher from Tally through TDL

    Giving Error

    <TALLYMESSAGE>
    <VOUCHER DATE="03-Jun-2014" TAGNAME = "Voucher Number"
    TAGVALUE="111" VCHTYPE = "Payment" ACTION="Delete">
    </VOUCHER>
    </TALLYMESSAGE>

    013 : Write File Line: "<VOUCHER DATE="03-Jun-2014" TAGNAME = "Voucher Number TAGVALUE="111" VCHTYPE = "Payment" ACTION="Delete">"

    How to write this Line in TDL
     


  20. tmdmuzammil

    tmdmuzammil New Member


    Sir,
    The File is not getting exported to the desired location.

    Thanks
     


  21. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Exporting on wrong location.
     


  22. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    This one is working fine.

    Set Export Path As Per Your Need.



    [#Form: Sales Color]
    On : Form Accept : $$InAlterMode : CALL : SALES Export Report
    On : Form Accept : $$InCreateMode : CALL : SALES Export Report

    ;; Function Definition begins

    [Function: SALES Export Report]

    10: SET : SVExportLocation : "D:\Tally Exported Vouchers"
    20: SET : SVExportFormat : $$SysName:pDF
    30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber
    40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat
    50: Set : SVPrintFileName :##SVExportLocation+"\"+#SVPrintFileName
    60: EXPORT REPORT : . : TRUE
    ;; End of File
     


  23. Rohit Rathi

    Rohit Rathi New Member


    Hi,

    Thanks for TDL.

    Can someone help me with the code.

    My problem is I have two thing printing after saving the Sales Invoice, one is the invoice & second is the gatepass. After printing both of these, first the invoice is saved as pdf but then it replaces the saved invoice with gatepass & ultimately only gatepass is getting saved. I want only invoice to be saved as pdf.

    Please help me with the code.

    Thanks ,
    Rohit Rathi
     


  24. sivam

    sivam Active Member



    [#Form: Sales Color]
    On : Form Accept : $$InAlterMode : CALL : SALES Export Report
    On : Form Accept : $$InCreateMode : CALL : SALES Export Report

    ;; Function Definition begins

    [Function: SALES Export Report]

    10: SET : SVExportLocation : "D:\Tally Exported Vouchers"
    20: SET : SVExportFormat : $$SysName:pDF
    30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber
    40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat
    50: Set : SVPrintFileName :##SVExportLocation+"\"+#SVPrintFileName
    60: EXPORT REPORT : <Report Name> : TRUE
     
    vinoth, Jaya and Nallasivam like this.


  25. auruem

    auruem Member


    Dear Developer

    please suggest the code for

    auto save sales invoice in jpeg format
     


Share This Page