How to Use XML Requests for Exporting Data from Tally Prime

Bhavisha AmiparaBhavisha Amipara
14 min read

Export Ledger from Tally Prime

Xml Request:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>COLLECTION</TYPE>
        <ID>List of Ledgers</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
            </STATICVARIABLES>
        </DESC>
    </BODY>
</ENVELOPE>

This XML request is designed to export a specific collection of data from Tally. By setting the TALLYREQUEST to "EXPORT", we are instructing Tally to generate an export file. The TYPE being "COLLECTION" further specifies that the export will involve a group of related data entries, and the ID "List of Ledgers" identifies that the specific data to be exported is the list of ledgers maintained within the Tally system. The request, as constructed, is tailored to retrieve the ledgers in XML format, as indicated by the <SVEXPORTFORMAT> tag within the <STATICVARIABLES> section of the <BODY>.

XML Response :

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <STATUS>1</STATUS>
    </HEADER>
    <BODY>
        <DESC>
            <CMPINFO>
                <COMPANY>0</COMPANY>
                <GROUP>0</GROUP>
                <LEDGER>0</LEDGER>
                <COSTCATEGORY>0</COSTCATEGORY>
                <COSTCENTRE>0</COSTCENTRE>
                <GODOWN>0</GODOWN>
                <STOCKGROUP>0</STOCKGROUP>
                <STOCKCATEGORY>0</STOCKCATEGORY>
                <STOCKITEM>0</STOCKITEM>
                <VOUCHERTYPE>0</VOUCHERTYPE>
                <CURRENCY>0</CURRENCY>
                <UNIT>0</UNIT>
                <BUDGET>0</BUDGET>
                <CLIENTRULE>0</CLIENTRULE>
                <SERVERRULE>0</SERVERRULE>
                <STATE>0</STATE>
                <TDSRATE>0</TDSRATE>
                <TAXCLASSIFICATION>0</TAXCLASSIFICATION>
                <STCATEGORY>0</STCATEGORY>
                <DEDUCTEETYPE>0</DEDUCTEETYPE>
                <ATTENDANCETYPE>0</ATTENDANCETYPE>
                <FBTCATEGORY>0</FBTCATEGORY>
                <FBTASSESSEETYPE>0</FBTASSESSEETYPE>
                <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION>
                <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION>
                <SERIALNUMBER>0</SERIALNUMBER>
                <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION>
                <INCOMETAXSLAB>0</INCOMETAXSLAB>
                <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION>
                <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
                <TAXUNIT>0</TAXUNIT>
                <RETURNMASTER>0</RETURNMASTER>
                <GSTCLASSIFICATION>0</GSTCLASSIFICATION>
                <VOUCHERNUMBERSERIES>0</VOUCHERNUMBERSERIES>
                <VOUCHER>0</VOUCHER>
            </CMPINFO>
        </DESC>
        <DATA>
            <COLLECTION ISMSTDEPTYPE="Yes" MSTDEPTYPE="8">
                <LEDGER NAME="Cash" RESERVEDNAME="">
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Cash</NAME>
                        </NAME.LIST>
                        <LANGUAGEID> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </LEDGER>
                <LEDGER NAME="Profit &amp; Loss A/c" RESERVEDNAME="Profit &amp; Loss A/c">
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Profit &amp; Loss A/c</NAME>
                        </NAME.LIST>
                        <LANGUAGEID> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </LEDGER>
            </COLLECTION>
        </DATA>
    </BODY>
</ENVELOPE>

HEADER: Contains metadata about the request/response, such as the version (VERSION) and status (STATUS), which is 1 indicating success.

BODY:

DESC: Describes the request. The <CMPINFO> section specifies which data components are involved, with 0 indicating that no specific data is requested for those fields.

DATA: Contains the actual data returned by Tally. Here, it shows a collection of ledgers:

LEDGER:

"Cash": A ledger named "Cash" with no reserved name.

  • "Profit & Loss A/c": A ledger named "Profit & Loss A/c" with a reserved name indicating it is a system ledger.

Export group from Tally Prime

XML Request:

'<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>Collection</TYPE>
        <ID>Group</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                <GroupType>Primary</GroupType>
            </STATICVARIABLES>
        </DESC>
    </BODY>
</ENVELOPE>

This XML request is crafted to export a list of primary groups from Tally. The TALLYREQUEST is set to "EXPORT", indicating that the operation will generate an export file. The TYPE of the request is "Collection", meaning that the export will focus on a collection of related data, specifically groups in this case.

The ID is set to "Group", directing Tally to retrieve and export group-related data. The additional parameter <GroupType> set to "Primary" ensures that only primary groups are included in the export.

XML Response:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <STATUS>1</STATUS>
    </HEADER>
    <BODY>
        <DESC>
            <CMPINFO>
                <COMPANY>0</COMPANY>
                <GROUP>0</GROUP>
                <LEDGER>0</LEDGER>
                <COSTCATEGORY>0</COSTCATEGORY>
                <COSTCENTRE>0</COSTCENTRE>
                <GODOWN>0</GODOWN>
                <STOCKGROUP>0</STOCKGROUP>
                <STOCKCATEGORY>0</STOCKCATEGORY>
                <STOCKITEM>0</STOCKITEM>
                <VOUCHERTYPE>0</VOUCHERTYPE>
                <CURRENCY>0</CURRENCY>
                <UNIT>0</UNIT>
                <BUDGET>0</BUDGET>
                <CLIENTRULE>0</CLIENTRULE>
                <SERVERRULE>0</SERVERRULE>
                <STATE>0</STATE>
                <TDSRATE>0</TDSRATE>
                <TAXCLASSIFICATION>0</TAXCLASSIFICATION>
                <STCATEGORY>0</STCATEGORY>
                <DEDUCTEETYPE>0</DEDUCTEETYPE>
                <ATTENDANCETYPE>0</ATTENDANCETYPE>
                <FBTCATEGORY>0</FBTCATEGORY>
                <FBTASSESSEETYPE>0</FBTASSESSEETYPE>
                <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION>
                <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION>
                <SERIALNUMBER>0</SERIALNUMBER>
                <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION>
                <INCOMETAXSLAB>0</INCOMETAXSLAB>
                <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION>
                <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
                <TAXUNIT>0</TAXUNIT>
                <RETURNMASTER>0</RETURNMASTER>
                <GSTCLASSIFICATION>0</GSTCLASSIFICATION>
                <VOUCHERNUMBERSERIES>0</VOUCHERNUMBERSERIES>
                <VOUCHER>0</VOUCHER>
            </CMPINFO>
        </DESC>
        <DATA>
            <COLLECTION ISMSTDEPTYPE="Yes" MSTDEPTYPE="4">
                <GROUP NAME="Bank Accounts" RESERVEDNAME="Bank Accounts">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Bank Accounts</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Bank OD A/c" RESERVEDNAME="Bank OD A/c">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Bank OD A/c</NAME>
                            <NAME>Bank OCC A/c</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Branch / Divisions" RESERVEDNAME="Branch / Divisions">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Branch / Divisions</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Capital Account" RESERVEDNAME="Capital Account">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Capital Account</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Cash-in-Hand" RESERVEDNAME="Cash-in-Hand">
                    <TBALOPENING TYPE="Amount">0.00</TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Cash-in-Hand</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Current Assets" RESERVEDNAME="Current Assets">
                    <TBALOPENING TYPE="Amount">-1447900.00</TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount">-1447900.00</GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Current Assets</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Current Liabilities" RESERVEDNAME="Current Liabilities">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Current Liabilities</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Deposits (Asset)" RESERVEDNAME="Deposits (Asset)">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Deposits (Asset)</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Direct Expenses" RESERVEDNAME="Direct Expenses">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Direct Expenses</NAME>
                            <NAME>Expenses (Direct)</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Direct Incomes" RESERVEDNAME="Direct Incomes">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Direct Incomes</NAME>
                            <NAME>Income (Direct)</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Duties &amp; Taxes" RESERVEDNAME="Duties &amp; Taxes">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Duties &amp; Taxes</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Fixed Assets" RESERVEDNAME="Fixed Assets">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Fixed Assets</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Indirect Expenses" RESERVEDNAME="Indirect Expenses">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Indirect Expenses</NAME>
                            <NAME>Expenses (Indirect)</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Indirect Incomes" RESERVEDNAME="Indirect Incomes">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Indirect Incomes</NAME>
                            <NAME>Income (Indirect)</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Investments" RESERVEDNAME="Investments">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Investments</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Loans &amp; Advances (Asset)" RESERVEDNAME="Loans &amp; Advances (Asset)">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Loans &amp; Advances (Asset)</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Loans (Liability)" RESERVEDNAME="Loans (Liability)">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Loans (Liability)</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Misc. Expenses (ASSET)" RESERVEDNAME="Misc. Expenses (ASSET)">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Misc. Expenses (ASSET)</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Provisions" RESERVEDNAME="Provisions">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Provisions</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Purchase Accounts" RESERVEDNAME="Purchase Accounts">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Purchase Accounts</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Reserves &amp; Surplus" RESERVEDNAME="Reserves &amp; Surplus">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Reserves &amp; Surplus</NAME>
                            <NAME>Retained Earnings</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Sales Accounts" RESERVEDNAME="Sales Accounts">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Sales Accounts</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Secured Loans" RESERVEDNAME="Secured Loans">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Secured Loans</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Stock-in-Hand" RESERVEDNAME="Stock-in-Hand">
                    <TBALOPENING TYPE="Amount">-1447900.00</TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount">-1447900.00</GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Stock-in-Hand</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Sundry Creditors" RESERVEDNAME="Sundry Creditors">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Sundry Creditors</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Sundry Debtors" RESERVEDNAME="Sundry Debtors">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Sundry Debtors</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Suspense A/c" RESERVEDNAME="Suspense A/c">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Suspense A/c</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
                <GROUP NAME="Unsecured Loans" RESERVEDNAME="Unsecured Loans">
                    <TBALOPENING TYPE="Amount"></TBALOPENING>
                    <GRPOPENINGBALANCE TYPE="Amount"></GRPOPENINGBALANCE>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Unsecured Loans</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </GROUP>
            </COLLECTION>
        </DATA>
    </BODY>
</ENVELOPE>

This XML snippet appears to be a part of a response from Tally, detailing various financial groups and their associated attributes. The response includes information about different account groups, such as "Bank Accounts," "Capital Account," and "Current Assets," among others. Each group is defined with elements such as NAME, RESERVEDNAME, TBALOPENING, and GRPOPENINGBALANCE

Export stock group data from Tally Prime

XML Request:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>COLLECTION</TYPE>
        <ID>List of Stock Group</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <COLLECTION NAME="List of Stock Group" ISINITIALIZE="Yes">
                        <TYPE>Stock Group</TYPE>
                        <NATIVEMETHOD>Parent</NATIVEMETHOD>
                        <NATIVEMETHOD>GSTDetails</NATIVEMETHOD>
                        <NATIVEMETHOD>HSNDetails</NATIVEMETHOD>
                    </COLLECTION>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>

The provided XML code is designed to export stock group data from Tally Prime, specifically targeting key details such as parent groups, GST details, and HSN details.

TDLMESSAGE:

  • COLLECTION NAME: Named "List of Stock Group".

    • TYPE: Specifies "Stock Group" as the data type.

    • NATIVEMETHOD: Includes key fields:

      • Parent: Parent group of the stock group.

      • GSTDetails: GST-related details.

      • HSNDetails: HSN details associated with the stock group.

XML Response:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <STATUS>1</STATUS>
    </HEADER>
    <BODY>
        <DESC>
            <CMPINFO>
                <COMPANY>0</COMPANY>
                <GROUP>1</GROUP>
                <LEDGER>2</LEDGER>
                <COSTCATEGORY>0</COSTCATEGORY>
                <COSTCENTRE>0</COSTCENTRE>
                <GODOWN>0</GODOWN>
                <STOCKGROUP>0</STOCKGROUP>
                <STOCKCATEGORY>0</STOCKCATEGORY>
                <STOCKITEM>1</STOCKITEM>
                <VOUCHERTYPE>0</VOUCHERTYPE>
                <CURRENCY>0</CURRENCY>
                <UNIT>0</UNIT>
                <BUDGET>0</BUDGET>
                <CLIENTRULE>0</CLIENTRULE>
                <SERVERRULE>0</SERVERRULE>
                <STATE>0</STATE>
                <TDSRATE>0</TDSRATE>
                <TAXCLASSIFICATION>0</TAXCLASSIFICATION>
                <STCATEGORY>0</STCATEGORY>
                <DEDUCTEETYPE>0</DEDUCTEETYPE>
                <ATTENDANCETYPE>0</ATTENDANCETYPE>
                <FBTCATEGORY>0</FBTCATEGORY>
                <FBTASSESSEETYPE>0</FBTASSESSEETYPE>
                <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION>
                <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION>
                <SERIALNUMBER>0</SERIALNUMBER>
                <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION>
                <INCOMETAXSLAB>0</INCOMETAXSLAB>
                <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION>
                <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
                <TAXUNIT>0</TAXUNIT>
                <RETURNMASTER>0</RETURNMASTER>
                <GSTCLASSIFICATION>0</GSTCLASSIFICATION>
                <VOUCHERNUMBERSERIES>0</VOUCHERNUMBERSERIES>
                <VOUCHER>0</VOUCHER>
            </CMPINFO>
        </DESC>
        <DATA>
            <COLLECTION ISMSTDEPTYPE="Yes" MSTDEPTYPE="128">
              <STOCKGROUP NAME="Hardware" RESERVEDNAME="">
                    <PARENT TYPE="String">&#4; Primary</PARENT>
                    <GSTDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <GSTNOTIFICATIONDATE/>
                        <CALCULATIONTYPE/>
                        <REPORTINGUOM/>
                        <HSNCODE/>
                        <HSNMASTERNAME/>
                        <HSN/>
                        <SUPPLYTYPE/>
                        <TAXABILITY/>
                        <GSTNOTIFICATIONNUMBER/>
                        <GSTNATUREOFTRANSACTION/>
                        <NATUREOFGOODS/>
                        <SRCOFGSTDETAILS>As per Company/Stock Group</SRCOFGSTDETAILS>
                        <GSTCALCSLABONMRP/>
                        <ISREVERSECHARGEAPPLICABLE/>
                        <ISNONGSTGOODS/>
                        <GSTINELIGIBLEITC>Yes</GSTINELIGIBLEITC>
                        <INCLUDEEXPFORSLABCALC/>
                        <REVERSECHARGERATE>0</REVERSECHARGERATE>
                        <STATEWISEDETAILS.LIST>
                            <STATENAME>&#4; Any</STATENAME>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>CGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>SGST/UTGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>IGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>Cess</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>&#4; Not Applicable</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>State Cess</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <GSTSLABRATES.LIST>       </GSTSLABRATES.LIST>
                        </STATEWISEDETAILS.LIST>
                    </GSTDETAILS.LIST>
                    <HSNDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <HSNCODE/>
                        <HSN/>
                        <HSNCLASSIFICATIONNAME/>
                        <SRCOFHSNDETAILS>As per Company/Stock Group</SRCOFHSNDETAILS>
                    </HSNDETAILS.LIST>
                </STOCKGROUP>
                <STOCKGROUP NAME="Home &amp; Garden" RESERVEDNAME="">
                    <PARENT TYPE="String">&#4; Primary</PARENT>
                    <GSTDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <GSTNOTIFICATIONDATE/>
                        <CALCULATIONTYPE/>
                        <REPORTINGUOM/>
                        <HSNCODE/>
                        <HSNMASTERNAME/>
                        <HSN/>
                        <SUPPLYTYPE/>
                        <TAXABILITY>Taxable</TAXABILITY>
                        <GSTNOTIFICATIONNUMBER/>
                        <GSTNATUREOFTRANSACTION/>
                        <NATUREOFGOODS/>
                        <SRCOFGSTDETAILS>Specify Details Here</SRCOFGSTDETAILS>
                        <GSTCALCSLABONMRP/>
                        <ISREVERSECHARGEAPPLICABLE/>
                        <ISNONGSTGOODS/>
                        <GSTINELIGIBLEITC/>
                        <INCLUDEEXPFORSLABCALC/>
                        <REVERSECHARGERATE>0</REVERSECHARGERATE>
                        <STATEWISEDETAILS.LIST>
                            <STATENAME>&#4; Any</STATENAME>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>CGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE> 6</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>SGST/UTGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE> 6</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>IGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE> 12</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>Cess</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>&#4; Not Applicable</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>State Cess</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <GSTSLABRATES.LIST>       </GSTSLABRATES.LIST>
                        </STATEWISEDETAILS.LIST>
                    </GSTDETAILS.LIST>
                    <HSNDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <HSNCODE>8888</HSNCODE>
                        <HSN>Home &amp; Garden Desc</HSN>
                        <HSNCLASSIFICATIONNAME/>
                        <SRCOFHSNDETAILS>Specify Details Here</SRCOFHSNDETAILS>
                    </HSNDETAILS.LIST>
                </STOCKGROUP>
                <STOCKGROUP NAME="Tools" RESERVEDNAME="">
                    <PARENT TYPE="String">&#4; Primary</PARENT>
                    <GSTDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <GSTNOTIFICATIONDATE/>
                        <CALCULATIONTYPE/>
                        <REPORTINGUOM/>
                        <HSNCODE/>
                        <HSNMASTERNAME>GST Rate</HSNMASTERNAME>
                        <HSN/>
                        <SUPPLYTYPE/>
                        <TAXABILITY/>
                        <GSTNOTIFICATIONNUMBER/>
                        <GSTNATUREOFTRANSACTION/>
                        <NATUREOFGOODS/>
                        <SRCOFGSTDETAILS>Use GST Classification</SRCOFGSTDETAILS>
                        <GSTCALCSLABONMRP/>
                        <ISREVERSECHARGEAPPLICABLE/>
                        <ISNONGSTGOODS/>
                        <GSTINELIGIBLEITC>Yes</GSTINELIGIBLEITC>
                        <INCLUDEEXPFORSLABCALC/>
                        <REVERSECHARGERATE>0</REVERSECHARGERATE>
                        <STATEWISEDETAILS.LIST>
                            <STATENAME>&#4; Any</STATENAME>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>CGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>SGST/UTGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>IGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>Cess</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>&#4; Not Applicable</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>State Cess</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <GSTSLABRATES.LIST>       </GSTSLABRATES.LIST>
                        </STATEWISEDETAILS.LIST>
                    </GSTDETAILS.LIST>
                    <HSNDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <HSNCODE/>
                        <HSN/>
                        <HSNCLASSIFICATIONNAME>GST Group</HSNCLASSIFICATIONNAME>
                        <SRCOFHSNDETAILS>Use GST Classification</SRCOFHSNDETAILS>
                    </HSNDETAILS.LIST>
                </STOCKGROUP>
            </COLLECTION>
        </DATA>
    </BODY>
</ENVELOPE>

This version focuses on the STOCKGROUP elements with relevant GST details and HSN details.

Export GST Classification data from Tally Prime

XML Request:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>COLLECTION</TYPE>
        <ID>List of Classification</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <COLLECTION NAME="List of Classification" ISINITIALIZE="Yes">
                        <TYPE>GSTCLASSIFICATION</TYPE>
                        <NATIVEMETHOD>HSNDetails</NATIVEMETHOD>
                        <NATIVEMETHOD>GSTDetails</NATIVEMETHOD>
                    </COLLECTION>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>

The provided XML request is designed to export GST classification data from Tally, including detailed HSN and GST information.

TDL Section:

  • TDLMESSAGE: Within this, a collection named "List of Classification" is initialized and configured to extract GST classification data.

  • COLLECTION:

    • NAME: The name of the collection is "List of Classification."

    • ISINITIALIZE: This attribute is set to "Yes," indicating that the collection should be initialized before fetching the data.

    • TYPE: Specifies the type of data to be fetched, which is "GSTCLASSIFICATION."

    • NATIVEMETHOD: The request includes two native methods:

      • HSNDetails: Fetches HSN (Harmonized System of Nomenclature) details associated with the GST classification.

      • GSTDetails: Retrieves GST-related details associated with the classification.

XML Response:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <STATUS>1</STATUS>
    </HEADER>
    <BODY>
        <DESC>
            <CMPINFO>
                <COMPANY>0</COMPANY>
                <GROUP>1</GROUP>
                <LEDGER>2</LEDGER>
                <COSTCATEGORY>0</COSTCATEGORY>
                <COSTCENTRE>0</COSTCENTRE>
                <GODOWN>0</GODOWN>
                <STOCKGROUP>0</STOCKGROUP>
                <STOCKCATEGORY>0</STOCKCATEGORY>
                <STOCKITEM>1</STOCKITEM>
                <VOUCHERTYPE>0</VOUCHERTYPE>
                <CURRENCY>0</CURRENCY>
                <UNIT>0</UNIT>
                <BUDGET>0</BUDGET>
                <CLIENTRULE>0</CLIENTRULE>
                <SERVERRULE>0</SERVERRULE>
                <STATE>0</STATE>
                <TDSRATE>0</TDSRATE>
                <TAXCLASSIFICATION>0</TAXCLASSIFICATION>
                <STCATEGORY>0</STCATEGORY>
                <DEDUCTEETYPE>0</DEDUCTEETYPE>
                <ATTENDANCETYPE>0</ATTENDANCETYPE>
                <FBTCATEGORY>0</FBTCATEGORY>
                <FBTASSESSEETYPE>0</FBTASSESSEETYPE>
                <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION>
                <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION>
                <SERIALNUMBER>0</SERIALNUMBER>
                <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION>
                <INCOMETAXSLAB>0</INCOMETAXSLAB>
                <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION>
                <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
                <TAXUNIT>0</TAXUNIT>
                <RETURNMASTER>0</RETURNMASTER>
                <GSTCLASSIFICATION>0</GSTCLASSIFICATION>
                <VOUCHERNUMBERSERIES>0</VOUCHERNUMBERSERIES>
                <VOUCHER>0</VOUCHER>
            </CMPINFO>
        </DESC>
        <DATA>
            <COLLECTION ISMSTDEPTYPE="Yes" MSTDEPTYPE="0">
                <GSTCLASSIFICATION NAME="GST Group" RESERVEDNAME="">
                    <GSTDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <GSTNOTIFICATIONDATE/>
                        <CALCULATIONTYPE/>
                        <REPORTINGUOM/>
                        <HSNCODE/>
                        <HSNMASTERNAME/>
                        <HSN/>
                        <SUPPLYTYPE/>
                        <TAXABILITY/>
                        <GSTNOTIFICATIONNUMBER/>
                        <GSTNATUREOFTRANSACTION/>
                        <NATUREOFGOODS/>
                        <SRCOFGSTDETAILS>Specify Slab-Based Rates</SRCOFGSTDETAILS>
                        <GSTCALCSLABONMRP/>
                        <ISREVERSECHARGEAPPLICABLE/>
                        <ISNONGSTGOODS/>
                        <GSTINELIGIBLEITC/>
                        <INCLUDEEXPFORSLABCALC/>
                        <REVERSECHARGERATE>0</REVERSECHARGERATE>
                        <STATEWISEDETAILS.LIST>
                            <STATENAME>&#4; Any</STATENAME>
                            <RATEDETAILS.LIST>       </RATEDETAILS.LIST>
                            <GSTSLABRATES.LIST>
                                <TAXABILITY>Taxable</TAXABILITY>
                                <TOITEMRATE> 29</TOITEMRATE>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>CGST</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE> 6</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>SGST/UTGST</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE> 6</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>IGST</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE> 12</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>Cess</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>&#4; Not Applicable</GSTRATEVALUATIONTYPE>
                                    <GSTRATE>0</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>State Cess</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE>0</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                            </GSTSLABRATES.LIST>
                            <GSTSLABRATES.LIST>
                                <TAXABILITY>Taxable</TAXABILITY>
                                <TOITEMRATE> 89</TOITEMRATE>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>CGST</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE> 2.50</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>SGST/UTGST</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE> 2.50</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>IGST</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE> 5</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>Cess</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>&#4; Not Applicable</GSTRATEVALUATIONTYPE>
                                    <GSTRATE>0</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>State Cess</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE>0</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                            </GSTSLABRATES.LIST>
                            <GSTSLABRATES.LIST>
                                <TAXABILITY>Taxable</TAXABILITY>
                                <TOITEMRATE>0</TOITEMRATE>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>CGST</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE>0</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>SGST/UTGST</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE>0</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>IGST</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE>0</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>Cess</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>&#4; Not Applicable</GSTRATEVALUATIONTYPE>
                                    <GSTRATE>0</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                                <RATEDETAILS.LIST>
                                    <GSTRATEDUTYHEAD>State Cess</GSTRATEDUTYHEAD>
                                    <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                    <GSTRATE>0</GSTRATE>
                                    <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                                </RATEDETAILS.LIST>
                            </GSTSLABRATES.LIST>
                        </STATEWISEDETAILS.LIST>
                    </GSTDETAILS.LIST>
                    <HSNDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <HSNCODE>9999</HSNCODE>
                        <HSN>GST Classification</HSN>
                        <HSNCLASSIFICATIONNAME/>
                        <SRCOFHSNDETAILS>Specify Details Here</SRCOFHSNDETAILS>
                    </HSNDETAILS.LIST>
                </GSTCLASSIFICATION>
            </COLLECTION>
        </DATA>
    </BODY>
</ENVELOPE>

This XML request is designed to export a collection of GST classifications from Tally, including detailed GST rates and HSN details. The data includes state-wise GST slab rates, HSN codes, and other related information, starting from a specified applicable date.

Export Stock Summary list from Tally Prime

Xml Request:

<ENVELOPE>
    <HEADER>
        <TALLYREQUEST>Export Data</TALLYREQUEST>
    </HEADER>

    <BODY>
        <EXPORTDATA>
            <REQUESTDESC>
                <STATICVARIABLES> </STATICVARIABLES>
                <REPORTNAME>Stock Summary</REPORTNAME>
            </REQUESTDESC>
        </EXPORTDATA>
    </BODY>
</ENVELOPE>

Xml Response:

<ENVELOPE>
    <DSPACCNAME>
        <DSPDISPNAME>Sarees</DSPDISPNAME>
    </DSPACCNAME>
    <DSPSTKINFO>
        <DSPSTKCL>
            <DSPCLQTY>100 pcs</DSPCLQTY>
            <DSPCLRATE>12000.00</DSPCLRATE>
            <DSPCLAMTA>-1200000.00</DSPCLAMTA>
        </DSPSTKCL>
    </DSPSTKINFO>
</ENVELOPE>

This response provides a stock summary

  • Quantity: <DSPCLQTY> represents the available quantity.

  • Rate: <DSPCLRATE> indicates the rate per unit.

  • Value: <DSPCLAMTA> reflects the total value of the stock.

Export Voucher Type list from Tally Prime

Xml Request:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>Collection</TYPE>
        <ID>Voucher</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                <GroupType>Primary</GroupType>
            </STATICVARIABLES>
        </DESC>
    </BODY>
</ENVELOPE>

xml Response:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <STATUS>1</STATUS>
    </HEADER>
    <BODY>
        <DESC>
            <CMPINFO>
                <COMPANY>0</COMPANY>
                <GROUP>0</GROUP>
                <LEDGER>0</LEDGER>
                <COSTCATEGORY>0</COSTCATEGORY>
                <COSTCENTRE>0</COSTCENTRE>
                <GODOWN>0</GODOWN>
                <STOCKGROUP>0</STOCKGROUP>
                <STOCKCATEGORY>0</STOCKCATEGORY>
                <STOCKITEM>0</STOCKITEM>
                <VOUCHERTYPE>0</VOUCHERTYPE>
                <CURRENCY>0</CURRENCY>
                <UNIT>0</UNIT>
                <BUDGET>0</BUDGET>
                <CLIENTRULE>0</CLIENTRULE>
                <SERVERRULE>0</SERVERRULE>
                <STATE>0</STATE>
                <TDSRATE>0</TDSRATE>
                <TAXCLASSIFICATION>0</TAXCLASSIFICATION>
                <STCATEGORY>0</STCATEGORY>
                <DEDUCTEETYPE>0</DEDUCTEETYPE>
                <ATTENDANCETYPE>0</ATTENDANCETYPE>
                <FBTCATEGORY>0</FBTCATEGORY>
                <FBTASSESSEETYPE>0</FBTASSESSEETYPE>
                <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION>
                <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION>
                <SERIALNUMBER>0</SERIALNUMBER>
                <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION>
                <INCOMETAXSLAB>0</INCOMETAXSLAB>
                <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION>
                <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
                <TAXUNIT>0</TAXUNIT>
                <RETURNMASTER>0</RETURNMASTER>
                <GSTCLASSIFICATION>0</GSTCLASSIFICATION>
                <VOUCHERNUMBERSERIES>0</VOUCHERNUMBERSERIES>
                <VOUCHER>0</VOUCHER>
            </CMPINFO>
        </DESC>
        <DATA>
            <COLLECTION ISMSTDEPTYPE="Yes" MSTDEPTYPE="1024">
                <VOUCHERTYPE NAME="Attendance" RESERVEDNAME="Attendance">
                    <MAILINGNAME TYPE="String">Attd</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 240</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Attendance</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Contra" RESERVEDNAME="Contra">
                    <MAILINGNAME TYPE="String">Ctra</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 10</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Contra</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Credit Note" RESERVEDNAME="Credit Note">
                    <MAILINGNAME TYPE="String">C/Note</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 50</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Credit Note</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Debit Note" RESERVEDNAME="Debit Note">
                    <MAILINGNAME TYPE="String">D/Note</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 60</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Debit Note</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Delivery Note" RESERVEDNAME="Delivery Note">
                    <MAILINGNAME TYPE="String">Dely Note</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 90</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Delivery Note</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Job Work In Order" RESERVEDNAME="Job Work In Order">
                    <MAILINGNAME TYPE="String">Job Wrk In Ordr</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 260</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Job Work In Order</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Job Work Out Order" RESERVEDNAME="Job Work Out Order">
                    <MAILINGNAME TYPE="String">Job Wrk Out Ordr</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 270</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Job Work Out Order</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Journal" RESERVEDNAME="Journal">
                    <MAILINGNAME TYPE="String">Jrnl</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 40</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Journal</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Material In" RESERVEDNAME="Material In">
                    <MAILINGNAME TYPE="String">Mat In</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 290</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Material In</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Material Out" RESERVEDNAME="Material Out">
                    <MAILINGNAME TYPE="String">Mat Out</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 280</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Material Out</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Memorandum" RESERVEDNAME="Memorandum">
                    <MAILINGNAME TYPE="String">Memo</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 150</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Memorandum</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Payment" RESERVEDNAME="Payment">
                    <MAILINGNAME TYPE="String">Pymt</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 20</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Payment</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Payroll" RESERVEDNAME="Payroll">
                    <MAILINGNAME TYPE="String">Pyrl</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 250</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Payroll</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Physical Stock" RESERVEDNAME="Physical Stock">
                    <MAILINGNAME TYPE="String">Phy Stk</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 130</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Physical Stock</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Purchase" RESERVEDNAME="Purchase">
                    <MAILINGNAME TYPE="String">Purc</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 80</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Purchase</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Purchase Order" RESERVEDNAME="Purchase Order">
                    <MAILINGNAME TYPE="String">Purc Order</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 180</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Purchase Order</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Receipt" RESERVEDNAME="Receipt">
                    <MAILINGNAME TYPE="String">Rcpt</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 30</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Receipt</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Receipt Note" RESERVEDNAME="Receipt Note">
                    <MAILINGNAME TYPE="String">Rcpt Note</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 100</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Receipt Note</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Rejections In" RESERVEDNAME="Rejections In">
                    <MAILINGNAME TYPE="String">Rej In</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 120</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Rejections In</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Rejections Out" RESERVEDNAME="Rejections Out">
                    <MAILINGNAME TYPE="String">Rej Out</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 110</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Rejections Out</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Reversing Journal" RESERVEDNAME="Reversing Journal">
                    <MAILINGNAME TYPE="String">Rev Jrnl</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 160</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Reversing Journal</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Sales" RESERVEDNAME="Sales">
                    <MAILINGNAME TYPE="String">Sale</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 70</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Sales</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Sales Order" RESERVEDNAME="Sales Order">
                    <MAILINGNAME TYPE="String">Sales Ordr</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">No</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 170</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Sales Order</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
                <VOUCHERTYPE NAME="Stock Journal" RESERVEDNAME="Stock Journal">
                    <MAILINGNAME TYPE="String">Stk Jrnl</MAILINGNAME>
                    <ISACTIVE TYPE="Logical">Yes</ISACTIVE>
                    <SORTPOSITION TYPE="Number"> 140</SORTPOSITION>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Stock Journal</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                </VOUCHERTYPE>
            </COLLECTION>
        </DATA>
    </BODY>
</ENVELOPE>

This response gives all the tally voucher types list like contra, Credit Note, Attendance, etc.

Export Stock item from Tally Prime

Xml Request:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>COLLECTION</TYPE>
        <ID>List of Stock Items</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <COLLECTION NAME="List of Stock Items" ISINITIALIZE="Yes">
                        <TYPE>Stock item</TYPE>
                        <NATIVEMETHOD>Name</NATIVEMETHOD>
                        <NATIVEMETHOD>Parent</NATIVEMETHOD>
                        <NATIVEMETHOD>OpeningBalance</NATIVEMETHOD>
                        <NATIVEMETHOD>OpeningValue</NATIVEMETHOD>
                        <NATIVEMETHOD>GSTDetails</NATIVEMETHOD>
                        <NATIVEMETHOD>HSNDetails</NATIVEMETHOD>
                        <NATIVEMETHOD>BaseUnits</NATIVEMETHOD>
                        <NATIVEMETHOD>GSTTypeOfSupply</NATIVEMETHOD>
                        <NATIVEMETHOD>MRPDetails</NATIVEMETHOD>
                        <NATIVEMETHOD>BatchalLocations</NATIVEMETHOD>
                    </COLLECTION>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>

This request is designed to export a collection of stock items with the following details:

  • Name: Provides the name of the stock item.

  • Parent: Indicates the stock group to which the item belongs.

  • OpeningBalance: Displays the opening quantity of the stock item.

  • OpeningValue: Represents the opening rate or value of the stock item.

  • GSTDetails: Includes all relevant GST information, such as GST rate details.

  • HSNDetails: Provides HSN-related details, including the HSN code and description.

  • BaseUnits: Specifies the base units for the stock item.

  • GSTTypeOfSupply: Indicates the type of supply for GST purposes.

  • MRPDetails: Displays the maximum retail price (MRP) of the item.

  • BatchalLocations: Shows details of the GODOWN locations where the stock is stored.

Xml Response:

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <STATUS>1</STATUS>
    </HEADER>
    <BODY>
        <DESC>
        </DESC>
        <DATA>
            <COLLECTION ISMSTDEPTYPE="Yes" MSTDEPTYPE="512">
                <STOCKITEM NAME="Azarak" RESERVEDNAME="">
                    <PARENT TYPE="String">Sarees</PARENT>
                    <GSTTYPEOFSUPPLY TYPE="String">Goods</GSTTYPEOFSUPPLY>
                    <BASEUNITS TYPE="String">pcs</BASEUNITS>
                    <HASMFGDATE TYPE="Logical">No</HASMFGDATE>
                    <OPENINGBALANCE TYPE="Quantity"> 100 pcs</OPENINGBALANCE>
                    <OPENINGVALUE TYPE="Amount">-1200000.00</OPENINGVALUE>
                    <GSTDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <GSTNOTIFICATIONDATE/>
                        <CALCULATIONTYPE/>
                        <REPORTINGUOM/>
                        <HSNCODE/>
                        <HSNMASTERNAME/>
                        <HSN/>
                        <SUPPLYTYPE/>
                        <TAXABILITY/>
                        <GSTNOTIFICATIONNUMBER/>
                        <GSTNATUREOFTRANSACTION/>
                        <NATUREOFGOODS/>
                        <SRCOFGSTDETAILS>As per Company/Stock Group</SRCOFGSTDETAILS>
                        <GSTCALCSLABONMRP/>
                        <ISREVERSECHARGEAPPLICABLE/>
                        <ISNONGSTGOODS/>
                        <GSTINELIGIBLEITC>Yes</GSTINELIGIBLEITC>
                        <INCLUDEEXPFORSLABCALC/>
                        <REVERSECHARGERATE>0</REVERSECHARGERATE>
                        <STATEWISEDETAILS.LIST>
                            <STATENAME>&#4; Any</STATENAME>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>CGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>SGST/UTGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>IGST</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>Cess</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>&#4; Not Applicable</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <RATEDETAILS.LIST>
                                <GSTRATEDUTYHEAD>State Cess</GSTRATEDUTYHEAD>
                                <GSTRATEVALUATIONTYPE>Based on Value</GSTRATEVALUATIONTYPE>
                                <GSTRATE>0</GSTRATE>
                                <GSTRATEPERUNIT>0</GSTRATEPERUNIT>
                            </RATEDETAILS.LIST>
                            <GSTSLABRATES.LIST>       </GSTSLABRATES.LIST>
                        </STATEWISEDETAILS.LIST>
                    </GSTDETAILS.LIST>
                    <HSNDETAILS.LIST>
                        <APPLICABLEFROM>20240401</APPLICABLEFROM>
                        <HSNCODE/>
                        <HSN/>
                        <HSNCLASSIFICATIONNAME/>
                        <SRCOFHSNDETAILS>As per Company/Stock Group</SRCOFHSNDETAILS>
                    </HSNDETAILS.LIST>
                    <LANGUAGENAME.LIST>
                        <NAME.LIST TYPE="String">
                            <NAME>Azarak</NAME>
                        </NAME.LIST>
                        <LANGUAGEID TYPE="Number"> 1033</LANGUAGEID>
                    </LANGUAGENAME.LIST>
                    <MRPDETAILS.LIST>
                        <FROMDATE>20240401</FROMDATE>
                        <MRPRATEDETAILS.LIST>
                            <PRIORSTATENAME/>
                            <STATENAME>&#4; Any</STATENAME>
                            <MRPRATE>1000.00/pcs</MRPRATE>
                        </MRPRATEDETAILS.LIST>
                    </MRPDETAILS.LIST>
                    <BATCHALLOCATIONS.LIST>
                        <MFDON/>
                        <GODOWNNAME>Main Location</GODOWNNAME>
                        <BATCHNAME>Primary Batch</BATCHNAME>
                        <OPENINGBALANCE> 100 pcs</OPENINGBALANCE>
                        <OPENINGVALUE>-1200000.00</OPENINGVALUE>
                        <OPENINGRATE>12000.00/pcs</OPENINGRATE>
                        <EXPIRYPERIOD/>
                    </BATCHALLOCATIONS.LIST>
                </STOCKITEM>
            </COLLECTION>
        </DATA>
    </BODY>
</ENVELOPE>

Conclusion

In conclusion, exporting data from Tally Prime using XML requests is a powerful method for efficiently retrieving various types of financial and inventory data. By understanding the structure and components of XML requests and responses, users can customize their data exports to meet specific business needs. Whether it's exporting ledgers, groups, stock items, or GST classifications, the flexibility of XML allows for detailed and precise data extraction, facilitating better financial analysis and decision-making.

0
Subscribe to my newsletter

Read articles from Bhavisha Amipara directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Bhavisha Amipara
Bhavisha Amipara