I need to create a Saved Search that pulls a total of items for a Sales Order with the components of the associated Work Orders. The example below shows SO538 with 4 Work Orders. I need to get all of the components within each of those Works Order and summarize it by item. For example how many of part 123-4 do have have in total in those 4 Work Orders.
Looking forward to suggestions, ideas or solutions. Have a great day.