Tally ERP 9 Release 1.8 - Memory Access Voilation

We have recently noticed that Tally ERP 9 Release 1.8 raises "Memory access voilation" error and terminates when a UNIT Master record is programmatically pushed. The aforesaid error occurs only in cases wherein the UNIT Master record exists in Tally.

PS:
The aforesaid problem does NOT occur in Tally ERP 9 Release 1.82 and Tally ERP 9 Release 1.61

LASTMID

The <RESPONSE> tag received from Tally Software contains a tag named LASTMID. This tag <LASTMID> is as of now (i.e. upto Tally ERP 9 Release 1.82) not assigned any value - which is confirmed by Tally Solutions, Bangalore.

Call to DLLRegisterServer failed with Code 0x80004005

OS : Windows 7, Vista

To resolve the aforesaid error, follow these steps :-

1. Click on Start button.
2. Type cmd into the Start Search textbox. Do NOT press enter.
3. Press Ctrl+Shift+Enter key.
Ctrl-Shift-Enter is the general keyboard shortcut that triggers elevation to “Run as Administrator”.
4. Press Alt+C or press Continue to confirm the UAC elevation warning prompt.

After the run the REGSVR32 to register the DLL.

Issues in Tally 7.2. while retrieving the PriceLevel

We tested using the following SELECT-SQL with different versions of Tally

Select $$FullList:FullPriceList:$Date,$$FullList:FullPriceList:$PriceLevel from StockItem where $Name='101220'

Tally 7.2 Release 3.12
The SELECT-query returned the DATE but NOT the PriceLevel.

Tally ERP 9 Release 1.61
The SELECT-query returned the both the DATE and the PriceLevel.

Remarks:-
It appears that this is an issue with Tally 7.2 Release 3.12.

---

Ledger Opening Balance

You can retrieve the Ledger Opening Balances from Tally using the underneath SQL-SELECT statement :-

Select $Name,$OpeningBalance From Ledger

The above SELECT-SQL returns correct balances if you are working in the 1st year. However, in the 2nd year or later (i.e. if the Current Period beginning is different from the Books beginning date) the above SELECT-SQL returns the OpeningBalance as on the Current period Beginning date which is incorrect. To understand this let's take an example :-

1) Create a New Company in Tally with Books Beginning date as 01-04-2005 (i.e. 1st April, 2005)

2) Next, create a Ledger named "My Bank A/c" under group "Bank Accounts" with Opening Balance of Rs 5000

3) Next, enter a Payment Voucher on 2nd May 2005 as follows :-

Dr: Office Expenses Rs 100
Cr: My Bank A.c Rs 100

4) Next, use the SELECT-SQL mentioned above. It returns the correct opening balance for "My Bank A/c" which is Rs 5000/-

5) Next, change the period using Alt+F2 key and set it as 01-04-2006 to 31-03-2007

6) Now, again use the same SELECT-SQL given above. In this case, it returns the Opening Balance for "My Bank A/c" as Rs 4900/- instead of Rs 5000/-

Remarks:-
a) In simple words, the $OpeningBalance returns the Ledger-Opening-balance as on the current-period-beginning-date (i.e as on 01-04-2006 in this example)
b) You must use TDL, to get the Ledger Openingbalance as on the Books-beginning date (i.e. 01-04-2005 in this example) irrespective of what the current period is set in Tally.

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