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.

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

Thursday, June 5, 2008

Solution to Exercise 5

Download the Excel sheet and XML tags file for Exercise 5.

Explanation

Before creating STOCKITEM masters, we need to create the other Masters viz. UNIT and STOCKGROUP. The XML tags for same are given herewith for your reference.

XML tags to create UNIT Masters

<MASTER TYPE="UNIT"/>
<NAME COLUMNREFERENCE="C"/>
<ISSIMPLEUNIT>Yes</ISSIMPLEUNIT>
</MASTER>

Remarks:-
1) The UNIT Master does not support Aliases. Hence, we cannot use the <NAME.LIST> tag as used in other Masters.
2) The above tags instruct UDIMagic to create UNIT Masters based upon Column C data in Excel Sheet.

XML tags to create STOCKGROUP Masters

<MASTER TYPE="STOCKGROUP"/>
<NAME.LIST>
<NAME COLUMNREFERENCE="B"/>
<NAME.LIST>
</MASTER>

Remarks:-
1) The above tags instruct UDIMagic to create STOCKGROUP Masters based upon Column B data in Excel Sheet.

XML tags to create STOCKITEM Masters

<MASTER TYPE="STOCKITEM"/>
<NAME.LIST>
<NAME COLUMNREFERENCE="A"/>
<NAME.LIST>

<!-- STOCKGROUP Name to be taken from Column B-->
<PARENT COLUMNREFERENCE="B"/>

<!-- BASEUNITS to be taken from Column C-->
<BASEUNITS COLUMNREFERENCE="C"/>

<!-- PART NUMBER to be taken from Column D-->
<ADDITIONALNAME COLUMNREFERENCE="D"/>

</MASTER>

Remarks:-
1) The <ADDITIONALNAME> tag is used to specify the Part Number.
2) You can also specify Alias for Part-number using the following tags:-

<ADDITIONALNAME.LIST>
<ADDITIONALNAME>....Part No....</ADDITIONALNAME>
<ADDITIONALNAME>....Alias1 for Part No....</ADDITIONALNAME>
<ADDITIONALNAME>....Alias2 for Part No....</ADDITIONALNAME>
</ADDITIONALNAME.LIST>

Tips:-
1) Use Internet Explorer (or Firefox) to view the XML tags file.
2) For editing the XML tags, you can use any XML Editor (like Microsoft Visual Web Developer 2005 Express Edition).
3) You can get the Tally XML tags for any Master from Tally Software itself. All you need to do is to manually enter a dummy record in Tally and then Export it using option "Gateway of Tally >> Display >> List of Accounts >> Alt+E". This generates the XML tags for the Master record in file MASTER.XML

No comments: