UDIMagic v1.0 to retire from 31/3/2008

It has been an year since UDIMagic v1.0 was launched.

UDIMagic v1.0
UDIMagic v1.0 supported transfer of Masters data from Excel to Tally. It had limited functionality for even transferring the Master's data too. i.e. the fields were limited.

UDIMagic v2.0 and v3.0
Later on UDIMagic v2.0 was introduced which supported transfer of Vouchers from Excel to Tally.

UDIMagic v 3.0 followed which added support for VBA (Visual basic for Applications). It also supported all Tally features like Cost Centres; Cost Categories; Multiple Currencies; Multiple Godowns etc. The UDIMagic v3.0 also supports user-defined Voucher-types, and fields created using TDL (Tally Definition language).

In this fast-changing technology era, it has become crucial for us to concentrate on the latest technologies in order to make our products more robust and scalable. There have been several new releases for UDIMagic v3.0 till date, each one adding some new functionalities.

In view of the above, we have decided to withdraw support for UDIMagic v1.0 from 31/3/2008 only.

Users of UDIMagic v1.0 are adviced to upgrade to the latest version and reap the benefits of new functionalities.

UDIMagic DCP (Partners)

You can now buy UDIMagic from our Partners in your proximity.

Click here to view the UDIMagic Partners list.

How to get the Financial Year from a given Date ?

First of all, why do we require this thing ?

Let me clarify it. While importing Vouchers from Excel to Tally, we require a field which contains unique values. Normally, there is such a field (Invoice Number for Sales) which contains unique values. However, Invoice numbers are unique for a given year and the number restarts from 1 every year. This would create problems as the next year vouchers will overwrite the current year vouchers. Hence, we need to generate a unique value which is a combination of the "Invoice Number" and the "Financial Year".

Here's the Excel formula to get the FINANCIAL-YEAR from a given Date.

FORMULA

=IF(AND(MONTH($A#)>=4,MONTH($A#)<=12),
YEAR($A#) & "-" & YEAR($A#)+1,YEAR($A#)-1 & "-" &YEAR($A#))

Example

DATE           FINANCIAL YEAR
2007-04-01     2007-08
2008-04-01     2008-09

Remarks:-
1) To test the above formula, substitute the A# with the Excel-sheet Cell-reference (say A1).
2) To use this formula in UDI-Magic XML tags, you need to replace the special characters with their ESCAPE SEQUENCES.

Ole Error 800A03EC

FAQs: Excel to Tally

"I am using udi-Magic to import Vouchers from Excel into Tally 9. While importing the data, udi-Magic shows an error message "Ole Error 800A03EC".

Solution:-
It is likely that you are using a FORMULA in the XML tags which is incorrect. In case if you are using several FORMULA's then you must test-check each FORMULA. This can be done by tying out the Formula directly in the MS-EXCEL sheet itself.

For Example, if the XML tags have a Formula as shown underneath:-

FORMULA="=F# & "/" & O#"

You can test-check the above formula in EXCEL as given underneath:-

In the Excel sheet, enter the formula given underneath in any cell (say cell Z2).
=F2 & "/" & O2

You need to test-check each FORMULA that is used in your XML tags. If you get error message while testing the Formula in EXCEL, it means that Formula is incorrect.

Remarks:-
In XML, there are certain characters which have special meaning and are called ESCAPE SEQUENCES. You can get more information about Escape Sequences from this link:-

XML Escape sequences

In simple words, a formula used in Excel sheet is to be changed when used in XML tags as given underneath:-

Excel sheet formula:-

=F2 & "/" & O2

XML tags formula :-

FORMULA="=F# & "/" & O#"

---

UDI Magic Tutorials - Excel to Tally

Topic: Import UNIT Master data from Excel into Tally Software

This tutorial covers how to use UDIMagic utility to import UNIT Master records from MS-Excel into Tally Accounting Software.

Visit UDIMagic tutorials page at our site.

SQL Server to Tally Software

Tally Integration made Easy

New Release 1.3
udi-Magic v3.0 Release 1.3 [Professional] allows you to transfer data directly from MS SQL Server to Tally Accounting Software using few SQL-SELECT statements and XML tags.

Supports all versions of Microsoft SQL Server.

Click here for more details on MS SQL Server to Tally

XBase (DBF) to Tally Software

Tally Integration made Easy

New Release 1.2
udi-Magic v3.0 Release 1.2 [Professional] allows you to transfer data directly from XBase (DBF) files to Tally Accounting Software using few SQL-SELECT statements and XML tags.

Supports
a) DBase
b) Fox 2.x
c) Visual Foxpro DBFs and DBC files
d) Other XBase file formats.

Click here for more details on XBase (DBF) to Tally