Hi everyone, I'm trying to export the list of payables from Tally for a specific company through XML Request. I'm successful in doing it by setting <SVCURRENTCOMPANY> but if the Company name is changed or edited or if it contains any special characters like ampersand (&) then the subsequent XML request to tally will be failed. So I'm trying to use <SVCURRENTGUID> to avoid this problem so that even if we change the Company name then it will not be affected. However, setting SVCURRENTGUID is not working at all. Any help would be really appreciated. XML Request: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>Bills Payable</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVCURRENTGUID>ee1ecefb-bfe8-4ff5-9da7-eb621233492a</SVCURRENTGUID> <EXPLODEFLAG>Yes</EXPLODEFLAG> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> </DESC> </BODY> </ENVELOPE> Thanks is Advance.
Any names.....Company Name, Ledger, Group etc..... having "&" characters....need to be presented as "&" e.g. Tajmahal Palace & Tower .... should be "Tajmahal Palace & Tower" this was my experience when i was importing data into Tally.........
Thank you for your reply that will help with the ampersand case but I still wont be able to process it for Company edit cases.
Simple method....when you change Company or Edit company name.....quit Tally and start again............ Since you are using XML to export and it is not a report...there is no way to refresh other that quit and restart.
I'm trying to integrate a Third Party Application to Tally where I'll store the Company Name from Tally in the Third Party application during my first call to Tally and it is a one time setup. After that, subsequent requests to Tally will be made with that Company Name by setting SVCURRENTCOMPANY and if the Company name is changed then all the request to Tally will be failed after that. This is the main reason why I want to use the Company GUID by setting SVCURRENTGUID instead of relying on SVCURRENTCOMPANY which may gets changed at any point of time.
you have two options 1) the only way is to send a tdl xml request to tally you can customize your tdl so that in response you will get bills payable report and companyguid so you verify companyguid with you existing guid and update your data 2) you can use odbc from your application instead of xml http request for odbc you need to pass two queries a) select $openingbalance,$closingbalance,$group from billspayable b)select $guid from company so you will get billspayable collection and company guid too
It's simple, Whenever you are planning to get the payable data or any other requests, first you have to get all active company data and get the company name and guid from Tally itself and then pass the same company name for your request. You can save those data like company name , guid , etc. at somewhere in your application also which you can simply update and use.