How to extract Bills receivable data to excel from tally by ODBC

Question

I am new to extracting data with ODBC Tally ERP 9.0. I researched and got some help with Extracting Day Books / Transaction Data from Tally using ODBC Although this solution helps in some way it doesn't fully solve the problem. I want to get data in this format Date Party's Ledger Name Voucher No Amount.

Answer 1

To obtain the company's receivable bills, you must create a collection as shown below.

[Collection: CMPRecevables]

    Type            : Bills
    Is ODBC Table   : YEs
    Filter          : IsReceivable
    Fetch           : Name, BillDate, Parent, ClosingBalance    

Connect this table using odbc and use below query

select $Name, $BillDate, $Parent, $ClosingBalance from CMPRecevables