tally

Export Item-wise stock summary from Tally ERP 9


I am working with Tally ERP 9 (Accounting software) for export stock summary report.

I am able to export stock summary report through below xml request

<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Data</TYPE>
<ID>Stock Summary</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<EXPLODEFLAG>Yes</EXPLODEFLAG>
       <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
<SVCURRENTCOMPANY>Global Trading Corporation</SVCURRENTCOMPANY>
</STATICVARIABLES>
</DESC>
</BODY>
</ENVELOPE>

Now My question is How to export Stock Summary -> F5(Item-wise) report using xml request?


Solution

  • I am able to get Item Wise Stock Summary by by setting 'IsItemWise' variable as 'Yes'.

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Stock Summary</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
           <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVCURRENTCOMPANY>Global Trading Corporation</SVCURRENTCOMPANY>
    </STATICVARIABLES>
    <TDL>
      <TDLMESSAGE>
       <REPORT NAME="Stock Summary" ISMODIFY="Yes" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
        <SET>IsItemWise: Yes</SET>
       </REPORT>
      </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>