I would like to create a saved search or SuiteQL which will return a list of Sales Orders where the PO Vendor field on the sales order line has po vendor.internalid=?
I do not want to create the Drop Ship or Special Order PO, I need to make this determination before creating the the PO's.
The field is povendor when looking at the XML.
How can I get a list of sales orders with lines that have sales order.line.po vendor.internalid=?
