Tally Request XML formats, Tally Integration with any platform

Tally Request XMLs

Tally data to Power BI

TallyPrime Integration with 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

Party wise Sales in xml format

How to export All Party wise Sales data from tally using XML request

Request for XML Format Party Sales for Integration from Tally.

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

<BODY>
<EXPORTDATA>
<REQUESTDESC>
         <REPORTNAME>Group Summary</REPORTNAME>
  <STATICVARIABLES>

   <SVCURRENTCOMPANY>company</SVCURRENTCOMPANY>
   <SVEXPORTFORMAT>$$SysName:html</SVEXPORTFORMAT>
   <SVFROMDATE TYPE="Date">#fromdate</SVFROMDATE>
                        <SVTODATE TYPE="Date">#todate</SVTODATE>
                        <DSPShowNett>No</DSPShowNett>


                           <GroupName>22003 SUNDRY DEBTORS</GroupName>
                          <DSPShowTrans>Yes</DSPShowTrans>
                          <IFLTPrompt>Voucher</IFLTPrompt>
                          <IFLTMethod>Invoice</IFLTMethod>
                          <IFLTAttr>Yes</IFLTAttr>

                </STATICVARIABLES>

</REQUESTDESC>

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

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>

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

How to Get Trial Balance in xml/html format

How to export trial balance from tally using XML request

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>
<SVCURRENTCOMPANY>#company</SVCURRENTCOMPANY>
<EXPLODEFLAG>Yes</EXPLODEFLAG>
<SVEXPORTFORMAT>$$SysName:HTML</SVEXPORTFORMAT>
</STATICVARIABLES>
</DESC>
</BODY>
</ENVELOPE>