Pages

Friday, August 19, 2016

Tally ERP 9 - Speed Issues

We recently uploaded bulk records from Excel into different versions of Tally ERP 9.

For your reference, here are the results of uploading a sample Excel  Sheet with 5200 Voucher records using udi-Magic v7.0:

Tally Version
Tally Release 
Time to upload (5200 Voucher records)
Tally ERP 9 
Release 5.1
2 min 52 secs
Tally ERP 9 
Release 5.2
2 min 46 secs
Tally ERP 9 
Release 5.3
2 min 48 secs
Tally ERP 9 
Release 5.3.1
2 min 49 secs
Tally ERP 9 
Release 5.3.2
2 min 26 secs
Tally ERP 9 
Release 5.3.3
11 min 08 secs
Tally ERP 9 
Release 5.4
11 min 28 secs

Remarks:
a) We uploaded the same Excel file (5200 vouchers) into different releases of Tally ERP 9
b) It was seen that from Tally ERP 9 Release 5.3.3 onwards, the performance degraded considerably.

Monday, August 15, 2016

udi-Magic v5.0 support to be discontinued from 1st January 2017

udi-Magic v5.0 (or lower versions) customers / users are requested to note that the support for udi-Magic v5.0 shall be discontinued from 1st January 2017 and there shall be no product enhancements in udi-Magic v5.0 thereafter.

Also, to avail technical support and product enhancements, users will have to upgrade to the latest version.

If XML tags are required for any new formats, then XML tags compatible with the latest version shall only be provided.

Saturday, August 13, 2016

udiMagic v7.0 Release 2.1

Release 2.1 now supports a new Settings Option :

Use title-case for Masters
When ticked / enabled, the Master NAMEs will be converted to title/proper case and then imported into Tally.

Steps:
1) Start udiMagic Software
2) Click the Settings button (in the 2nd screen)
3) Tick / enable the option "Use title-case for Master"

The above option is enabled by default. There is no need to change this setting, and has been kept for backward compatibility purpose only.

Friday, August 12, 2016

Amount changes on Voucher modification

Recently, we found a weird thing in Tally ERP 9. After importing data from Excel into Tally using udi-Magic, when we modified the Voucher, the Item-Amount changed. On scrutiny we found something that surprised us. Here's are the steps to reproduce the same.

Scenario 1 (Amount changes when Voucher is modified)
We uploaded a Sales Voucher from Excel into Tally using udi-Magic. You can use any Sales template provided with udi-Magic Software having the following values :

Item-Name : Bush free
Qty : 200
Amount : 34367.29

PS:
1) Do not enter the Item-Rate in XLS. Let Tally compute it automatically.
2) You can enter Party-Name and other details in XLS as required.
3) Import the XLS Sales data using udi-Magic and then try modifying it manually in Tally. The Item-amount changes to 34368.

Scenario 2 (Amount does NOT change when Voucher is modified - Correct scenario)
Next, we created another Company in Tally and  uploaded one Sales Voucher from Excel into Tally using udi-Magic. You can use the same XLS template having the following values :

Item-Name : Bush Free
Qty : 200
Amount : 34367.29
PS:
1) Do not enter the Item-Rate in XLS. Let Tally compute it automatically.
2) You can enter Party-Name and other details in XLS as required.
3) Import the XLS Sales data using udi-Magic and then try modifying it manually in Tally. The Item-amount does NOT change now.

Observation
In the Voucher modification mode, Tally re-calculates the Item-Amount if :
1) Item-Name is changed; or
2) Item-Qty is changed; or
3) Item-Rate is changed.

In Scenario 1 / Company 1, the Item-Name gets changed from "Bush free" to "Bush Free" automatically when we modify the Voucher. The forces re-calculation of Item-Amount.

The above does NOT happen in Scenario 2 (Company 2) as the Item-Name is already in Proper-case. i.e. Bush Free.

Proper-case / Title Case
If you are still not clear, then read on.

Create a new Company in Tally. Next, create (manually) a new Stock Item in Tally with name as "piston free". Notice that Tally changes it to proper-case/title-case as  "Piston Free". Though this conversion happens when we type the Item-Name manually in Tally, it does not happen when the data is imported using an external program. This creates problem and changes the Item-amount when we modify the Voucher.

To handle this situation, we will be coming out with a new release of udi-Magic and the details shall be put on this site shortly.

Friday, August 5, 2016

Template modification

Vouchers-V6-Financial-Transactions-with-multiple-references-and-cost-centres.xls

The aforesaid template now includes "Bank details" viz Instrument Number, Instrument Date etc.

Download link (all templates) :
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip

You can now view what changes have been done, when these changes were done by visiting
https://github.com/ShwetaSoftwares/standard-templates/commits/

udiMagic v7.0 Release 2.0

Release 2.0 now supports a new Settings Option :

Disable TaxClassifications
When ticked / enabled, the TaxClassifications (given in CSV file for Sales/Purchase templates) are ignored and are not imported into Tally.

Steps:
1) Start udiMagic Software
2) Click the Settings button (in the 2nd screen)
3) Tick / enable the option "Disable TaxClassifications"

The above option is useful when you are using an older version of Tally and can't import Sales/Purchase data as you get error "Tax Classification not found".


Monday, August 1, 2016

udiMagic v7.0 Release 1.9

Release 1.9 supports the following new features :

Error description
You can now get more information about the errors by double-clicking the "error message" from within the udiMagic Software.

PS:
Alternatively, you can visit http://www.rtslink.com/products/udimagic/errors/  for list of commonly occurring errors and their descriptions.

Templates removed

Recently, we have removed few templates to reduce redundancy and for the ease of use. The details are as follows :

TEMPLATEs removed
Vouchers-V5-Cash-n-Bank-Payment-transactions.xls
Vouchers-V6-Financial-Transactions-with-multiple-references.xls
Vouchers-V6-Financial-Transactions-with-Ref-Cost-centre.xls

PS:
You can use the templates given underneath which provide the same features :
Vouchers-V6-Receipts-and-Payments-with-multiple-references.xls
Vouchers-V6-Financial-Transactions-with-multiple-references-and-cost-centres.xls