Online tutorials on Tally, Tally.ERP XML tags, Excel to Tally and more..

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.

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

Wednesday, June 4, 2008

Exercise 5 - Stock Item Masters with PartNo,BaseUnits

Create an Excel sheet with the following data :-

1) NAME (Stock-Item Name in Column A)
2) PARENT (Stock-Group Name in Column B)
3) PARTNO (Part-Number in Column C)
4) UNIT (i.e.Nos or Ltrs in Column D)

Enter 5 records in the Excel Sheet. Next, write the XML tags in a separate file and try importing the same into Tally using UDIMagic.

Solution to Exercise 5 shall be provided in the next post.


No comments: