Monday, June 9, 2008

Exercise 9: Stock Item Master with Aliases

STEPS:-
1) Create an Excel sheet with following Columns :-
a) NAME (Column A)
b) PARTNO (Column B)
c) ALIAS for NAME (Column C)
d) ALIAS for PARTNO (Column D)

2) Enter 5 records in the Excel sheet.
(The 1st row in the Excel sheet must be the HEADER and data must start from the 2nd row onwards).

3) Write XML tags to import data from the Excel sheet into Tally.
(XML tags are to be written in a separate file).

Try importing the data into Tally 9 as well as Tally 7.2. Solution to this exercise shall be made available tomorrow.

No comments:

Excel to Tally and lots more...

UDI-Magic is a software utility that allows you to Import data into Tally. It supports Import of data from various sources like Excel, SQL Server, MySQL, Access, DBF and various other DBF formats.

Website :- www.rtslink.com/udimagic.htm
Blog-site :- www.udimagic.blogspot.com

If you are new to this blog-site, we advice that you read the Posts from the beginning.i.e. Exercise 1 onwards. The bog-archive is given on the left-hand-side.

=========================================================