When you import data into Tally Software using UDIMagic, it gets imported into the Current Company, by default.
To import data into a specific Company in Tally, you need to use the COMPANYNAME attribute. Generally, this is required when two or more companies are open in Tally and you wish to import data into a specific company.
Herein, we shall take a simple Excel sheet that contains Stock Item Masters. For simplicity, we have taken only the Stock Item NAME in the Excel Sheet.
Download the Excel sheet with the XML tags.
Follow these steps to import data into Tally
1) Create two Companies in Tally. viz "Company A" and "Company B"
2) Select the "Company A".
3) Minimize Tally software.
4) Run UDIMagic and follow instructions in the wizard to Import data from the sample Excel-sheet.
You must select the XML tags file in the same screen in which you are prompted to select the Excel file.
If everything goes fine, then 5 Stock Item master records will be imported into "Company B" in Tally.You can view the same using "Gateway of Tally >> Inventory Info >> Stock Item >> Display" option.
Attribute : COMPANYNAME
Applies to: MASTER and VOUCHER tags
Example 1:-
<MASTER TYPE="LEDGER" COMPANYNAME="MyCompany">
.....XML tags.....
</MASTER>
Example 2:-
<VOUCHER COMPANYNAME="MyCompany">
.....XML tags.....
</VOUCHER>
Remarks:-
1) The COMPANYNAME attribute can be used with the MASTER and VOUCHER tags only.
2) If there two or more MASTER tags (or VOUCHER tags) in a single XML file, then you need to use the COMPANYNAME attribute with each MASTER tag.
Showing posts with label Exercise 13. Show all posts
Showing posts with label Exercise 13. Show all posts
Monday, June 16, 2008
Subscribe to:
Posts (Atom)
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.
=========================================================
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.
=========================================================