HI, i am new to TDL i have tried below code to export Purchase Register via ODBC to make entires in our ASP. Net based application. i am getting only single row for each voucher in purchase if i filter the vouchertypename. i want all the row for each item in the purchase entries done. [Collection: DDAllVouchers] Type: Voucher IsODBCTable: Yes Fetch : *, AllLedgerEntries.*, LedgerEntries.*,AllInventoryEntries.* [Collection : DDINVCol] Source Collection: DDAllVouchers Is ODBC Table : YEs Fetch : VoucherTypeName, Vouchernumber, Date, AllInventoryEntries.BilledQty, AllInventoryEntries.ActualQty, AllInventoryEntries.StockItemName, AllInventoryEntries.Amount
