Integration Capabilities

Tally Integration Capabilities

How to Integrate PHP with Tally using XML

Tally Interfaces – For Integration PHP Sample Code

How to Export data from tally using php?

<?php
    $requestXML = '<ENVELOPE>'.
      '<HEADER>'.
      '<TALLYREQUEST>Export Data</TALLYREQUEST>'.
      '</HEADER>'.
      '<BODY>'.
      '<EXPORTDATA>'.
      '<REQUESTDESC>'.
      '<REPORTNAME>Daybook</REPORTNAME>'.
      '<STATICVARIABLES>'.
      '<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>'.
      '</STATICVARIABLES>'.
      '</REQUESTDESC>'.
      '</EXPORTDATA>'.
      '</BODY>'.
      '</ENVELOPE>';

$serverip = "localhost:9000";
$curl = curl_init($serverip);

curl_setopt($curl, CURLOPT_HTTPHEADER, array('Accept-Charset:UTF-8'));
$contentarray = array("content-type:text/xml;charset:UTF-8");
curl_setopt($curl, CURLOPT_HTTPHEADER, $contentarray);
curl_setopt($curl,CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl, CURLOPT_HEADER, 0);
curl_setopt($curl, CURLOPT_POST, 1);
curl_setopt($curl, CURLOPT_POSTFIELDS, $requestXML); // post the xml
curl_setopt($curl, CURLOPT_TIMEOUT, 300000); // set timeout in seconds
curl_setopt($curl,CURLOPT_ENCODING,"UTF-8");
$xmlstr = curl_exec ($curl);
if (!$xmlstr) die("No Response from tally: Curl");
// var_dump(curl_getinfo($curl, CURLINFO_CONTENT_TYPE));
curl_close ($curl);
echo ($xmlstr);

How to export employees List from tally using xml request

Employee List from Tally using XML Tags

<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>EXPORT</TALLYREQUEST>
<TYPE>Collection</TYPE>
<ID>List of All Employees</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
</STATICVARIABLES>
</DESC>
</BODY>
</ENVELOPE>

How to Fetch Tally Products Price List Using xml request

Tally Interfaces – Item wise Price list XML Sample Code

How to Export Item wise Name,Closing stock,Value and Price from tally using XML TAGS via http

How to fetch the "price list" from tally using http xml request.

<ENVELOPE>
<HEADER>
      <VERSION>1</VERSION>
      <TALLYREQUEST>Export</TALLYREQUEST>
      <TYPE>Collection</TYPE>
      <ID>All items under Groups</ID>
</HEADER>
<BODY>
<DESC>
   <STATICVARIABLES>
            <SVCURRENTCOMPANY>company</SVCURRENTCOMPANY>
            <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
         </STATICVARIABLES>
   <TDL>
    <TDLMESSAGE>
     <COLLECTION NAME="All items under Groups" ISMODIFY="No">
      <TYPE>stock item</TYPE>
      <FETCH>Name,Parent,BaseUnits,ClosingBalance,ClosingRate,
ClosingValue,FULLPRICELIST</FETCH>
     </COLLECTION>
    </TDLMESSAGE>
   </TDL>
</DESC>
</BODY>
</ENVELOPE>

Sample code for above xml integration with php, asp, .net
How to integrate PHP with Tally ,
How to integrate .net with Tally

Create Sales Order using xml request to Tally erp 9

How to Create Sales Order using xml request to Tally erp 9

<ENVELOPE>
<HEADER>
<TALLYREQUEST>Import Data</TALLYREQUEST>
</HEADER>
<BODY>
<IMPORTDATA>
<REQUESTDESC>
<REPORTNAME>All Masters</REPORTNAME>
<STATICVARIABLES>
<SVCURRENTCOMPANY>company</SVCURRENTCOMPANY>
</STATICVARIABLES>
</REQUESTDESC>
<REQUESTDATA>

<TALLYMESSAGE xmlns:UDF="TallyUDF">
<VOUCHER VCHTYPE="Sales Order" ACTION="Create">
<DATE>#fromdate</DATE>
<PARTYNAME>CustomerName</PARTYNAME>
<VOUCHERTYPENAME>Sales Order</VOUCHERTYPENAME>
<VOUCHERNUMBER>4</VOUCHERNUMBER>
<REFERENCE>14</REFERENCE>
<PARTYLEDGERNAME>A.R.AUTO PARTS</PARTYLEDGERNAME>
<BASICBASEPARTYNAME>A.R.AUTO PARTS</BASICBASEPARTYNAME>
<FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE>
<PERSISTEDVIEW>Invoice Voucher View</PERSISTEDVIEW>
<BASICBUYERNAME></BASICBUYERNAME>

<LEDGERENTRIES.LIST>
<OLDAUDITENTRYIDS.LIST TYPE="Number">
        <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS>
       </OLDAUDITENTRYIDS.LIST>
<LEDGERNAME>A.R.AUTO PARTS</LEDGERNAME>
     <GSTCLASS/>
       <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
       <LEDGERFROMITEM>No</LEDGERFROMITEM>
       <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
       <ISPARTYLEDGER>Yes</ISPARTYLEDGER>
       <ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE>
       <AMOUNT>-3259.55</AMOUNT>
    <BANKALLOCATIONS.LIST>       </BANKALLOCATIONS.LIST>
       <BILLALLOCATIONS.LIST>       </BILLALLOCATIONS.LIST>
       <INTERESTCOLLECTION.LIST>       </INTERESTCOLLECTION.LIST>
       <OLDAUDITENTRIES.LIST>       </OLDAUDITENTRIES.LIST>
       <ACCOUNTAUDITENTRIES.LIST>       </ACCOUNTAUDITENTRIES.LIST>
       <AUDITENTRIES.LIST>       </AUDITENTRIES.LIST>
       <TAXBILLALLOCATIONS.LIST>       </TAXBILLALLOCATIONS.LIST>
       <TAXOBJECTALLOCATIONS.LIST>       </TAXOBJECTALLOCATIONS.LIST>
       <TDSEXPENSEALLOCATIONS.LIST>       </TDSEXPENSEALLOCATIONS.LIST>
       <VATSTATUTORYDETAILS.LIST>       </VATSTATUTORYDETAILS.LIST>
       <COSTTRACKALLOCATIONS.LIST>       </COSTTRACKALLOCATIONS.LIST>
</LEDGERENTRIES.LIST>

<ALLINVENTORYENTRIES.LIST>
<STOCKITEMNAME>01-0\11332W STD</STOCKITEMNAME>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>
<ISAUTONEGATE>No</ISAUTONEGATE>
<ISCUSTOMSCLEARANCE>No</ISCUSTOMSCLEARANCE>
<ISTRACKCOMPONENT>No</ISTRACKCOMPONENT>
<ISTRACKPRODUCTION>No</ISTRACKPRODUCTION>
<ISPRIMARYITEM>Yes</ISPRIMARYITEM>
<ISSCRAP>No</ISSCRAP>
<RATE>1100.05/Nos</RATE>
<AMOUNT>2200.10</AMOUNT>
<ACTUALQTY>2 Nos</ACTUALQTY>
<BILLEDQTY>2 Nos</BILLEDQTY>

   <BATCHALLOCATIONS.LIST>
        <BATCHNAME>Primary Batch</BATCHNAME>
        <INDENTNO/>
        <ORDERNO>5</ORDERNO>
        <TRACKINGNUMBER/>
        <DYNAMICCSTISCLEARED>No</DYNAMICCSTISCLEARED>
        <AMOUNT>2200.10</AMOUNT>
        <ACTUALQTY> 2 Nos.</ACTUALQTY>
        <BILLEDQTY> 2 Nos.</BILLEDQTY>
        <ORDERDUEDATE>27-Oct-2015</ORDERDUEDATE>
        <ADDITIONALDETAILS.LIST>        </ADDITIONALDETAILS.LIST>
        <VOUCHERCOMPONENTLIST.LIST>        </VOUCHERCOMPONENTLIST.LIST>
        <UDF:SHIPPEDBY.LIST DESC="`Shipped By``SpeedProduct``ItemPriceLevel`" ISLIST="YES" TYPE="String" INDEX="1">
         <UDF:SHIPPEDBY DESC="`Shipped By``SpeedProduct``ItemPriceLevel`">RETAIL</UDF:SHIPPEDBY>
        </UDF:SHIPPEDBY.LIST>
       </BATCHALLOCATIONS.LIST>

<ACCOUNTINGALLOCATIONS.LIST>
<LEDGERNAME>CAM SHAFTS SALES</LEDGERNAME>
<GSTCLASS/>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISPARTYLEDGER>No</ISPARTYLEDGER>
<ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>
<AMOUNT>2847.77</AMOUNT>
</ACCOUNTINGALLOCATIONS.LIST>

</ALLINVENTORYENTRIES.LIST>

<ALLINVENTORYENTRIES.LIST>
<STOCKITEMNAME>01-0\12170W</STOCKITEMNAME>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>
<ISAUTONEGATE>No</ISAUTONEGATE>
<ISCUSTOMSCLEARANCE>No</ISCUSTOMSCLEARANCE>
<ISTRACKCOMPONENT>No</ISTRACKCOMPONENT>
<ISTRACKPRODUCTION>No</ISTRACKPRODUCTION>
<ISPRIMARYITEM>No</ISPRIMARYITEM>
<ISSCRAP>No</ISSCRAP>
<RATE>646.67/Nos</RATE>
<AMOUNT>646.67</AMOUNT>
<ACTUALQTY>1 Nos</ACTUALQTY>
<BILLEDQTY>1 Nos</BILLEDQTY>

<BATCHALLOCATIONS.LIST>
<MFDON>#fromdate</MFDON>
<GODOWNNAME></GODOWNNAME>
<BATCHNAME></BATCHNAME>
<DESTINATIONGODOWNNAME></DESTINATIONGODOWNNAME>
<INDENTNO/>
<ORDERNO>4</ORDERNO>
<DYNAMICCSTISCLEARED>No</DYNAMICCSTISCLEARED>
<AMOUNT>646.67</AMOUNT>
<ACTUALQTY>1 Nos</ACTUALQTY>
<BILLEDQTY>1 Nos</BILLEDQTY>
<ORDERDUEDATE>2 Days</ORDERDUEDATE>
</BATCHALLOCATIONS.LIST>

</ALLINVENTORYENTRIES.LIST>

</VOUCHER>
</TALLYMESSAGE>
</REQUESTDATA>
</IMPORTDATA>
</BODY>
</ENVELOPE>

குழந்தைகளுக்கான தூயத்தமிழ் பெயர்கள்

How to export voucher from tally by using IDs - XML format

How to Get Tally Voucher Data by Voucher ID

<?xml version="1.0" encoding="UTF-8"?>
<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>EXPORT</TALLYREQUEST>
<TYPE>Object</TYPE>
<SUBTYPE>VOUCHER</SUBTYPE>
<ID TYPE="Name">ID:{{voucherId}}</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
<SVCURRENTCOMPANY>{{companyName}}</SVCURRENTCOMPANY>
</STATICVARIABLES>
<FETCHLIST>
    <FETCH>Date</FETCH>
    <FETCH>VoucherTypeName</FETCH>
    <FETCH>VoucherNumber</FETCH>
</FETCHLIST>
</DESC>
</BODY>
</ENVELOPE>

Use this XML tags for Tally Sales order,Sales Voucher,Receipt Voucher,Purchase,GRN,Stock Transfer and any other Tally voucher data access using XML format.