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

FROM SuiteTalk.Invoice;

Thank you very much

Rookie Asked on January 31, 2024 in SuiteTalk.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor