We are trying to retrieve Invoice line item data through the ODBC connection. We can connect to Sage and retrieve the Customers tables (and other tables) just fine. I do not see INVOICE or INVOICE_ITEM table in the list of tables. Trying to pull into Excel via ODBC from Sage 50 2021. Do I have the right table names, for invoice info? Is there something I have to set up in Sage in order to see the tables through ODBC?
Any help is appreciated. Have no desire to write data, just read.
Thanks