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

Wednesday, March 7, 2012

Fetch the StockItem Rate and Qty without Unit Name

StockItem Rate and Quantity

By default, when we fetch StockItem Rate and Quantity, Tally returns the same with UNIT name appended at the end.

To get Item Rate without the unit name, use
$$Number:$Rate

To get the Item Quantity without the unit name, use
$$Number:$ActualQty

Saturday, February 25, 2012

Fetch data from Tally

Fetch Sales data from Tally

Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsSales:$VoucherTypeName

Fetch Payment data from Tally

Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsPayment:$VoucherTypeName

Fetch Receipt data from Tally

Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsReceipt:$VoucherTypeName

PS:
The above requires TDL code which is given underneath :-

[Collection: RTSAllVouchers]
  Type: Voucher
  IsODBCTable: Yes
  Fetch : *,AllLedgerEntries.*,LedgerEntries.*

Monday, February 13, 2012

DOT in Ledger Name

Case I - Works Fine
Ledger Name: Arihant Industries
SELECT Statement : Select $Name,$Parent From Ledger where $Name="Arihant Industries"

Case II - Does not Work
Ledger Name: Arihant Industries.
SELECT Statement : Select $Name,$Parent From Ledger where $Name="Arihant Industries."

Remarks:-
1) In Case II, the Ledger Name contains a dot (.) in the Ledger Name (viz Arihant Industries.). Using the SELECT SQL to search for the ledger name containing dot returns no result.
2) To resolve the issue, search for "Arihant Industries" (i.e. remove the dot from the Ledger Name)

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