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

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