How to extract GSTr 3B Report from Tally via ODBC

Question

I am able to extract sales data from tally via ODBC with the following code (Thaks to the user Adarsh Madrecha & Shweta Softwares)

Select Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsSales:$VoucherTypeName"
TDL 
[Collection: RTSAllVouchers]  
Type: Voucher  
IsODBCTable: Yes  
Fetch : *, AllLedgerEntries.*, LedgerEntries.*

In similar way I want to extract

1. GSTR 3B report in excel via ODBC
2. Sales register in columnar format

Answer 1

You can write a collection to fetch the required data.