The below Xml request used to fetch master data from tally prime. Request: Code: "<ENVELOPE><HEADER><TALLYREQUEST>Export data</TALLYREQUEST></HEADER><BODY><EXPORTDATA><REQUESTDESC><REPORTNAME>List of Accounts</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>abc </SVCURRENTCOMPANY><SVFROMDATE>yymmdd</SVFROMDATE><SVTODATE>yymmdd</SVTODATE><SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT></STATICVARIABLES></REQUESTDESC></EXPORTDATA></BODY></ENVELOPE>" For New TALLY PRIME Version I am getting below error. Error: Older Prime Version query working fine.
I think Tally has disabled 'List of Accounts' Report. Use modern Collections approach to get 'List of Accounts'. It may be faster also;
Use this Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Collection</TYPE> <ID>ALLMasters</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <!-- * Static variables like scfrom,svto,svexport format will not work --> <!-- * Supports only xml format --> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <TDL> <TDLMESSAGE> <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="ALLMasters"> <TYPE>masters</TYPE> <!-- * will fetch all fields if you want specific fields you can specify --> <NATIVEMETHOD>*</NATIVEMETHOD> </COLLECTION> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
Update: Check for the line <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> In some Xml exports it is not accepted (in Prime 2.0.1). I have replied elsewhere that it has a bad side effect. It may affect next command.
This request works proper for Normal company. But For Group company I get following error: Code: --------------------------- Error --------------------------- Internal Error. Contact Tally Solutions. Software Exception c0000005 (Memory Access Violation ) --------------------------- OK --------------------------- How to solve this error?
Check company type when sending requesting (Group company is just container its don't have any transactions and masters) Its not throwing error if we are sending request to Child companies of group companies
use SVCurrentCompany, SVFromDate, SVToDate etc Code: <ENVELOPE><HEADER><TALLYREQUEST>Export data</TALLYREQUEST></HEADER><BODY><EXPORTDATA><REQUESTDESC><REPORTNAME>List of Accounts</REPORTNAME><STATICVARIABLES></STATICVARIABLES></REQUESTDESC></EXPORTDATA></BODY></ENVELOPE>