with SuiteQL can I join the related records of a transaction? for example, can I select

purchase orders

and join the

vendor bills

related to it?

Yes - to do so, you'll need to use the

transactionline

table for the PO transaction and join to the

nexttransactionlinelink

table on

previousdoc

and

previousline

filtering for

nexttype

which matches a Vendor Bill type.

thanks @Clay Roper -- I'll try that : )

You're welcome! Definitely keep an eye out for the fact that each PO line can be associated with one or more vendor bills, and each line on the PO will be associated with a specific line on the bill

there's no DB schema of all that, I guess? anyways, thanks for the heads-up! appreciated, @Clay Roper

Here's the Analytics browser page for nexttransactionlinelink