Auto XML Sales Invoice

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

    
  1. HVPatel

    HVPatel Active Member


    This is for Auto XML Sales Voucher after Save (Both Alter or Create).
    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:@@LastItem:CompanyVouchers
        040  :    SET    : VoucherID : "ID:" + ##TempStr
        050  : ELSE
        060  :    SET    : VoucherID : "ID:" + $$String:$MasterId
        070  : END IF
        080  : SET  : SVExportLocation  : $(AppINIConfig, "AppINIConfig").ExportPath
        090  : SET  : SVExportFormat    : $$SysName:XML
        100  : Set  : SVPrintFileName      : $$String:$Vouchertypename+"_"+$$String:$vouchernumber
        110  : SET  : SVPrintFileName  : $$MakeExportName:##SVPrintFileName:##SVExportFormat
        111    : Set    : SVOpenFileAfterExport    : No
        120  : EXPORT REPORT : .    : TRUE
    ;; End of File
    
     


  2. sivam

    sivam Active Member


    Its Not work at creation Time. I want to export a XML at creation time. Please Help me
     


  3. HVPatel

    HVPatel Active Member


    Code Updated, please check. Thanks
     


  4. sivam

    sivam Active Member


    Thanks Sir Its work very fine
     


  5. laxman

    laxman Member


    And Save to PDF Format ?......
     


  6. Anshul Jain

    Anshul Jain New Member


    Dear Sir,

    Can We Save it to PDF of send email of Invoice
     


  7. HVPatel

    HVPatel Active Member


    For AUTO PDF
    Add this line
    Code:
    80a  : SET  : SVExportFormat    :    $$IsSysNameEqual:English:#DSPExportLanguage OR @@EnglishLanguageId = ##SVCurrentUILanguageId   
     
    And Replace This $$SysName:XML to $$SysName:PDF
     
    khushbu likes this.


  8. Anshul Jain

    Anshul Jain New Member


    Sir ,

    Its give error message
    I have replaced XML to PDF
    Please check and send the complete code
     


  9. HVPatel

    HVPatel Active Member


    There is No ERROR
     


  10. sivam

    sivam Active Member


    Dear Sir,
    I want to Export XML at Ledger creation and alteration time. Please help me.
     


  11. bns_ccc

    bns_ccc New Member


    how do i replace the "/" in the voucher number with "-" eg. voucher number is abc/2013-14/1234, so how do i change it to abc-2013-14-1234 so that the same can be used as a name.

    when i use $$String:$Vouchertypename+"_"+$$String:$vouchernumber with a voucher number using the "/" i get folder vouchertype_abc, subfolder 2013-14 and file named 1234

    also how do i break apart the voucher number into the three parts, prefix - number - suffix
     



  12. thanks to give this code and it's successfully Works,

    but i have a one additional Query.
    How to Change XML File "Export Location"..?
     


  13. Raju Das

    Raju Das Member



    080: SET : SVExportLocation : "C\Dhrupal Gorasiya\XYZ"
     
    Ras Raj likes this.


  14. pintu singh

    pintu singh New Member


    To days Come Automtically
     


  15. Vinoj

    Vinoj New Member


    Dear Can u just give me the working TDL for the Auto XML Sales invoice creation on Saving & Editing .... I tied above code , but it I snot generating any files..

    Pls help me

    Regards

    Vinoj
     


  16. Anshul Jain

    Anshul Jain New Member


    Dear Sir
    Its giving this error msg

    Variable SVExport Location Could Not be Found
     


  17. 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:\TallyExportFile" ; Export Location path
    20: SET : SVExportFormat : $$SysName:XML
    30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber
    40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat
    50: Set : SVOpenFileAfterExport : No
    60: EXPORT REPORT : . : TRUE
    ;; End of File

    Its work very fine for me. Please Check it...
     
    khushbu likes this.


  18. Anshul Jain

    Anshul Jain New Member


    Sir,

    Its not getting saved to the desired location
    please provide help
     


  19. Vikas Ranjan Rai

    Vikas Ranjan Rai New Member


    Thanks for your code can you pls help me to post this on a http location.
     


  20. priya

    priya Member


    WONDERFUL TDL. SUCH THOUGHTS DO HELP IN TAKING THE TALLY TO THE NEXT LEVEL AND EASY WORKING ATMOSPHERE.
    Thank you Mr. H V Patel, your contribution is truly helpful. Bye
     
    panam and HVPatel like this.


  21. Prakash Mewada

    Prakash Mewada New Member


    Very fine work...But in pdf middle part expands page width and mismatch with upper part & bottom part...Can you guide me...?
     


  22. kamal

    kamal Member


    Dear Experts
    Thanks in advance
    can any one help me to design code for below format in EXCEL to auto export to single file with below fields
    voucher no dateparty nameAmount
    21202/03/2015kamal500-00
    21302/03/2015cash
    700-00
     


  23. kamal

    kamal Member


    find the attachment
     

    Attached Files:



  24. laxman

    laxman Member





    sir working is fine but i need to working inventory mode only please guide
     


  25. laxman

    laxman Member


    if use to two copy printing sales and want to export only single copy please update...
     


Share This Page