rtslink.com
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.

Valid HTML 4.01 Transitional