Pulling Invoice Item details through ODBC
I’m using ODBC to pull transaction records to make a custom module for commissions and I need to separate the commissionable items by Item Class. However, I am only able to pull Invoice Header and custom fields, but no Item sublist fields.
I checked the permissions for the role used for the ODBC connection (via SuiteTalk) and I added everything I could think of.
For example, in this text, the *class* field returns as unrecognized while the rest works fine.
SELECT SuiteTalk.Invoice.InternalId, Job_InternalId,Job_name, [Project Name Only],[Amount after discount], class
Thank you very much