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

Introducing udi-Magic v3.0 Professional version

Tally Integration made Easy

udi-Magic v3.0 Professional allows you to retrieve data from External databases and send it directly to Tally Software.

Useful for Software Developers
udi-Magic professional is particularly useful for Software Developers / programmers who wish to INTEGRATE their software with Tally Accounting Software. Instead of modifying the existing program code, Developers can integrate with Tally by merely writing few SQL-SELECT and XML tags.

Useful for End-Users
Users (i.e. end-users) who wish to Integrate software with Tally but do not have the source-code of the program can do it using udi-Magic professional. Full support is provided by for writing SQL-SELECT statements and XML tags for Tally Integration.

In the coming days/weeks, support for additional databases shall be included in the udiMagic professional version.