I feel like I’ve asked this before but of course cannot remember the answer now. How can I search by the selected

povendor

(dropshipped) on salesorders for a particular vendor? I need to include sales that have not yet been processed (no purchase order created yet) but the intended dropship vendor has been selected on the lines of the sales order. Note that the selected vendor might differ from the default vendor for that item. This field doesn’t seem to reside either in saved search or SuiteQL.

If I remember correctly I ran into this issue, I solved it by

record.load

and getting it from the sublist lines. Its not the most efficient way but my workaround.

Unfortunately this won’t work for my needs, as I want to add a list of “related transactions” on each vendor record, by pulling from this data…. so I need to search by vendor id.

Once you receive the

povendor

(vendor id) you can execute another search by vendor id.

I cannot find a way to run any sort of search that is “get me all things to be dropshipped to vendor id 12345”