RTSlink DLL completes one year

First Anniversary of RTSlink DLL

It has been one year since RTSlink DLL was launched.

Many things have changed since then. In the initial days (when RTSlink DLL was launched), very few people were aware of "Tally Integration". In fact, the Tally Integration and Tally Customization activities were restricted to small community of Tally professionals.

RTSlink DLL was launched in January 2007. The next task at hand was to provide support to various Software professionals using different programming languages like Visual Basic; Visual Foxpro; C; C++; Visual C++; C#, Delphi, VB.NET, ASP.NET etc. After sometime, the need for TDL coding aroused. This was due to limitations in several Tally reports as data was to be retrieved programmatically. And this led to the birth of tdlplayground, wherein sample TDL programs were put-up for Tally lovers, free-of-cost. I remember asking some Tally professionals about adding one or two new fields in Tally. And the cost ranged from Rs 5000/- to Rs 7000/- for merely adding one or two fields. Subsequently, several TDL programs were put up at tdlplayground and some programs like TDL code for Recycle-bin became quite popular.

Our clients include from Individual programmers to Public Limited Companies. Here's are some of our clients (randomly selected from our software registration database).

Initially, some concerns were raised about the Product and the support services that we provide. It took lot's of efforts in convincing what RTSlink DLL is and how it works. Our target was to provide support services/solutions within 24 to 48 hrs. Though this may appear to be normal and nothing extra-ordinary, those who have provided support-services to Software professionals may be well-aware what it takes to write / code programs in such short timings. The average time has been less than 24 hrs.

And here we are. As of now, we have :-
a) Over 10,000 installations.
b) Over 100 articles about using RTSlink DLL for Tally Integration at our blog-site.
c) Sample Tally XML tags for most of the important Tally Reports.

Tally Integration made easy
Recently, we have launched udi-Magic [Professional] that allows users to retrieve data from almost any external database like MySQL, MS-Access, DBFs, SQL Server and others and send it directly to Tally Software. And all this happens by merely writing few SQL-SELECT statements and XML tags.

We thank all our Customers who have reposed faith in us.

ANNIVERSARY OFFER

Shweta Computers is pleased to offer Additional Licenses for RTSlink DLL on this occasion to all those who purchase RTSlink DLL from 14-1-2008 to 21-1-2008. Offer available to New and Old Customers. Contact Shweta Computers now.

Best wishes to all for 2008. Best wishes for Makar Sankranti.

SQL Server to Tally Software

Tally Integration made Easy

New Release 1.3
udi-Magic v3.0 Release 1.3 [Professional] allows you to transfer data directly from MS SQL Server to Tally Accounting Software using few SQL-SELECT statements and XML tags.

Supports all versions of Microsoft SQL Server.

Click here for more details on MS SQL Server to Tally

---

XBase (DBF) to Tally Software

Tally Integration made Easy

New Release 1.2
udi-Magic v3.0 Release 1.2 [Professional] allows you to transfer data directly from XBase (DBF) files to Tally Accounting Software using few SQL-SELECT statements and XML tags.

Supports
a) DBase
b) Fox 2.x
c) Visual Foxpro DBFs and DBC files
d) Other XBase file formats.

Click here for more details on XBase (DBF) to Tally

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>

---

Access Tally Data on a Remote Computer using RTSlink DLL

FAQs: Tally Integration using RTSlink DLL

Can I use RTSlink DLL to access Tally data from a Computer which is located in a different city or country ?

Yes. You can use RTSlink DLL to access (push or pull) Tally data from a Remote Computer which is located in a different city or country.

LIVE DEMO

Live demonstration to access (pull and push) Tally data along with support and guidance is provided to registered users of RTSlink DLL v1.9.

DEMO Situation 1
We shall provide support / guidance and demonstrate how you can access Tally data from our Computer which is located at Gandhidham, Gujarat, India.

DEMO Situation 2
We shall demonstrate and access Tally data from your Computer where-ever you are located.

Please see:-
- This is available to registered users of RTSlink DLL v1.9 only. (i.e. those who have purchased and registered RTSlink DLL v1.9)
- Registered users who are interested in Demo are requested to write to support@rtslink.com with their RTSlink DLL serial number and fix timings for Demonstration.
- Demo shall be provide once only.
- Users must have Internet connection, preferably broad-band.
- Transfer of data over Internet may be slow/time consuming.

Corrections in ldaily.txt and ldaily.xml

Minor corrections have been done in the XML and TDL file to fetch "Ledger Daily balances" using RTSlink DLL.

FILE: ldaily.txt

Old Code
Set : LedgerName: "Cash"

New Code
Set : LedgerName: If $$IsEmpty:##LedgerName then "Cash" else ##LedgerName

Please see:
A syntax error in lDaily.xml has also been rectified.

Bug in $$ItemSerial TDL function

Tally Integration using RTSlink DLL

$$ItemSerial [TDL function]

"The function $ItemSerial generates Line numbers beginning from 0. It does not accept any parameter and returns Numerical value. "

Using $ItemSerial function with Masters

SELECT $$ItemSerial,$Name FROM Ledger

Remarks:-
The $$ItemSerial works fine when used with any MASTER's Collection like LEDGER, GROUP,STOCKITEM etc. However, it returns random (incorrect) values when used with VOUCHER object as shown below.

Using $$ItemSerial function with Vouchers

SELECT $$ItemSerial, $Date, $VoucherTypeName, FROM RTSAllVouchers

Remarks:-
1) When you use the above SELECT statement, the $$ItemSerial function returns random values and not the line serial number starting from 0 as in case of MASTERs.

2) RTSAllVouchers is a user-defined collection and its TDL code has been provided in my earlier post.

BUG:
It has been confirmed by Tally Solutions, Bangalore that the $$ItemSerial function generates (incorrect) random values when used with the VOUCHER object.

Please note that both Tally 7.2 and Tally 9 have the $$ItemSerial bug.

CompanyVouchers collection

FAQs : Tally Integration using RTSlink DLL

When I use the CompanyVouchers collection, Tally Server returns vouchers for the current-date only.

CompanyVouchers is a pre-defined collection. The Collection definition is given herewith for your reference:-

[Collection: Company Vouchers]
    Type        : Voucher
    Child of    : ##SVCurrentDate
    Report      : Voucher
    IsODBCTable : Yes

As you can see, this collection is filtered for the Current-date using the ChildOf attribute. Hence, it returns Vouchers for the current-date only.

To retrieve all Vouchers, you can use the RTSAllVouchers Collection.

XML tags to create Sales Voucher in Tally Software

Corrections
Minor changes have been done in the CreSale.xml file. It now includes XML tags for creating Unit master also.

Download the cresale.zip file

For other downloads, visit www.rtslink.com/downloads.html

Remarks:-
CreSale file contains XML tags to create a Sales Voucher programmatically using RTSlink DLL. Tested with Tally 7.2 an Tally 9