Tally Request XML formats, Tally Integration with any platform

Tally Request XMLs

XML - How to get voucher list of a specific voucher type in tally via

Tally Request XML for Exporting Sales Vouchers

Tally Integration with Third Party Application using PHP,ASP.NET, VB.Net,JSP

<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Collection</TYPE>
<ID>
List of All Sales Vouchers</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVCURRENTCOMPANY>#CompanyName</SVCURRENTCOMPANY>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
<SVFROMDATE TYPE="Date">fromdate</SVFROMDATE>
<SVTODATE TYPE="Date">todate 23:30:00</SVTODATE>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<COLLECTION NAME="List of All Sales Vouchers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TYPE>Voucher</TYPE>
<FETCH>ADDRESS.LIST,DATE,PARTYNAME,LEDGERENTRIES.LIST</FETCH>
<FILTERS>TYPOFSALES</FILTERS>
</COLLECTION>
<SYSTEM TYPE="Formulae" NAME="TYPOFSALES">
$VOUCHERTYPENAME contains "INVOICE" </SYSTEM>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>

$VOUCHERTYPENAME is the name of your Tally Sales Voucher Type

Tally data to Power BI

TallyPrime Integration with Power BI

Tally Reports available in Power BI

Tally ERP / Tally Prime we can integrate with Microsoft Power BI is posible with 100%, we can get Power 2 Reports using Tally BI + Microsoft Power BI

Is it possible to connect Tally and Microsoft Power BI?

Step 6 : Enter your any one of the web report URL in URL Parts (as per step 1)

Step 7 : Select HTTP Request Header Parameters as Content-Type and enter "Text/Json" as a data and click "OK" button

Step 8 : do Power BI Kitchen work for the result
Changing the data types, creating Measure using DAX, creating new columns in power bi etc.,

Step 9 : Create power BI dashboard as per your business needs

TallyPrime List of Companies XML Request

TallyPrime XML Request for List of Companies

<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Data</TYPE>
<ID>List of Companies</ID>
</HEADER>
<BODY>
<DESC>
<TDL>
<TDLMESSAGE>
<REPORT NAME="List of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<FORMS>List of Companies</FORMS>
</REPORT>
<FORM NAME="List of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TOPPARTS>List of Companies</TOPPARTS>
<XMLTAG>"List of Companies"</XMLTAG>
</FORM>
<PART NAME="List of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TOPLINES>List of Companies</TOPLINES>
<REPEAT>List of Companies : Collection of Companies</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<LINE NAME="List of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<LEFTFIELDS>Name</LEFTFIELDS>
</LINE>
<FIELD NAME="Name" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<SET>$Name</SET>
<XMLTAG>"NAME"</XMLTAG>
</FIELD>
<COLLECTION NAME="Collection of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TYPE>Company</TYPE>
<FETCH>NAME</FETCH>
</COLLECTION>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>

How to Get Outstanding data

How to export Outstanding balance from tally using XML request

Request for a OS details in XML Format from Tally.

<ENVELOPE>
<HEADER>
     <TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>
<BODY>
   <EXPORTDATA>
    <REQUESTDESC>
       <REPORTNAME>Bills Payable </REPORTNAME>
         <STATICVARIABLES>
         <SVCURRENTCOMPANY>#company</SVCURRENTCOMPANY>
         <SVEXPORTFORMAT>$$SysName:xml</SVEXPORTFORMAT>
         <SVFROMDATE>#fromdate</SVFROMDATE>
         <SVTODATE>#todate</SVTODATE>
     </STATICVARIABLES>
   </REQUESTDESC>
</EXPORTDATA>
</BODY>
</ENVELOPE>

Tally Alter Credit Limit and Credit Days using XML Request

Tally Request XML for Alter Party / Customer Credit Limit and Days

Tally Integration with Third Party Application using PHP,ASP.NET, VB.Net,JSP

<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">

<CREDITLIMIT>#CREDITLIMIT</CREDITLIMIT>
<BILLCREDITPERIOD>#CREDITDAYS</BILLCREDITPERIOD>
</LEDGER>

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

Tally XML Integrations