I'm trying to return a search with the Work Order # that is created from "special order" assembly item on a Sales Order. I created a transaction search and there is the "Purchase Order..." join that allows me to get any PO#'s from "special order" inventory items. But no "Work Order..." join for assembly items. Anyone know how I could return this?

how about this field ? Applying Transaction : Document Number

Isn't the PO and the WO join the same field on the SO?

I think so but its two different checkboxes i think