Hello, working with SuiteQL to pull Purchase Order (Transaction) data, and we want to pull transactions based on their location, while in the UI and REST api I can see the location (as classification, or in the rest object), when I try to get these transactions through SuiteQL I cant’ seem to find the appropriate field for filtering by location. I could possibly join the transaction lines that contain that info, but I am just curious if there is a 1-1 table join I can use to find the location. Just for context for Sales Orders, we were able to join with the salesOrdered tabled, and filter the location this way. I am just hoping there is a similar path for POs, is there?

Join to transactionline with mainline = T

Splendid!! It works as intended, thank you so much!

Hi @Vasilis Spilka, do you mind sharing how you were able to query for purchase orders? This doesn’t work:

SELECT * FROM purchaseorder

They will be on the

transaction

table with

type

= 'PurchOrd'. If you can't see them it's most likely due to permissions

Ah, I see. This is really helpful. Thank you! 🙏