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

Tuesday, February 22, 2011

Tally ERP 9 Release 3 - IGNORED response tag

The latest release - Tally ERP 9 Release 3.0 correctly displays the value for the IGNORED tag in the response tags. Earlier, the IGNORED tag used to incorrectly show 0 even if the record pushed into Tally was ignored by Tally.

Friday, February 11, 2011

Stock Value appears incorrectly

Scenario

In a Tally Company with Multiple Locations/Godowns set to Yes, the Stock Value appears incorrectly in StockSummary report in the following situation where :-

Opening Stock of Item A
Godown A - 5 Nos @ Rs 3 = Rs 15
Godown B - 5 Nos @ Rs 3 = Rs 15

Sale from Godown B - Qty 7 pcs.

PS:
As the Stock in Godown B is 5 Nos, and the Sale entry is of Qty 7 Nos, there is negative balance in Godown B and the stock-value (of both Godown A and Godown B - i e. total stock) is shown incorrectly in Stock Summary statement. This happens only when there is negative Stock and Multiple locations feature is enabled.

Tested with Tally ERP 9 Release 2.1

Tuesday, February 1, 2011

Ledger Monthly Summary

To retrieve Ledger Monthly Summary, the following XML tags are to be used :-

<DSPSHOWMONTHLY>Yes</DSPSHOWMONTHLY>
<DSPSHOWALLACCOUNTS>Yes</DSPSHOWALLACCOUNTS>

Works with :-

Tally ERP 9 Release 2.1

Thursday, December 16, 2010

An Attempt was made to load a program with an incorrect format

The aforesaid error generally appears when you try to use a 32 bit program in 64 bit OS.

To resolve the error (while using RTSlink DLL), you must change/ set the "Compiler - CPU Type" as X86 instead of "Any".

Tuesday, September 21, 2010

Tally ERP 9 Release 2.0 - Stock Journal XML tags bug

Tally ERP 9 Release 2.0 - Bug Internal ID 7783

Description:-
Stock Journal vouchers when exported manually (or retrieved programmatically) contain some extra xml-tags.

Steps to re-produce the bug
1) Create a new Company in Tally ERP 9 Release 1.82 and entered a "Stock Journal" voucher. Next, export the same using option "Display >> Daybook >> Alt+E" .

2) Create a new Company in Tally ERP 9 Release 2.0 and entered a "Stock Journal" voucher. Next, export the same using option "Display >> Daybook >> Alt+E" .

The XML-output of both the versions is different. If you see the XML output for Tally ERP 9 Release 2.0, then there are some additional tags (see ALLINVENTORYENTRIES.LIST) which are not there in Tally ERP 9 Release 1.82 version.

It has been confirmed by Tally Solutions Pvt Ltdm Bangalore that the aforesaid issue is an bug (Internal Id 47783) as on 21/09/2010.


UPDATE
The aforesaid error has been rectified in Tally ERP 9 Release 3.0 as intimated to us by Tally Solutions, Bangalore on 22/02/2011

Thursday, September 9, 2010

$$ToValue TDL function

The TDL function $$ToValue allows you to retrieve total-value of a specific method upto a specific date.

Function : $$ToValue
Syntax    : $$ToValue : Date  : FieldName

Example1 : $$ToValue:#MyDate:#MyField
Example2 : $$ToValue:($$Date:"02/05/2010"):($ClosingBalance:Ledger:"Cash")

Wednesday, August 11, 2010

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

Monday, July 26, 2010

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.

Friday, July 23, 2010

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.

Saturday, May 1, 2010

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.