Home / Free Tally utilities / RTS-XQuery Freemium / Sample XQueries

Sample XQueries

Here are some sample XQueries that you can use to transfer Tally data to MS-Excel and DBF. These XQueries have been tested with the following Tally versions :-

Tally ERP 9 - Release 1.52
Tally ERP 9 - Release 1.50
Tally ERP 9 - Release 1.30
Tally 9 - Release 2.14
Tally 9 - Release 1
Tally 7.2 - Release 3.12

Download Query File	Description	Date
tally-to-relational-database.zip	Export the Tally data into Relational database tables. viz mvoucher.dbf - main voucher table ledvouch.dbf - child table with ledger details Invvouch.dbf - child table with Inventory details	07/11/2009
party-and-stockitem-wise-sales.zip	Generates Party-wise and StockItem-wise Sales Register in MS-Excel. For detailed instructions, read the Instructions (pdf) file provided within the zip file.	03/11/2009
xquery-daybook-vouchers-financial-details.xq	Transfer financial details viz. "VoucherNumber, Date, LedgerName, Amount" etc from Tally to MS-Excel.	25/10/2009
xquery-daybook-vouchers-inventory-details.xq	Transfer inventory details viz. "VoucherNumber, Date, StockItemName, Qty, Rate, Amount" etc from Tally to MS-Excel.	25/10/2009
xquery-daybook-vouchers-financial-details-tally-to-dbf.xq	Transfer financial details viz. "VoucherNumber, Date, LedgerName, Amount" etc from Tally to DBASE (DBF) PS: You must specify proper Connection String in "RTSXQueryFreemium.ini" file	25/10/2009
xquery-abc-analysis-amtwise.xq	ABC Analysis of StockItems (Value-wise)	25/10/2009
xquery-abc-analysis-qtywise.xq	ABC Analysis of StockItems (Quantity-wise)	25/10/2009

For more information, refer http://www.rts-xquery-freemium.blogspot.com

Tags: br> RTS-XQuery, Freemium, Tally to Excel, Tally to SQL-Server, Tally to MySQL, Tally 9

Tally is a registered trademark of Tally Solutions FZ LLC.

Home \| RTSLink \| Downloads \| Contact Us \| Buy \| FAQ
Designed by Indiatimes Webuild - vSplash	© 2008. Shweta Softwares. All rights reserved.