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