Integration Capabilities

Tally Integration Capabilities

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.

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 Enable TCS Calculation on Sale of Goods in Tally ERP 9

Tally Erp9 - HOW TO ENABLE TCS CALCULATION ON SALE OF GOODS

1. Open Tally and Login as Admin

2. Press F11 Select Yes in Tax Collected at sources under statutory & taxation.

3. Now under second option set/alter TCS details, press yes please enter your TAN Number, collector type, collector branch . and enter all other required details and press enter

4. Go to Accounts info then statutory info now you will find NEW OPTION named TCS NATURE OF GOODS please press enter now you will find create option, now enter name TCS ON SALE OF ANY GOODS, section 260C, rate are same for all type of payee, with PAN 0.075% & without PAN 1%(Normal TCS rate is 0.1% but reduced rate will be apply from 01st October 2020 to 31st march 2021 as concessional relief by Govt. to reduce all tax rate @25%. From 1st April, 2021 Rate of 0.1% will be applicable)

5. Modify some of your ledgers of tally. Now you have to decide that to which customer TCS is applicable based on limits now alter that customer ledger( you have to individually alter all those sales party ledger to to whom TCS is applicable)

6. Statutory information you will find ""TCS is applicable"" please select yes, select buyers type, don’t forget to enter PAN No. now please accept.

7. Alter your sales ledger, Select "Yes" under is "TCS is applicable" now under nature of goods option select TCS on sale of any goods( which we created earlier), now please accept.

8. Also alter your CGST, SGST ledgers. If you maintain CGST ledger rate wise than you have to alter all those ledger. ( as you know TCS is also applicable on GST Amount that’s why you have to alter your all CGST, SGST, & IGST Ledge).’

9. Now alter respective GST ledger please select yes under IS TCS is applicable & Select nature of goods , TCS on sale of any goods( category which you have created earlier)

10. Go to gateway of tally then stock item than alter, select one of stick item, now you will find option IS TCS is applicable please select yes and under Nature of goods select TCS on sale of any goods now please accept.

11. Now all done. Please enter one of sales invoice. Now select customer ledger under Which you have enable TCS, select stock item under which you have unable TCS, Enter Respective Qty, Rate, select sales ledger which you have enable for TCS, now you will find one box, TCS nature of goods select ledger, TCS on sale of any goods every time you have to select this category like after you have selected stock item & after you have selected respective GST ledger.

12. Now at the end means after you have selected respective GST ledger press alter C(ledger create), create one ledger name TCS on sale of goods under Duties & tax, type of ledger TC & Select category which you have created earlier(TCS ON SALE OF ANY GOODS).

13. If TCS is not applicable in any party then a under ledger select NO Against Is TCS IS APPLICABLE. OR You can also do one thing while entering sales invoice, you will be asked TCS nature of goods then select Not applicable

14. Go to Display, statutory report then form 27 EQ Now you will find all your TCS transaction, assessable value and TCS collectable and TCS collected and balance collectable monthly as well as yearly

15. Now after the end of your month means when you you have to paid TCS, go to accounting voucher then payment voucher, enter dated for example 1st Nov, 2020 now you will find start payment option in right hand side of your payment voucher please select start payment, now select tax type as TCS and enter all details which are asked like Period, collected till date, section(206C), Nature of goods, collectee status, residential status, cash/bank, Now all those bill on which TCS is applicable are display on your screen and you will find total amount of TCS need to be deposited by you. And if you want to print TCS challan for your reference press Alt P, and select yes in print as TCS challan

16. Now under FORM 27EQ you will find TCS amount which you have entered in you payment voucher if not available than see the not included in TCS and entered respective details.

Tally XML stock summary request - Item Wise Stock Summary

Tally Interfaces – For Integration XML Sample Code

How to Export Item wise Stock Summary from tally using XML TAGS via http

<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>

<BODY>
<EXPORTDATA>
<REQUESTDESC>
<REPORTNAME>Stock Summary</REPORTNAME>

  <STATICVARIABLES>

   <SVCURRENTCOMPANY>company</SVCURRENTCOMPANY>
   <SVEXPORTFORMAT>$$SysName:HTML</SVEXPORTFORMAT>
   <SVFROMDate>fromdate</SVFROMDate>
   <SVTODATE>todate</SVTODATE>
               <EXPLODEFLAG>Yes</EXPLODEFLAG>
                                     </STATICVARIABLES>
</REQUESTDESC>

</EXPORTDATA>
</BODY>
</ENVELOPE>

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