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.

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).

Excel to Tally - Sample Excel Sheet formats

The following sample Excel sheets formats are now available for UDIMagic users :-

UPDATED : 2018-02-10
New Templates available at :
https://www.rtslink.com/products/udimagic/standard-templates/

***************************************************************************

The templates shown below are now discontinued.

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

---