You asked for it, you got it! Join the webinar Getting the Most out of NetSuite Standard Costing Capabilities on June 28, 2022 at 11AM PT. Register here!
How can I create a search to pull assemblies (with work orders) & their items (no work orders)
Sorry if my title is confusing...
Basically, we have sales orders with both assembly items (will have an associated work order) and inventory items (will not have an associated work order). The work order for the assembly items has a ship date, but we also need a saved search that (based on ship date of the assembly item's work order) pulls the related inventory items from the sales order that do not have a work order. See example image- it doesn't matter if the ship date is only showing on the assembly item. What's important is that the assembly item and the inventory items are grouped