I am trying to export data using the following XML query: Code: <ENVELOPE><HEADER><VERSION>1</VERSION><TALLYREQUEST>Export</TALLYREQUEST><TYPE>Collection</TYPE><ID>Company Collection</ID></HEADER><BODY><DESC><STATICVARIABLES><SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT></STATICVARIABLES><TDL><TDLMESSAGE><COLLECTION NAME="Company Collection" ISMODIFY="No"><TYPE>Company</TYPE><FETCH>*</FETCH></COLLECTION></TDLMESSAGE></TDL></DESC></BODY></ENVELOPE> However, I've noticed that the address and CIN values are not fetched in the exported data. I have double-checked the TDL and XML query & tried adding individual tag name,but I couldn't find any specific issues. Please suggest how to modify the above query to fetch address and CIN values in the exported data. Or is there any other query available?
I Tried the COMPANYNUMBER tag . Did not get any CIN number information. Please suggest any alternate solution. Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Collection</TYPE> <ID>Company Collection</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <TDL> <TDLMESSAGE> <COLLECTION NAME="Company Collection" ISMODIFY="No"> <TYPE>Company</TYPE> <FETCH>COMPANYNUMBER</FETCH> </COLLECTION> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
I tried using the "corporateidentityno" tag to fetch the CIN detail of the company and this worked for me. Can anyone suggest a tag to fetch address of the company. Any alternate solution on how to fetch address of the company also would be helpful. Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Collection</TYPE> <ID>compcoll</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <TDL> <TDLMESSAGE> <COLLECTION NAME="compcoll" ISINITIALIZE="Yes"> <TYPE>Company</TYPE> <FETCH>corporateidentityno</FETCH> </COLLECTION> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
Address can be fetched using the following query Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Collection</TYPE> <ID>Company Collection</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <TDL><TDLMESSAGE> <COLLECTION NAME="Company Collection" ISMODIFY="No"> <TYPE>Company</TYPE> <FETCH>fullcompanyaddress</FETCH> </COLLECTION> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>