Anonymous
Is there any method to import excel data to tally automatically.
From India, Mohali
There are many way to import vouchers from Excel to Tally. You can create XML file can import it in Tally under import of data option. But for that you have to know knowledge of Tally XML tag. Also some online tool is available which it auto create XML from Excel data and directly import it in Tally.
In XLtool there is very simple steps to import Excel data in Tally application.
Follow these steps for import vouchers Excel to Tally -
• Enable ODBC port in Tally application.
• Open one Tally application & open only one company.
• In XLTOOL software fillup the data in appropriate voucher template.
• Open MY MENU by F1 Key.
• click START button.
• Data will be imported in Tally.
• Download Excel template from - www.xltally.in
Following are the Tally XML tag for Vouchers -
XmlCode = "<TALLYMESSAGE xmlns:UDF=""TallyUDF"">"_
"<VOUCHER VCHTYPE="" ACTION="Create">"
<VOUCHERTYPENAME></VOUCHERTYPENAME>
<VOUCHERNUMBER></VOUCHERNUMBER>
<REFERENCE></REFERENCE>
<REFERENCEDATE></REFERENCEDATE>
<DATE></DATE>
<PARTYLEDGERNAME></PARTYLEDGERNAME>
<ALLLEDGERENTRIES.LIST
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<LEDGERNAME>Sachin</LEDGERNAME>
<AMOUNT> 500</AMOUNT>
</ALLLEDGERENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>"
End Sub

From India,

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server