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

Tally Integration, Tally ERP 9 Integration with Node.JS

Tally ERP Data Accessing via Node.js

Getting Tally ERP data using Server side javascript (node.js)

1. Create a NodeJS, express application
2. Install necessary plugins such as cors,xml,body-parser and request.

Server.js

var express = require('express');
var router = express.Router();
var bodyParser = require('body-parser');
var cors = require('cors');
var request = require('request');
require('body-parser-xml')(bodyParser);
var xml = require('xml');
var async = require('async');
/*Tally xml query*/
var xmlstring = '<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export DATA</TALLYREQUEST>
</HEADER>
<BODY>
<EXPORTDATA>
<REQUESTDESC>
<REPORTNAME>LIST of Companies</REPORTNAME>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
</STATICVARIABLES>
</REQUESTDESC>
</EXPORTDATA> </BODY>
</ENVELOPE>';
let app = express();
app.use(bodyParser.json());
/* use CORS to avoid net::ERR_CONNECTION_RESET */
app.use(cors);
app.post("/",(req,res) =>{ /*
Dynamic Tally xml Query parameter
const dbrequest = req.body.datarequest;
const params = req.body.params;
*/
var options = {
uri: 'http://localhost:9000',

method: 'POST',

headers: { 'Content-Type': 'text/xml;
charset:UTF-8',
'Content-Length': Buffer.byteLength(xmlstring)},
body: req.body.xmlstr
};
var result="";
async.parallel([
function(callback) {
/* tally data fetch from local tally server*/
var url = "http://localhost:9000";
request(options, function(err, response, body) {
// JSON body
if(err) { console.log(err);
callback(true);
return;
}

result = body;
callback(false, body);
});

}

],function(err, results) {
if(err) { console.log(err);
res.send(500,"Server Error");
return;
}
res.send("result--->"+result);
}
);
}

app.listen(4000,'localhost');

How to filter tally xml response based on voucher number?

Tally Request XML for Exporting Voucher filter by specific voucher number

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>#company</SVCURRENTCOMPANY>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
<SVFROMDATE TYPE="Date">#fromdate</SVFROMDATE>
<SVTODATE TYPE="Date">#todate</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,BASICBUYERADDRESS.LIST,DATE,
CLASSNAME,PARTYNAME,PERSISTEDVIEW,
BASICDUEDATEOFPYMT,LEDGERENTRIES.LIST</FETCH>

<FILTERS>TYPOFSALES</FILTERS>

</COLLECTION>

<SYSTEM TYPE="Formulae" NAME="TYPOFSALES">
$VOUCHERTYPENAME equal to "#TALLYVOUCHERTYPE" AND $VOUCHERNUMBER equal to "#TALLYVCHNO"
</SYSTEM>

</TDLMESSAGE>
</TDL>
</DESC>
</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