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