XML to export company list with GSTIN from the Tally

Discussion in 'Free Source Codes' started by Rutal Jadav, Mar 27, 2024.

    
  1. Rutal Jadav

    Rutal Jadav Member


    I want to export a company list with GSTIN number data from the tally.

    Currently, I am using the below-mentioned XML to export company data from the tally.



    <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,Guid,Mailingname,Address,PhoneNumber,MobileNumbers,Companynumber,GSTRegNumber,Gstregistrationnumber,gstnum,StartingFrom,STATENAME,email,MOBILENO,PINCODE</FETCH>
    <PARMVAR>LICNUMM:$$LicenseInfo:SerialNumber</PARMVAR>
    <COMPUTE>gstnum:$GSTRegNumber:taxunit:\"" + "Default Tax Unit" + "\"</COMPUTE>
    <COMPUTE>licnumbervar:$$LicenseInfo:SerialNumber</COMPUTE>
    </COLLECTION>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>

    Using the above XML get the same GSTIN for each company listed in the tally. For example, there total of 5 companies listed in the tally 1, 2, 3, 4, and 5, Each company has a unique GSTIN. Here 1 is the selected company in the tally. Using the above XML get the same GSTIN for each company exported from the tally.
    Please update XML to get a unique GSTIN for each company if added.
     


Share This Page