SVCURRENTGUID is not working in Tally XML request

Discussion in 'Tally Integration' started by PraveenKumarDS, May 24, 2019.

    
  1. PraveenKumarDS

    PraveenKumarDS New Member


    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.
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Any names.....Company Name, Ledger, Group etc..... having "&" characters....need to be presented as "&amp;"

    e.g. Tajmahal Palace & Tower .... should be "Tajmahal Palace &amp; Tower"

    this was my experience when i was importing data into Tally.........
     
    Last edited: May 24, 2019


  3. PraveenKumarDS

    PraveenKumarDS New Member


    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.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.
     


  5. PraveenKumarDS

    PraveenKumarDS New Member


    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.
     


  6. teja varma

    teja varma Active Member


    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
     


  7. Sachin Patel

    Sachin Patel New Member


    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.
     


Share This Page