Add this line under the UDIMAGIC headingģ) Save the UDIMAGIC.INI file and retry importing data into Tally ERP 9 using UDIMagic.
If you are using Tally ERP 9 and experiencing slow speeds, please follow these steps :-ġ) Upgrade to UDIMagic v3.0 Release 1.97 (or higher)Ģ) Make the following changes in the UDIMAGIC.INI (configuration file) This eliminates the use of SELECT SQL and results in improved performance. UDIMagic v3.0 Release 1.97 uses a different technique to process the Masters records. You can get more information about this issue (Tally ERP 9 speed issues with SELECT SQL) at We have already written to Tally Solutions, Bangalore sometime back about this and it has been confirmed to be an issue / problem with Tally ERP 9. In case, if you are using Tally ERP 9 and are importing data into your existing Tally Company which contains hundreds or thousands of Masters (Ledger Masters or StockItem Masters), you may experience very slow speed while processing of Masters. The option IgnoreDuplicateMasters=Yes must be added directly under the Heading To solve the issue with Tally ERP 9, you must add the following option in the UDIMAGIC.INI file. There is an ERROR message which says that these records are already there. As these records already exist in Tally, they are modified /overwritten.Ģ) Once again import the same data into Tally. This will import 2 stock-items into Tally.Ģ) Once again import the same data into Tally. The tests that we performed on different versions of Tally are given underneath :-ġ) Start UDIMagic and import the "Master - StockItem Master Excel sheet" data into Tally. While importing Masters into Tally ERP 9, we have noticed some issues. To view/download all sample Excel sheet formats, please visit
The templates shown below are now discontinued.Ģ) StockItem Master (only Purchase Price)ģ) StockItem Master (only Sale & Purchase Price)Ĥ) Ledger Master (Party Masters with different parent Groups)ĥ) Ledger Master (Party Masters with contact details)ġ) Sales Vouchers with StockItems (including VAT Additional VAT CST Excise etc)Ģ) Sales Vouchers without StockItems (including VAT Additional VAT CST Excise etc)ģ) Sales Vouchers with StockItems (including Service Tax Order Number)Ĥ) Purchase Vouchers (including VAT Additional VAT)ĥ) Financial Vouchers in Single-line format (Payment Receipt Contra Journal)Ħ) Stock Journal vouchers (Manufacturing Jounal)ħ) Cash and Bank Vouchers( Receipt Payment Contra) The following sample Excel sheets formats are now available for UDIMagic users :. This way all data from your original Company is transferred into the NEW Company having necessary DECIMAL places in the UOM (as changed in Step 2). Specify the MASTER.XML with full-path and select option "Ignore duplicates"ġ0) Use option "Import of Data > Vouchers".
This will export the Vouchers data into "DAYBOOK.XML" fileĨ) Open the NEW Company that you created in Step 1ĩ) Use option "Import of Data > Masters". This will export the Masters data into "MASTER.XML" fileĦ) Next, export all Vouchers (Option : Gateway of Tally > Display > Daybook > Alt+E". Next select the option "All Masters" and "XML" format. Set the Decimal places as required.Ĥ) Open your original Company which contains data.ĥ) Next, export all Masters (Option : Gateway of Tally > Display > List of Accounts > Alt+E". Follow the underneath steps to change the DECIMAL places if the field has been disabled :-Ģ) Next, create the UOM (Unit of Measurement) for which you need to change the DECIMAL Places. In case, if you ever tried to change the number of DECIMAL places in the UNIT MASTER, (wherein voucher data exists for the same) you may have noticed that the DECIMAL places field appears disabled.