I am able to export most of the data using below xml request in Tally ERP9 but the same query doesn't work in prime edition. Query : Code: <ENVELOPE> <HEADER> <TALLYREQUEST>Export Data</TALLYREQUEST> </HEADER> <BODY> <EXPORTDATA> <REQUESTDESC> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <REPORTNAME>Balance Sheet</REPORTNAME> </REQUESTDESC> </EXPORTDATA> </BODY> </ENVELOPE> Is there any xml query which will export all data of Balance Sheet from Tally ERP9 and Tally Prime.
I found the solution. To get the detailed balance sheet report in tally Prime , we have to use <EXPLODEFLAG>.Here is the updated query. Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <SUBTYPE>XML</SUBTYPE> <ID>BalanceSheet</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <EXPLODEFLAG>Yes</EXPLODEFLAG> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> </DESC> </BODY> </ENVELOPE>
The above query does not open the second level child that are present inside the balance sheet. It opens only the assets /liabilities that are present on first page of balance sheet. Please suggest alternate query where all the second or third level child inside balance sheet is expanded. OR I want request that the fetches the Profit & Loss A/c details only from the balance sheet. Any one of the solution would be helpful.