Tally Integration | Import Export data from Tally ERP: December 2007

Ledger and StockItem Masters

How can I retrieve Ledger and StockItem Masters with their Closing balances ?

You can retrieve Ledger & StockItem masters with their Closing balances either using SQL-SELECT or XML Tags.

SQL-SELECT statement

Ledger-Master
SELECT $Name, $ClosingBalance FROM Ledger

StockItem Master
SELECT $Name, $ClosingBalance FROM StockItem

XML tags

Refer this link for more information XML tags to retrieve Tally Masters

Fetch Currency information from Tally Software

You can retrieve Currency details using SQL-SELECT or XML tags as given below:-

Using SQL-SELECT
SELECT $Name,$OriginalSymbol FROM currency

Using XML tags

<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>
<BODY>
<EXPORTDATA>
  <REQUESTDESC>
    <REPORTNAME>List of Accounts</REPORTNAME>
    <STATICVARIABLES>
       <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
       <ACCOUNTTYPE>Currencies</ACCOUNTTYPE>
    </STATICVARIABLES>
  </REQUESTDESC>
</EXPORTDATA>
</BODY>
</ENVELOPE>

Friday, December 21, 2007

Ledger and StockItem Masters

Fetch Currency information from Tally Software