Pulling Invoice Item details through ODBC Hello. I...
# suitescript
j
Pulling Invoice Item details through ODBC Hello. 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 FROM SuiteTalk.Invoice; How do I pull the Item sublist fields through ODBC? Thank you very much
g
Do you really need to use ODBC?