Tally ERP 9 - Creating a company programmatically

Tally ERP 9 supports "Creation of a Company" programmatically.

Using RTS-XQuery DLL in VB6

Here's a sample program which illustrates how to use RTS-XQuery DLL in Visual Basic 6.

For more information on RTS-XQuery DLL, visit http://www.rtslink.com/rts-xquery-library/

Introducing RTS-XQuery ActiveX Library

We are pleased to launch RTS-XQuery Library, an ActiveX DLL for Tally Integration with support for XQuery and XQuery Update facility.

RTS-XQuery DLL is a superset of RTSlink DLL and includes all the features of RTSlink DLL. It is particulary useful for transferring data from Tally Software to external databases like SQL-Server, MySQL, Access, DBFs etc.

RTS-XQuery works with Tally 6.3 and higher versions including the latest release of Tally ERP 9.

For more information, refer RTS-XQuery DLL - for Tally Integration

---

Export Tally data to Relational database

Here's a Free add-on utility for Tally Software that facilitates export of Tally data into Relational database.

For more information on RTS-XQuery Freemium , refer http://www.rtslink.com/rts-xquery-freemium/

Click here to view the step-by-step instructions for exporting Tally data to Relational database

Alternatively, you can download the instructions (PDF-file) for exporting Tally data into Relational database.

Tally ERP 9 Release 1.52

Few weeks back, I had written about a problem in Tally ERP 9 Release 1.51 relating to pushing and pulling data programmatically.

This was later on confirmed to be a BUG in Tally ERP 9 Release 1.51 by Tally Solutions, Bangalore. The same has now been rectified in Tally ERP 9 Release 1.52

$$FullList function

$$FullList Function

The $$FullList function returns incorrect results in Tally 7.2 in certain cases, but works fine with Tally ERP 9 Release 1.5.

Scenario

Step 1)
Enter a Sales voucher with following items :-

Name    Qty     Rate   Amt
Item A    5      100   500
Item B    5
Item C    5      150   750

Step 2)
Use the following SELECT-SQL to retrieve data from Tally :-

Select $$FullList:InventoryEntries:$BilledQty,$$FullList:InventoryEntries:$Rate From CompanyVouchers

Result:-

Case a) Tally 7.2

Qty           Rate
5 ,5, 5       100

Case b) Tally ERP 9 Release 1.5

Qty           Rate
5 ,5, 5       100, , 150

Tally ERP 9 Release 1.51 issues

This is further to my post on Tally ERP 9 Release 1.51 wherein we had posted an problem that many of us faced recently.

It is now confirmed by Tally Solutions, Bangalore that this issue is an BUG and shall be rectified in the coming Release of Tally ERP 9. However, the date for the next Release could not be confirmed.

Tally ERP 9 Release 1.51

We have recently noticed some issues in Tally ERP 9 Release 1.51 which probably seems to be a BUG in this Release (i.e. Release 1.51)

BUG:
When a request is sent to push/pull data, the Tally Software terminates with the following message :-

Internal Error: Contact Tally Solutions

Software Exception c000005
(Memory Access Voilation)

PS:
Though it prima-facie appears to be BUG (according to us), it has NOT yet been confirmed by Tally Solutions, Bangalore.

Tally ERP 9 Release 1.3

Tally ERP 9 Release 1.3 issues

The SVCURRENTCOMAPNY tag does not work with Tally ERP 9 Release 1.3. Even though the destination company is specified using the SVCURRENTCOMPANY tag, still the data is imported into the currently selected Company in Tally

This problem has been solved in Tally ERP 9 Release 1.5.

Tally ERP 9 speed Issues

The SELECT SQL slow speed issue with Tally ERP 9 Release 1 has been resolved in the Tally ERP 9 Release 5 (September 2009). For more information on this issue, please refer Tally ERP 9 Speed problem