A blog on Tally Integration, to import and export data from Tally.ERP programmatically using VB6, VB.NET,C#,ASP.NET etc

Sunday, November 29, 2009

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/

Tuesday, November 24, 2009

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



Saturday, November 7, 2009

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.

Thursday, October 29, 2009

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

Wednesday, October 21, 2009

$$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

Friday, October 16, 2009

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.

Wednesday, September 30, 2009

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.

Thursday, September 24, 2009

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.

Sunday, September 6, 2009

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

Monday, May 25, 2009

Tally ERP 9 Speed Issues

This is with regards to my earlier post on this issue. i.e Tally ERP 9 Speed problem

It has been confirmed by Tally Solutions, Bangalore that there are Speed problems/ issues while using SELECT statement to fetch Tally data from Tally ERP 9. Tally Solutions, Bangalore has also assured that this issue will be resolved in the forthcoming release of Tally ERP 9.

Friday, May 8, 2009

Tally ERP 9 SPEED Issues

Recently while working on Tally ERP 9 we faced some problems. Tally ERP 9 was very slow in processing SQL-SELECT statements.

Click here for more details on the Tally ERP 9 SPEED Tests that we performed.

Friday, March 6, 2009

Attempting managed execution inside OS Loader lock

I am trying to link my VB.NET / C# application with Tally using RTSlink DLL. But I get this error while calling Open() function :-

"Attempting managed execution inside OS Loader lock. Do not attempt to run managed code inside a DllMain or image initialization function since doing so can cause the application to hang. "

Solution 1
1. Go to Debug/Exceptions
2. Open up the Managed Debugging Assistants node on the tree and scroll down till you find LoaderLock and uncheck it.

After this recompile the project.

Solution 2
1) If you cannot find that the "Exceptions" option under "Debug" menu-option in Visual Studio, then refer this link to get it back.
2) Next, follow the steps given in Solution 1.


Saturday, January 10, 2009

Tally 9 - Support for UNICODE characters

Support for UNICODE characters is available in Tally 9. This post deals with some issues relating to UNICODE.

1) When we programmatically import / export data from Tally 9, the default character-set used by Tally Software is ASCII.

2) However, in case if NO Company is opened in Tally 9 and we programmatically send a SQL-Request to Tally (like to check if any company is open or not), the RESPONSE received from Tally is always in UNICODE. This may cause error as generally the Tally Integration programs written now-a-days do not provide support for handling UNICODE characters. This prima-facia appears to be a BUG in Tally 9, but has not been confirmed by Tally Solutions, Bangalore as of now.

BUG
Tally 9 returns data in UNICODE even though the character-set is set as ASCII (i.e. UNICODE="No"). This occurs when we send a SQL-Request to Tally when NO company is open in Tally 9. It does not occur in any other situations tested by us till now.