Hi, I’m trying to get the subsidiary associated to an invoice using SuiteQL. However, I can’t find the field within the table transaction. Does anyone knows how to get it ? 🙂 Thanks for your help !

Have you checked the Records Catalog?

Its in the Transaction Line table.

@Edgar Valdes but what if an invoice doesn’t have a transaction Line linked for example ? Will I be able to get the subsidiary ?

The items in the Invoice are the Transaction Lines.