Thursday, November 29, 2012

Example : Tally - XML Integration

Tally - XML Request / Response

Let us consider different scenarios to understand the Request and Response XML structure.
  • ExportRequest to Export Data and Corresponding response.
  • Import - Request to Import Data and the Corresponding response.
  • Execute - Request to Execute Action and Corresponding response.
Export

Tags used for sending a request to export data from Tally.ERP 9.
<HEADER> contains the following:
  • Tag <TALLYREQUEST> must contain value Export
  • Tag <TYPE> must contain value Data
  • Tag <ID> should contain the Name of the TDL Report
<BODY> contains the following:
  • Tag <DESC> can contain report settings like Company Name, Format, etc. as desired which should be enclosed within <STATICVARIABLES> tag.
  • If the Report Name specified in the <ID> tag does not exist within Tally running at the spec­ified port, the TDL defining the Report & other supporting definition needs to be described and enclosed within tag <TDL>.
Example :  Request for a detailed Trial Balance in XML Format from Tally.

<ENVELOPE>
     <HEADER>
             <VERSION>1</VERSION>
             <TALLYREQUEST>Export</TALLYREQUEST>
             <TYPE>Data</TYPE>
             <ID>Trial Balance</ID>
     </HEADER>
     <BODY>
             <DESC>
                     <STATICVARIABLES>
                               <EXPLODEFLAG>Yes</EXPLODEFLAG>
                               <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                     </STATICVARIABLES>
             </DESC>
     </BODY>
</ENVELOPE>

In the above XML request, <HEADER> describes the expected result.
  • The value of the Tag <TALLYREQUEST> is Export which indicates that some information needs to be exported from Tally.
  • The value of the Tag <TYPE> is Data which indicates that the data needs to be exported from Tally.
  • The value of the Tag <ID> must be a TDL Report Name, if the previous Tag <TYPE> con­tains Data and Tag <TALLYREQUEST> contains Export. Any Report which needs to be exported from Tally can be specified within this Tag.
  • <BODY> Tag contains parameters, if any. Additional settings for the report like format required, company from which data is required, etc. can be passed within <STATICVARIA­BLES> Tag enclosed within <DESC> Tag. All variables are considered as Tag Names and their value are enclosed within these tags. For e.g., in the above XML, variables SVEX­PORTFORMAT and EXPLODEFLAG are considered as Tags and their respective values $$SysName:XML and Yes are enclosed within. TDL Internal Function SysName is evalu­ated at Tally end and the response is being sent accordingly.
XML Response received From Tally

<ENVELOPE>
         <DSPACCNAME>
                  <DSPDISPNAME>Capital Account</DSPDISPNAME>
         </DSPACCNAME>
         <DSPACCINFO>
                  <DSPCLDRAMT>
                           <DSPCLDRAMTA></DSPCLDRAMTA>
                  </DSPCLDRAMT>
                  <DSPCLCRAMT>
                           <DSPCLCRAMTA>100000.00</DSPCLCRAMTA>
                  </DSPCLCRAMT>
         </DSPACCINFO>
         <DSPACCINFO>
                  <DSPCLDRAMT>
                           <DSPCLDRAMTA>-100000.00</DSPCLDRAMTA>
                  </DSPCLDRAMT>
                  <DSPCLCRAMT>
                           <DSPCLCRAMTA></DSPCLCRAMTA>
                  </DSPCLCRAMT>
         </DSPACCINFO>
           .
           .
           .
          </DSPACCNAME>
</ENVELOPE>

Import

Tally can import data objects either in the form of a Master or Voucher.
<HEADER> contains the following
  • Tag <TALLYREQUEST> must contain value Import
  • Tag <TYPE> must contain value Data and
  • Tag <ID> should contain the Import TDL Report i.e., either All Masters or Vouchers.
<BODY> contains the following
  • Tag <DESC> can contain report settings like Company Name, behavior of Import in case of duplicates found; as desired which should be enclosed within <STATICVARIABLES> Tag.
  • Tag <DATA> must contain the XML Data Fragment within Tag <TALLYMESSAGE> that needs to be imported
Example : Request for importing Master data in Tally

<ENVELOPE>
          <HEADER>
                    <VERSION>1</VERSION>
                    <TALLYREQUEST>Import</TALLYREQUEST>
                    <TYPE>Data</TYPE>
                    <ID>All Masters</ID
          </HEADER>
          <BODY>
                    <DESC>
                             <STATICVARIABLES>
                                        <IMPORTDUPS>@@DUPCOMBINE</IMPORTDUPS>
                             </STATICVARIABLES>
                    </DESC>
                    <DATA>
                             <TALLYMESSAGE>
                                        <LEDGER NAME="ICICI" Action = "Create">
                                                  <NAME>ICICI</NAME>
                                                  <PARENT>Bank Accounts</PARENT>
                                                  <OPENINGBALANCE>-12500</OPENINGBALANCE>
                                        </LEDGER>
                                        <GROUP NAME=" Bangalore Debtors" Action = "Create">
                                                   <NAME>Bangalore Debtors</NAME>
                                                   <PARENT>Sundry Debtors</PARENT>
                                        </GROUP>
                                        <LEDGER NAME="RK Builders Pvt Ltd" Action = "Create">
                                                   <NAME>RK Builders Pvt Ltd</NAME>
                                                   <PARENT>Bangalore Debtors</PARENT>
                                                   <OPENINGBALANCE>-1000</OPENINGBALANCE>
                                        </LEDGER>
                             </TALLYMESSAGE>
                    </DATA>
          </BODY>
</ENVELOPE>

In the above XML Request, Create action is used. Any of the following system formulae can be used to choose the required behavior in case the system encounters a ledger with the same name. The behavior is for the treatment of the Opening Balance which is being imported.
  • DupModify specifies that the current Opening Balance should be modified with the new one that is being imported.
  • DupIgnoreCombine specifies that the ledger if exists need to be ignored.
  • DupCombine specifies the system to combine both the Opening Balances. Ideally, this option is used when Data pertaining to Group Companies are merged together into a single company. 
On processing the above request for importing ledgers, the requested ledgers are created in Tally. 

XML Response received From Tally.

<RESPONSE>
           <CREATED>2</CREATED>
           <ALTERED>0</ALTERED>
           <LASTVCHID>0</LASTVCHID>
           <LASTMID>0</LASTMID>
           <COMBINED>0</COMBINED>
           <IGNORED>0</IGNORED>
           <ERRORS>0</ERRORS>
</RESPONSE>

The above XML Response is a log of masters created, altered, combined, ignored or not imported due to some errors. It also contains information pertaining to the last Master ID imported. For Alteration and Deletion of Masters, the Object action needs to be Alter or Delete respectively.

For instance, in the above example,

<LEDGER NAME="ICICI" Action = "Alter">
          <NAME>HDFC</NAME>

Name of an existing ledger ICICI will get altered to HDFC.

In case of Deletion, following line suffices

<LEDGER NAME="ICICI" Action = "Delete">

Execute

Tags used for sending a request to Execute an action from Tally.ERP 9.
<HEADER> contains the following:
  • Tag <TALLYREQUEST> must contain value Execute
  • Tag <TYPE> must contain value TDLAction and
  • Tag <ID> should contain the Name of the TDL Action
Example : Request for Executing Synchronization in Tally

<ENVELOPE>
           <HEADER>
                    <VERSION>1</VERSION>
                    <TALLYREQUEST>Execute</TALLYREQUEST>
                    <TYPE>TDLAction</TYPE>
                    <ID>Sync</ID>
           </HEADER>
</ENVELOPE>

In the above XML request, <HEADER> describes the expected result.
  • The value of the Tag <TALLYREQUEST> is Execute which indicates that some action needs to be executed in Tally.
  • The value of the Tag <TYPE> is TDLAction which indicates that some TDLAction has to be executed in Tally.
  • The value of the Tag <ID> must be a TDL Action Name. Any action which needs to be exe­cuted in Tally can be specified within this Tag.
Response XML Fragment for the above would be:

<ENVELOPE>
          <HEADER>
                    <VERSION>1</VERSION>
                    <STATUS>1</STATUS>
          </HEADER>
</ENVELOPE>

78 comments:

  1. how to add a ledger to tally using visual basic

    ReplyDelete
    Replies
    1. Thanks..!
      Very useful information you provided.
      Also I tried XLTOOL Excel to Tally utility for Auto entry & fast work.
      Link - http://www.xltally.in

      Delete
    2. This comment has been removed by the author.

      Delete
    3. Useful tool for Excel to Tally
      Download : https://www.rtslink.com/downloads/

      Delete
  2. create the connection with tally port no. 9000 and send the above xml as the request u can create the connection as follows

    String Url = "http://localhost:9000/";

    String SOAPAction = "";

    String Voucher = "//write ur xml file here";

    // Create the connection where we're going to send the file.
    URL url = new URL(Url);
    URLConnection connection = url.openConnection();
    HttpURLConnection httpConn = (HttpURLConnection) connection;


    ByteArrayInputStream bin = new ByteArrayInputStream(Voucher.getBytes());
    ByteArrayOutputStream bout = new ByteArrayOutputStream();

    // Copy the SOAP file to the open connection.

    copy(bin, bout);

    byte[] b = bout.toByteArray();

    // Set the appropriate HTTP parameters.
    httpConn.setRequestProperty("Content-Length", String.valueOf(b.length));
    httpConn.setRequestProperty("Content-Type", "text/xml; charset=utf-8");
    httpConn.setRequestProperty("SOAPAction", SOAPAction);
    httpConn.setRequestMethod("POST");
    httpConn.setDoOutput(true);
    httpConn.setDoInput(true);

    // Everything's set up; send the XML that was read in to b.
    OutputStream out = httpConn.getOutputStream();
    out.write(b);
    out.close();

    // Read the response and write it to standard out.

    InputStreamReader isr =
    new InputStreamReader(httpConn.getInputStream());
    BufferedReader in = new BufferedReader(isr);

    String inputLine;

    while ((inputLine = in.readLine()) != null) {
    System.out.println(inputLine);
    }

    in.close();
    }

    public static void copy(InputStream in, OutputStream out)
    throws IOException {

    // do not allow other threads to read from the
    // input or write to the output while copying is
    // taking place

    synchronized (in) {
    synchronized (out) {

    byte[] buffer = new byte[256];
    while (true) {
    int bytesRead = in.read(buffer);
    if (bytesRead == -1) {
    break;
    }
    out.write(buffer, 0, bytesRead);
    }
    }
    }
    }

    public static void main(String[] args) throws Exception {
    tallyRequest r = new tallyRequest();
    r.SendToTally();
    }
    }

    ReplyDelete
  3. Can you give sample xml for importing day book in tally erp.9. I am facing problem while importing xml created with excel.

    ReplyDelete
    Replies
    1. please put some more light and clearify that , do u want to import whole day book information to tally ??? or u want to export the day book information from tally ???

      Delete
    2. Will i get sample xml formats to import masters and vouchers with gst itemwise.

      Delete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Want to import day book information to tally

    ReplyDelete
    Replies
    1. pass me your email-id i will send u the format there , as i am not allowed to post the tag formatted text here..

      Delete
    2. Can you give sample xml for importing day book in tally erp.9. I am facing problem while importing xml created with Asp.net C# Application
      My Email Id =rajeev.sinha1991@gmail.com

      Delete
    3. can you give me the sample xml formats to to pass master and vouchers with items to TAlly.ErP9 GST.
      MY Email: survittal@gmail.com

      Delete
    4. Sir, kinldy send xml format for day book import to tally, and also, if it possible kindl send the details for generating xml format by VB 6 coding also please

      Delete
    5. share the details to sscabusy@gmail.com

      Delete
  6. Hi,

    Want to import masters through XML, based on the alias name the name and the address details should change.

    ReplyDelete
  7. can we get xsd's for these Report formats?

    ReplyDelete
  8. Can u pls share the xml request for exporting vouchers with consumption values through tally http interface. It will be really helpful.
    Thanks

    ReplyDelete
  9. @Prashant Bujone no tally has not provided any support for getting the Xsd,s you have to make ur hands dirty, and put some effort uaself to write them , or u can use some third party software once u have the correct xml format .

    ReplyDelete
  10. @Dipti Fulwani i am not allowed to post tag formatted text here, u can get connected via email irfanshafi20@gmail.com , it will be pleasure if i could help u out thank u

    ReplyDelete
  11. Anybody can help me to get godownwise stock item closing balance (for each stock item) using xml integration

    ReplyDelete
  12. I am unable to Fetch the Daybook entries for a particular date can you help me in fetching(Exporting) the DayBook Entries for a particular date or fetch the entries by the voucher key or voucher id . i am trying to fetch the daybook entries for a particular date but in response i am getting all the entries made for other dates also i.e all the entries.
    Either of the ways will help me XML(Soap) or ODBC

    ReplyDelete
  13. Dim xmlhttp As Object
    Dim webURL As String = "http://localhost:9002"

    xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")

    xmlhttp.Open("POST", webURL, False)
    xmlhttp.send(rtbxml.Text.ToString())
    MsgBox(xmlhttp.ResponseText)
    xmlhttp = Nothing

    'rtbxml is a name of the rich text box

    powered by http://imaster.in

    ReplyDelete
  14. Hi... I'm looking for a Tally TDL Developer on freelance basis to a big project. The TDL Developers should have worked with integrating the Tally with Web Applications. If anybody is interested plz. mail me at mramcrm at gmail dot com

    ReplyDelete
  15. Can someone help me by providing sample VB.Net code to get data from Tally ERP9 into XML? This will be later processed and updated in SQL Server tables.

    Thanks in Advance
    Varadarajan R

    ReplyDelete
  16. Can someone help me by providing sample VB.Net code to get data from Tally ERP9 into XML? This will be later processed and updated in SQL Server tables.

    Thanks in Advance
    Varadarajan R

    ReplyDelete
  17. Can someone help me by providing sample VB.Net code to insert data to Tally ERP9 from SQL server

    ReplyDelete
  18. Is it possible to import data into Tally via XMLHTTPRequest-Post method-from an web application?I am getting an error Access is denied.

    ReplyDelete
    Replies
    1. I tried it in Internet explorer & the request body in String format.
      Although you get 'Access denied'
      in Firebox, still i got the data posted to tally.

      Delete
  19. Any body share the xml request for exporting vouchers/Ledger with consumption values through tally http interface when the Voucher created/modify. It will be really great help.
    Thanks in advance.

    ReplyDelete
  20. How can i export Stock Summary With Opening Balance from tally Erp9 using XML request.

    ReplyDelete
  21. Is there any dictioanry/specification document available which explains the various XML messages in details.I mean details about each tag[e.g. what type of data expected for this,min/max length of data ,max occurances ,if there is date /currency /measurement value then what are acceptable formats etc..].Is there any standard document provided by Tally whcih contains this information?

    ReplyDelete
  22. Is there any dictioanry/specification document available which explains the various XML messages in details.I mean details about each tag[e.g. what type of data expected for this,min/max length of data ,max occurances ,if there is date /currency /measurement value then what are acceptable formats etc..].Is there any standard document provided by Tally whcih contains this information?

    ReplyDelete
  23. Is there any dictioanry/specification document available which explains the various XML messages in details.I mean details about each tag[e.g. what type of data expected for this,min/max length of data ,max occurances ,if there is date /currency /measurement value then what are acceptable formats etc..].Is there any standard document provided by Tally whcih contains this information?

    ReplyDelete
  24. Hi,
    can we export data from tally through http request

    ReplyDelete
  25. Hi,
    Can any one help me to create Company Name in tally using XML+PHP

    Thanks & Regards,
    Prasad N.

    ReplyDelete
    Replies
    1. Hi,
      I am sumanth , i am also looking for xml tag for creating company. Please, if you find the solution can you please help me out.

      Thank you.

      Delete
  26. Hi,
    Can any one help me to create Company Name in tally using XML+C#.net

    Thanks & Regards,
    Sumanth .

    ReplyDelete
  27. Hi,
    Can any one help me to create monthly wise sales report in tally using XML+C#.net

    Thanks & Regards,
    Sumanth .

    ReplyDelete
  28. Dear All,
    Can any one help me to Check Whether the Supplier Invoice Already exist or not while make Sync from asp.net to Tally integration

    ReplyDelete
  29. Hi,
    I want to get trialbalance report ledger-wise then what are the parameters for xml request?

    ReplyDelete
  30. please tell me how to export data from tally to excel via soap.

    ReplyDelete
  31. please tell me how make xml request to cost center wise breakup details

    ReplyDelete
    Replies
    1. Hey Leela,

      If you know how to get breakup details via Xml request. Please send me an example at srinivasagudla@gmail.com. Thanks

      Delete
  32. Thanks sir for the Tutorial,
    But sir The example for Importing,i.e,is Not Working
    Example : Request for importing Master data in Tally.
    I am a Newbie in Tally Development,What are the possible reasons.
    Please Reply ASAP.

    ReplyDelete
  33. Sir whenever we import same xml file for voucher entry a new entry will post every time. so how to handel it and keywords are used for duplicate modification.

    ReplyDelete
  34. Need xml to create vouchers with cost centres in tally from Visual Basic

    ReplyDelete
  35. XML to create vouchers with cost centres in tally from Visual Basic

    ReplyDelete
  36. hello every one i am shan. i done tally on mobile and browser by java.

    ReplyDelete
  37. hi every one ,Receivable tag how sub ledger fetch

    ReplyDelete
  38. I want to get all today sales details or sales register details for a day via XML API form tally. Can you please share xml structire

    ReplyDelete
  39. I want to show Export data in table structure using php.
    Example: I want to show trial balace in table structure using php.

    ReplyDelete
  40. Good article..Just want to know can we fetch ledger details using MasterId/GuId in XML?

    ReplyDelete
  41. Hi All

    After export xml from customized debit note we are getting the xml as below format.



    -







    -10136.64
    ...
    ...
    ...


    In that xml we are not getting header and body part. We trying to integrate with java.
    Without complete xml we are unable to communicate with tally.

    please help me and suggest a way.

    ReplyDelete
  42. This comment has been removed by the author.

    ReplyDelete
  43. Hi

    After export xml from customized debit note we are getting the xml as below format.











    In that xml we are not getting header and body part. We trying to integrate with java.
    Without complete xml we are unable to communicate with tally.

    please help me and suggest a way.

    ReplyDelete
  44. Hi I am trying to read bills outstanding report from tally. But problem occurring is it gives response perfectly fine on our development server with data of live server, and gives corrupt response (??????????????????????????) in live server environment. What can be the reason behind it?

    Below is the request format.



    1
    Export
    Data
    Bills Receivable






    Below is the ideal response format:- (Receiving Properly on development server)



    3-May-2011
    ABC/00870/11-12
    ABCD Comapny Name

    -557.00

    2524

    26-May-2011
    XYZ/01010/11-12
    ABCD Comapny Name

    -557.00

    2501

    23-Jun-2011
    XYZ/01199/11-12
    WERT Comapny Name

    -11768.00

    2473


    But in actual I am receiving this (On live server)

    ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????�?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

    ReplyDelete
  45. HII ANYONE PLEASE PROVIDE TDL FOR COMMODITY WISE SALES & PURCHASE

    ReplyDelete
  46. I am trying to post 10000 vouchers through my VB.net program to tally.



    It was giving a response Unknown Request, cannot be processed



    So I split the 10000 vouchers into files containing 50 vouchers each. Then it went through.



    Even when I try to send 100 vouchers each, it gave this error for one of the files.



    The errored out file goes through when I try to import via Tally software – Import vouchers option.



    Hoping you can help me figure out this.

    ReplyDelete
  47. Unknown Request, cannot be processed.please give that solution

    ReplyDelete
    Replies
    1. It was because of chr(10) and chr(13) in the input.

      Delete
  48. Hi ! Need help to export data from excel to tally

    ReplyDelete
  49. hi i need help please provide XML for Receivable with Opening Balance
    i am currently using the following xml and didnt get any response with opening balance





    Export Data



    ReplyDelete
  50. Hi please any one can give me The XML file to delete specific sales voucher from Tally Erp 9

    ReplyDelete
  51. Hello,

    I want to export Deleted vouchers from Tally.What will be the XMl format for that ?

    Currently i am using below xml format



    1
    Export
    Collection
    List of All Sales Vouchers




    $$SysName:XML
    ###STARTDATE###
    ###ENDDATE###




    Voucher

    ADDRESS.LIST,BASICBUYERADDRESS.LIST,DATE,CLASSNAME,PARTYNAME,PERSISTEDVIEW,BASICDUEDATEOFPYMT,LEDGERENTRIES.LIST,NARRATION,TAXUNITNAME,VOUCHERTYPENAME,VOUCHERNUMBER,PARTYLEDGERNAME,CSTFORMISSUETYPE,
    CSTFORMRECVTYPE,FBTPAYMENTTYPE,VCHGSTCLASS,ENTEREDBY,EFFECTIVEDATE,HASCASHFLOW,GUID,MASTERID,DIFFACTUALQTY,ASORIGINAL,FORJOBCOSTING,ISOPTIONAL,USEFOREXCISE,USEFORINTEREST,USEFORGAINLOSS,
    USEFORGODOWNTRANSFER,USEFORCOMPOUND,USEFORSERVICETAX,EXCISETAXOVERRIDE,ISTDSOVERRIDDEN,ISTCSOVERRIDDEN,ISVATOVERRIDDEN,ISSERVICETAXOVERRIDDEN,ISEXCISEOVERRIDDEN,ISCANCELLED,ISPOSTDATED,USETRACKINGNUMBER,
    ISINVOICE,MFGJOURNAL,HASDISCOUNTS,ASPAYSLIP,ISCOSTCENTRE,ISSTXNONREALIZEDVCH,ISBLANKCHEQUE,ISVOID,ISONHOLD,ORDERLINESTATUS,ISDELETED,ALTERID,REFERENCE,ACTIVETO,AUDITEDON,AUTOCOSTLEVEL,CSTFORMISSUENUMBER,
    CSTFORMRECVNUMBER,BASICVOUCHERCHEQUENAME,BASICVOUCHERCROSSCOMMENT,BUYERSCSTNUMBER,BASICSHIPPEDBY,BASICDESTINATIONCOUNTRY,BASICBUYERNAME,BASICPLACEOFRECEIPT,BASICSHIPDOCUMENTNO,BASICPORTOFLOADING,
    BASICPORTOFDISCHARGE,BASICFINALDESTINATION,BASICORDERREF,BASICSHIPVESSELNO,BASICBUYERSSALESTAXNO,BASICSERIALNUMINPLA,BASICDATETIMEOFINVOICE,BASICDATETIMEOFREMOVAL,CSTFORMISSUEDATE,CSTFORMRECVDATE,
    CONSIGNEECSTNUMBER,EXCHGCURRENCYNAME,EXCISENOTIFICATIONNO,EXCISEUNITNAME,EXCISETREASURYNUMBER,EXCISETREASURYNAME,FBTFROMDATE,FBTTODATE,FORM16ISSUEDATE,ISATTDDATAPRESERVED,NATUREOFSALES,POSCARDLEDGER,
    POSCASHLEDGER,POSGIFTLEDGER,VOUCHERKEY,SERIALMASTER,SERIALNUMBER,EXCHGRATE,AUDITED,POSCHEQUELEDGER,POSCARDNUMBER,POSCHEQUENUMBER,POSCHEQUEBANKNAME,PRICELEVEL,RECONCILATIONDATE,STATADJUSTMENTTYPE,
    TAXCHALLANDATE,TAXCHEQUEDATE,TAXBANKCHALLANNUMBER,TAXCHALLANBSRCODE,TAXCHEQUENUMBER,TAXBANKNAME,TAXBANKBRANCHNAME,TAXBANKACCOUNTNUMBER,TAXADJUSTMENT,CHALLANTYPE,CHEQUEDEPOSITORNAME,
    REQUESTORRULE,EXCISEOPENING,USEFORFINALPRODUCTION,POSCASHRECEIVED,VATDEALERTYPE,BASICORDERTERMS,ISFORJOBWORKIN,ALLOWCONSUMPTION,COSTCENTRENAME,BASICBASEPARTYNAME,EMPLOYEEENTRIES.LIST,INVENTORYENTRIES.LIST

    ALTER_KEY


    $ALTERID > ##ALTERIDVALUE##





    ReplyDelete
  52. I am exporting through API (XML Request) i need to fetch particular company ledgers credit voucher entries) Same as when i am exporting from tally manually it gives me options like All vocuhers, credit entries,debit entries likewise. For this purpose i have soap request but i did not get that where to mention that i needed only credit entries.
    Following is my API Request:


    Export Data
    Data
    Vouchers






    20180101

    Ledger Vouchers


    20181231

    $$SysName:XML

    ABC Ledger Name




    ReplyDelete
    Replies
    1. This is my xml request i want fetch only credit entries for a ledger.
      <ENVELOPE>
      <HEADER>
      <TALLYREQUEST>Export Data</TALLYREQUEST>
      </HEADER>
      <BODY>
      <EXPORTDATA>
      <REQUESTDESC>
      <STATICVARIABLES>
      <SVFROMDATE>20180101</SVFROMDATE>
      <SVTODATE>20181231</SVTODATE>
      <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
      <!--Specify the LedgerName here-->
      <LEDGERNAME>Ledger Name</LEDGERNAME>
      </STATICVARIABLES>
      <!--Report Name-->
      <REPORTNAME>Ledger Vouchers</REPORTNAME>
      </REQUESTDESC>
      </EXPORTDATA>
      </BODY>
      </ENVELOPE>

      Delete
  53. Hi I am importing my erp data to tally purchase voucher and its working
    but I am not able to send cost center class ...
    can anyone help me with this????

    ReplyDelete
  54. how to import Ledgers Master from tally using vba?

    ReplyDelete
  55. how to get tally all report like GSTR1 and invoice print using xml request

    ReplyDelete
  56. Hi any one working with HTTP JSON features.

    ReplyDelete
  57. [ Collection : JSONTedting]
    Export header :"Authorization:abcxyz
    Data source : HTTP JSON:"https://ABC.com/api/inv/myvalue?oid=123"
    JSON object path: " inv:1"
    Fetch: *.*

    In the place of "myvalue" I want to pass the any variable value.

    How we will the variable value in it. If myvalue is variable and I am trying to write it ##myvariable then it not work. Please help me.

    ReplyDelete
    Replies
    1. Actually I want to pass the dynamic variable in JSON instead of static variable( myvalue).

      Delete
  58. please help me Export day book only from Tally

    ReplyDelete
  59. please help me Export day book only from Tally

    ReplyDelete
  60. I'm Абрам Александр a businessman who was able to revive his dying lumbering business through the help of a God sent lender known as Benjamin Lee the Loan Consultant. Am resident at Yekaterinburg Екатеринбург. Well are you trying to start a business, settle your debt, expand your existing one, need money to purchase supplies. Have you been having problem trying to secure a Good Credit Facility, I want you to know that Mr Benjamin will see you through. Is the right place for you to resolve all your financial problem because am a living testimony and i can't just keep this to myself when others are looking for a way to be financially lifted.. I want you all to contact this God sent lender using the details as stated in other to be a partaker of this great opportunity Email: 247officedept@gmail.com  Or  WhatsApp/Text +1-989-394-3740.

    ReplyDelete
  61. how to fetch supplier data in tally xml

    ReplyDelete