XML Export Request for "List of Accounts"

Discussion in 'Tally Integration' started by Researcher, Jan 28, 2020.

    
Tags:
  1. Researcher

    Researcher New Member


    Using below XML request i was able to export "list of accounts" report from tally erp 9.

    <ENVELOPE><HEADER><TALLYREQUEST>Export Data</TALLYREQUEST></HEADER><BODY><EXPORTDATA><REQUESTDESC><REPORTNAME>List of Accounts</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>company name</SVCURRENTCOMPANY>
    <DSPNAMESTYLE>$$SYSNAME:NAMEONLY</DSPNAMESTYLE>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT></STATICVARIABLES</REQUESTDESC></EXPORTDATA></BODY></ENVELOPE>

    This gives the result for default tally setting "export closing balance as opening? - No".
    But i wanted to retrive the report when "export closing balance as opening? - yes". how to get this using xml export request?
     


  2. Rajan Mourya

    Rajan Mourya Member


    Using Below XML you can get the list of all companies which a tally user has selected.

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>COLLECTION</TYPE>
    <ID>compcoll</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <LICNUMM>$$LicenseInfo:SerialNumber</LICNUMM>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION NAME="compcoll" ISINITIALIZE= "Yes">
    <TYPE>Company</TYPE>
    <BELONGSTO>Yes</BELONGSTO>
    <FETCH>Name</FETCH>
    <PARMVAR>LICNUMM:$$LicenseInfo:SerialNumber</PARMVAR>
    </COLLECTION>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     


  3. Sai Vineeth

    Sai Vineeth Active Member


    try this in Static Variables -
    <IMPClAsOp>Yes</IMPClAsOp>
     


  4. Sai Vineeth

    Sai Vineeth Active Member


    Q
    Question is on Different Topic
     


  5. Rajan Mourya

    Rajan Mourya Member



  6. Mukesh Garg

    Mukesh Garg Member



    Sir what is XML Request to Export List of Account with full details
     


  7. Sai Vineeth

    Sai Vineeth Active Member


    you can find the xml in question itself
     


Share This Page