Here's a sample Excel sheet format for transferring Sales Orders from Excel into Tally.
PS:
The above sample uses "Macro-file". Please read the instructions given in the PDF file, before importing data into Tally.
For other Excel sheet formats, visit http://www.rtslink.com/download-excel-sheets.html
Wednesday, November 4, 2009
Thursday, October 29, 2009
Access Computer by Name
In the UDIMagic "Settings" screen, you can specify the Computer Name instead of the IP -Address. This is generally required when Tally is running on a different machine and the IP-Address is generated dynamically and changes each time you start the Computer.
Follow the underneath steps to specify the "ComputerName" instead of the "IP-Address" :-
1) Go to "Control Panel >> System"
2) Click on the tab "Computer-Name" and note down the "FullComputerName".
3) Next, start UDIMagic and in the "Settings" screen, specify the "ComputerName" instead of the IP-Address (the default ip-address is 127.0.0.1)
4) Next, click on the "Save".
5) Next, click on the "Test Connection" button to test-connect to Tally.
UDIMagic License Server
On the same lines, you can specify the ComputerName instead of the IP-Address for the UDIMagic License Server also.
Follow the underneath steps to specify the "ComputerName" instead of the "IP-Address" :-
1) Go to "Control Panel >> System"
2) Click on the tab "Computer-Name" and note down the "FullComputerName".
3) Next, start UDIMagic and in the "Settings" screen, specify the "ComputerName" instead of the IP-Address (the default ip-address is 127.0.0.1)
4) Next, click on the "Save".
5) Next, click on the "Test Connection" button to test-connect to Tally.
UDIMagic License Server
On the same lines, you can specify the ComputerName instead of the IP-Address for the UDIMagic License Server also.
Wednesday, October 28, 2009
Unable to change the number of DECIMAL Places in UNIT MASTER
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. Follow the underneath steps to change the DECIMAL places if the field has been disabled :-
1) Create a NEW Company in Tally
2) Next, create the UOM (Unit of Measurement) for which you need to change the DECIMAL Places. Set the Decimal places as required.
3) Close the NEW Company.
4) Open your original Company which contains data.
5) Next, export all Masters (Option : Gateway of Tally >> Display >> List of Accounts >> Alt+E". Next select the option "All Masters" and "XML" format. This will export the Masters data into "MASTER.XML" file
6) Next, export all Vouchers (Option : Gateway of Tally >> Display >> Daybook >> Alt+E". This will export the Vouchers data into "DAYBOOK.XML" file
7) Close the original Company
8) Open the NEW Company that you created in Step 1
9) Use option "Import of Data >> Masters". Specify the MASTER.XML with full-path and select option "Ignore duplicates"
10) Use option "Import of Data >> Vouchers". Specify the DAYBOOK.XML with full-path.
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).
1) Create a NEW Company in Tally
2) Next, create the UOM (Unit of Measurement) for which you need to change the DECIMAL Places. Set the Decimal places as required.
3) Close the NEW Company.
4) Open your original Company which contains data.
5) Next, export all Masters (Option : Gateway of Tally >> Display >> List of Accounts >> Alt+E". Next select the option "All Masters" and "XML" format. This will export the Masters data into "MASTER.XML" file
6) Next, export all Vouchers (Option : Gateway of Tally >> Display >> Daybook >> Alt+E". This will export the Vouchers data into "DAYBOOK.XML" file
7) Close the original Company
8) Open the NEW Company that you created in Step 1
9) Use option "Import of Data >> Masters". Specify the MASTER.XML with full-path and select option "Ignore duplicates"
10) Use option "Import of Data >> Vouchers". Specify the DAYBOOK.XML with full-path.
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).
Tuesday, October 6, 2009
Excel to Tally - Sample Excel Sheet formats
The following sample Excel sheets formats are now available for UDIMagic users :-
Import Masters from Excel into Tally
1) StockItem Master (only Sale Price)
2) StockItem Master (only Purchase Price)
3) StockItem Master (only Sale & Purchase Price)
4) Ledger Master (Party Masters with different parent Groups)
5) Ledger Master (Party Masters with contact details)
Import Vouchers from Excel into Tally
1) Sales Vouchers with StockItems (including VAT; Additional VAT; CST; Excise etc)
2) Sales Vouchers without StockItems (including VAT; Additional VAT; CST; Excise etc)
3) Sales Vouchers with StockItems (including Service Tax; Order Number)
4) Purchase Vouchers (including VAT; Additional VAT)
5) Financial Vouchers in Single-line format (Payment; Receipt; Contra; Journal)
6) Stock Journal vouchers (Manufacturing Jounal)
7) Cash and Bank Vouchers( Receipt; Payment; Contra)
To view/download all sample Excel sheet formats, please visit http://www.rtslink.com/download-excel-sheets.html
Import Masters from Excel into Tally
1) StockItem Master (only Sale Price)
2) StockItem Master (only Purchase Price)
3) StockItem Master (only Sale & Purchase Price)
4) Ledger Master (Party Masters with different parent Groups)
5) Ledger Master (Party Masters with contact details)
Import Vouchers from Excel into Tally
1) Sales Vouchers with StockItems (including VAT; Additional VAT; CST; Excise etc)
2) Sales Vouchers without StockItems (including VAT; Additional VAT; CST; Excise etc)
3) Sales Vouchers with StockItems (including Service Tax; Order Number)
4) Purchase Vouchers (including VAT; Additional VAT)
5) Financial Vouchers in Single-line format (Payment; Receipt; Contra; Journal)
6) Stock Journal vouchers (Manufacturing Jounal)
7) Cash and Bank Vouchers( Receipt; Payment; Contra)
To view/download all sample Excel sheet formats, please visit http://www.rtslink.com/download-excel-sheets.html
Wednesday, September 30, 2009
Tally ERP 9 Release 1.51
We have recently noticed some issues in Tally ERP 9 Release 1.51 which probably seems to be a BUG in this Release (i.e. Release 1.51)
BUG:
When a request is sent to push/pull data, the Tally Software terminates with the following message :-
Internal Error: Contact Tally Solutions
Software Exception c000005
(Memory Access Voilation)
PS:
Though it prima-facie appears to be BUG (according to us), it has NOT yet been confirmed by Tally Solutions, Bangalore.
BUG:
When a request is sent to push/pull data, the Tally Software terminates with the following message :-
Internal Error: Contact Tally Solutions
Software Exception c000005
(Memory Access Voilation)
PS:
Though it prima-facie appears to be BUG (according to us), it has NOT yet been confirmed by Tally Solutions, Bangalore.
Thursday, September 24, 2009
Tally ERP 9 Release 1.5 issues
While importing Masters into Tally ERP 9, we have noticed some issues. The tests that we performed on different versions of Tally are given underneath :-
Tally 7.2 Release 3.12
1) Start UDIMagic and import the "Master - StockItem Master Excel sheet" data into Tally. This will import 2 stock-items into Tally.
2) Once again import the same data into Tally. There is no ERROR. As these records already exist in Tally, they are modified /overwritten.
Tally 9 Release 2.14
1) Start UDIMagic and import the "Master - StockItem Master Excel sheet" data into Tally. This will import 2 stock-items into Tally.
2) Once again import the same data into Tally. There is no ERROR. As these records already exist in Tally, they are modified /overwritten.
Tally ERP 9 Release 1.5
1) Start UDIMagic and import the "Master - StockItem Master Excel sheet" data into Tally. This will import 2 stock-items into Tally.
2) Once again import the same data into Tally. There is an ERROR message which says that these records are already there.
To solve the issue with Tally ERP 9, you must add the following option in the UDIMAGIC.INI file.
[UDIMAGIC]
IgnoreDuplicateMasters=Yes
PS:
The option IgnoreDuplicateMasters=Yes must be added directly under the Heading [UDIMAGIC]
Tally 7.2 Release 3.12
1) Start UDIMagic and import the "Master - StockItem Master Excel sheet" data into Tally. This will import 2 stock-items into Tally.
2) Once again import the same data into Tally. There is no ERROR. As these records already exist in Tally, they are modified /overwritten.
Tally 9 Release 2.14
1) Start UDIMagic and import the "Master - StockItem Master Excel sheet" data into Tally. This will import 2 stock-items into Tally.
2) Once again import the same data into Tally. There is no ERROR. As these records already exist in Tally, they are modified /overwritten.
Tally ERP 9 Release 1.5
1) Start UDIMagic and import the "Master - StockItem Master Excel sheet" data into Tally. This will import 2 stock-items into Tally.
2) Once again import the same data into Tally. There is an ERROR message which says that these records are already there.
To solve the issue with Tally ERP 9, you must add the following option in the UDIMAGIC.INI file.
[UDIMAGIC]
IgnoreDuplicateMasters=Yes
PS:
The option IgnoreDuplicateMasters=Yes must be added directly under the Heading [UDIMAGIC]
Thursday, August 27, 2009
Slow uploading of data into Tally ERP 9
Tally ERP 9 Speed Issues
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.
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. You can get more information about this issue (Tally ERP 9 speed issues with SELECT SQL) at http://www.rtslink.com/tally/tally-erp-9.html#speed-issues
Solution
UDIMagic v3.0 Release 1.97 uses a different technique to process the Masters records. This eliminates the use of SELECT SQL and results in improved performance.
If you are using Tally ERP 9 and experiencing slow speeds, please follow these steps :-
1) Upgrade to UDIMagic v3.0 Release 1.97 (or higher)
2) Make the following changes in the UDIMAGIC.INI (configuration file)
[UDIMAGIC]
;;Add this line under the UDIMAGIC heading
IgnoreDuplicateMasters=Yes
3) Save the UDIMAGIC.INI file and retry importing data into Tally ERP 9 using UDIMagic.
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.
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. You can get more information about this issue (Tally ERP 9 speed issues with SELECT SQL) at http://www.rtslink.com/tally/tally-erp-9.html#speed-issues
Solution
UDIMagic v3.0 Release 1.97 uses a different technique to process the Masters records. This eliminates the use of SELECT SQL and results in improved performance.
If you are using Tally ERP 9 and experiencing slow speeds, please follow these steps :-
1) Upgrade to UDIMagic v3.0 Release 1.97 (or higher)
2) Make the following changes in the UDIMAGIC.INI (configuration file)
[UDIMAGIC]
;;Add this line under the UDIMAGIC heading
IgnoreDuplicateMasters=Yes
3) Save the UDIMAGIC.INI file and retry importing data into Tally ERP 9 using UDIMagic.
Subscribe to:
Posts (Atom)