Standard templates for all versions

You can now download the Standard templates for the latest udi-Magic version and all earlier versions too from here.

The download link is :
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip

How to specify XML tags file name in the XLS file ?

While importing data from Excel to Tally using udiMagic Software, you can :

a) Select the XML tags file using the udiMagic interface; or
b) Specify the XML tags within the Excel file.

Here are the steps to specify the Mapping (XML tags) file name in the Excel sheet.

1) Open the Excel sheet.
2) Right click the cell A1 and select option "Insert/Edit Comments"
3) Type out the following :

<XMLTAGSFILENAME> theXmlFileName </XMLTAGSFILENAME>

4) Save the Excel sheet.

Now, while importing using udiMagic, you can simply select the XLS file and no need to select the Mapping (Xml) file.

Some Common errors

Error : File "UDILC.DAT" not found.
Resolution : Install udiMagic Software using the Setup file. Please search for the email sent to you at the time of Purchase of udiMagic Software. It contains link to download the setup file.

Error : File "UDILC2.DAT" not found.
Resolution : In older versions (i.e. v5.0 or lower), the UDILC2.DAT file is provided at the time of Purchase of Software. Please search for the email sent to you at the time of Purchase of udiMagic Software. It contains an attachment named "UDILC2.DAT" file. In udiMagic v6.0 or higher, it is generated automatically.

Purchase and Sales Horizontal formats

In udiMagic v7.0 Release 1.4 onwards, the Horizontal formats for Sales and Purchase have been removed and a common new format for Sales and Purchase is introduced.

For those using the udiMagic v7.0 Release 1.0 to Release 1.3, the Sales and Purchase Horizontal formats need to be updated as shown below :

1) Vouchers-V7-Sales-Horizontal-format-with-VAT-with-stockitems.xls
Changes in cell Z1  (Specify column V in the Round function)
Changes in cell AA1 (Specify column W in the Round function)
Changes in cell AB1 (Specify column X in the Round function)

2) Vouchers-V7-Purchase-Horizontal-format-with-VAT-with-stockitems.xls
Changes in cell AF5  (Specify column AB in the Round function)
Changes in cell AG5 (Specify column AC in the Round function)
Changes in cell AH5 (Specify column AD in the Round function)

3) Vouchers-V7-Purchase-Horizontal-format-with-VAT-without-stockitems.xls
Changes in cell N1  (Specify column M in the Round function)
Changes in cell P1 (Specify column O in the Round function)

Standard templates at Github

The Standard Excel templates shipped along with udi-Magic Software are now available at Github also.

The download link is :
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip

To view details on modifications
https://github.com/ShwetaSoftwares/standard-templates

PS:
From time to time, changes are done in templates by always of adding new fields/columns or features. These changes are made available only in the next release of udi-Magic Software. However, now you can access all the templates with updates at Github (even before they are made available with udi-Magic)

Creating Custom templates

Custom templates are created based on udi-Magic Standard templates. You don't have to alter your existing excel sheet, just map your excel sheet columns with one of the udi-Magic Standard templates.

For more details, refer Working with templates.

Version: udi-Magic v7.0

INTRODUCING UDIMAGIC V7.0

We are pleased to announce the launch of UDIMagic v7.0. The details are as under :-

Support for Tally ERP 9 Release 5.1 and  higher versions
UDIMagic v7.0 is compatible with Tally ERP 9 Release 5.1 and higher versions.
 

Upgradation charges
  

Version details	Light	Standard	Professional
v3.0 to v7.0 (Single user)	Rs 2000	Rs 2800	Rs 7500
v4.0 to v7.0 (Single user)	Rs 1500	Rs 2100	Rs 4500
v5.0 to v7.0 (Single user)	Rs 1000	Rs 1500	Rs 2500
v6.0 to v7.0 (Single user)	Rs  750	Rs  950	Rs 1800

a) The above charges are for Single-User version. For Multi-user version, the charges will be 2.5 times that of the Single-user charges as shown above.
b) Customers who have purchased UDIMagic v6.0 on or after 04/08/2015 shall be provided upgrades free-of-charge

c) Customers who are using UDIMagic v6.0  and have taken AMC shall be provided upgrades free-of-charge

PS:
a) Tally ERP 9 Release 5.1 is not presently available for all Indian States (dt: 3rd Nov 2015).