ODBC - Export Vouchers in Excel

Hi All

I want to export Vouchers + it's associated Ledger Entries in Excel.
I followed steps to expose Voucher as ODBCTable by creating TDL

[Collection: Vouchers]
Type : Voucher
Is ODBCTable: Yes

I can not get "Vouchers" table in excel but unable to fetch ledgerentries associated with the voucher.
Any help is appreciated.

 

[Collection: Vouchers]
Type : Voucher
Fetch : vouchernumber,Date
Walk : Ledger Entries
Fetch : Ledgerentries.*
Is ODBCTable: Yes

You need to Walk/Fetch the subcollection (Ledger Entries)

Then only it will be Expose to ODBC Tables

 

hi all
Its not working i am getting only first line of item of the voucher

 

so, where to find these subcollection names