1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Exporting Balance Sheet as XML response in a hierarchical format

Discussion in 'Tally Integration' started by Azad, Nov 6, 2020.

    
Tags:
  1. Azad

    Azad New Member


    Hello friends,

    Is it possible to get balance sheet report as XML response in hierarchical form just like as it appears in tally itself?

    The normal response for an XML balance sheet report will be as follows. As you can see everything is a root element. Is it possbile to include EQUITY SHARE CAPITAL under Capital Account etc. like a tree?

    <ENVELOPE>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Capital Account</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT></BSSUBAMT>
    <BSMAINAMT>100000.00</BSMAINAMT>
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>EQUITY SHARE CAPITAL</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>100000.00</BSSUBAMT>
    <BSMAINAMT></BSMAINAMT>
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Loans (Liability)</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT></BSSUBAMT>
    <BSMAINAMT></BSMAINAMT>
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Current Liabilities</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT></BSSUBAMT>
    <BSMAINAMT>62028.28</BSMAINAMT>
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>ELECTRICITY CHARGES PAYABLE</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>4326.00</BSSUBAMT>
    <BSMAINAMT></BSMAINAMT>
    </BSAMT>
    </ENVELOPE>


    Thanks in advance
    Azad
     
    Azad, Nov 6, 2020
    #1


  2. Himanshu-2002

    Himanshu-2002 Active Member


    Sir I don't think No one can change Tally XML Response... But I am not understanding that what is the problem in this response?
     
    Himanshu-2002, Nov 7, 2020
    #2


  3. Azad

    Azad New Member


    Thank you Himanshu.

    What I am looking for is a report in a hierarchical form just like in Tally software itself. In Tally's balance sheet report there is a main category and sub categories under it. For example, there are 2 main categories Assets and Liabilities. Under Assets there is Current Assets under which there is Cash In Hands etc.

    I am trying to create a program that shows report like I mentioned above. But from the XML response it is not possible to parse and form a hierarchical report. So is there any way by which we can configure balance sheet report or create a new report using TDL?

    Regards,
    Azad
     
    Azad, Nov 7, 2020
    #3


  4. Himanshu-2002

    Himanshu-2002 Active Member


    Enable Explode Flag and after that fetch response
     
    Himanshu-2002, Nov 7, 2020
    #4


  5. Azad

    Azad New Member


    I used the following code but response is the same. Ufortunately it is impossbile to make a category - subcategory view from the response.

    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>Export Data</TALLYREQUEST>
    </HEADER>
    <BODY>
    <EXPORTDATA>
    <REQUESTDESC>
    <REPORTNAME>Balance Sheet</REPORTNAME>
    <STATICVARIABLES>
    <SVCURRENTCOMPANY>Tally Knowledge - Payroll Sample Data</SVCURRENTCOMPANY>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    </STATICVARIABLES>
    </REQUESTDESC>
    </EXPORTDATA>
    </BODY>
    </ENVELOPE>


    <ENVELOPE>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Capital Account</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT>1200000.00</BSMAINAMT>
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Capital Account</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>1200000.00</BSSUBAMT>
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Loans (Liability)</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Current Liabilities</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT>-18214.00</BSMAINAMT>
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Provisions</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>EDLI Admin Charges @ 0.01%</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>EDLI Contribution @ 0.5%</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Employee's ESI Contribution @ 1.75%</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>-48.00</BSSUBAMT>
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Employee's PF Contribution @ 12%</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>13.00</BSSUBAMT>
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>ESI Payable</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>PF Admin Charges @ 1.10%</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>PF Payable</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>-1547.00</BSSUBAMT>
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Professional Tax</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>220.00</BSSUBAMT>
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>SALARY PAYABLE</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>-16852.00</BSSUBAMT>
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Profit &amp; Loss A/c</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT>-699669.02</BSMAINAMT>
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Current Assets</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT>-482116.98</BSMAINAMT>
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Closing Stock</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT />
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Loans &amp; Advances (Asset)</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>-8000.00</BSSUBAMT>
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Cash-in-hand</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>-14117.00</BSSUBAMT>
    <BSMAINAMT />
    </BSAMT>
    <BSNAME>
    <DSPACCNAME>
    <DSPDISPNAME>Bank Accounts</DSPDISPNAME>
    </DSPACCNAME>
    </BSNAME>
    <BSAMT>
    <BSSUBAMT>-459999.98</BSSUBAMT>
    <BSMAINAMT />
    </BSAMT>
    </ENVELOPE>
     
    Azad, Nov 7, 2020
    #5


Share This Page