'How to extract GSTr 3B Report from Tally via ODBC

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

Thanks in Advance

tallytdl


Solution 1:[1]

You can write a collection to fetch the required data.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Ramajayam J

Related Questions