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

Wednesday, September 28, 2011

Ledger Outstandings - Bill-wise format - Part 2

This is further to my earlier post relating to exporting Ledger Outstanding - Bill-wise report.

Even though we export (Alt+E) the data in detailed format, the xml output (LedBills.xml) does not contain the details of the Bill Vouchers part i.e.Voucher type, Voucher number etc.

Here's the TDL code to get the correct xml output for Ledger Outstandings in Bill-wise format. i.e. LedVch Outstandings with details of the Bill Vouchers part also
[#Line: BILL Detail]
    XMLTAG : BILLDETAILS
    Delete  : Explode : BILL Vouchers
    Add  : Explode : BILL Vouchers : ($$KeyExplode OR ##ExplodeFlag)

Monday, September 26, 2011

Ledger Outstandings - Bill-wise format

On exporting the Tally reporting "Ledger Outstandings" in Bill-wise format, the xml output does not contain any tag to identify each bill-record.

Here's the TDL code to get the correct xml output for Ledger Outstandings in Bill-wise format. i.e. LedVch Outstandings

[#Line: BILL Detail]
    XMLTAG : BILLDETAILS

Thursday, August 25, 2011

Bad Variables - Tally error

The error "Bad Variables" appears in Tally Software if one or more variables specified in the STATICVARIABLES cannot be set / initialized.

Monday, June 13, 2011

Cost Centre allocation in Purchase through Invoice mode

Why can't the ‘Cost Centres’ containing ‘Purchase Entries in Invoice mode’ be allocated, when the Sales Entries in Invoice mode can ?

Here's the detailed explanation in PDF format provided by Tally Solutions, Bangalore.

Cost_Centre_allocation_in_Purchase_through_Invoice_mode.pdf

Tuesday, February 22, 2011

Tally ERP 9 Release 3 - Stock Journal

The bug/issue in Tally ERP 9 Release 2.0 relating to Stock Journal XML tags has been now rectified in this release.

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