Tally to Relational database

Here's a sample XQuery that exports Tally data into multiple Relational tables viz

mvoucher.dbf - main voucher table
ledvouch.dbf - child table which contains ledger details
invvouch.dbf - child table which contains Inventory details

Download the XQuery to export Tally data into multiple relational tables
View the Instructions PDF file for exporting Tally data into multiple relational tables

PS:
a) Works with RTS-XQuery Freemium v1.0 Release 3.0 or higher
b) Please read the Instructions given in the PDF file (which is included in the zip-file).

Using Macros with RTS-XQuery Freemium

RTS-XQuery Freemium v1.0 Release 2.4 supports VBA macros. This facilitates easy and faster generation of Reports in MS-Excel (i.e Tally to Excel Reports).

Here's a sample :-

Party and StockItem wise Sales

This XQuery retrieves raw data from Tally and generates :-
a) Party-wise sales for each StockItem or
b) StockItem-wise sales for each Party

For more details, refer the Instructions-PDF file provided with the sample XQuery-files which can be downloaded from this link :- party-and-stockitem-wise-sales.zip