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.
1 comment:
to import the company through xml
please tell the xml tags for importing company into tally
please connect on
mdsaleembaba1234@gmail.com
thanks
Saleem
Post a Comment