I possess an inventory item- Part X, which serves as a direct component of Assembly A.
Furthermore, this same inventory item(Part X) is utilized as a component within sub-assembly B, which is a component into Assembly B.
Consequently, we generate Sales Order #1 for Assembly A and Sales Order #2 for Assembly B and Sales Order #3 for Part X. Please refer to the Order quantity and member quantity of the Assembly items.
Sales Order #1
Assembly A: Order Qty 1
Part X: Qty 2
Sales Order #2
Assembly B: Order Qty 1
Sub-Assembly B: Qty 3
Part X: Qty 2
Sales Order #3
Part X: Qty 4
In this Scenario, the desired outcome from the saved search should display the total order quantity of the inventory item as follows:
- Sales Order #1: Part X - Qty 2
- Sales Order #2: Part X - Qty 6
- Sales Order #3: Part X - Qty 4
Is it possible to achieve this through a saved search or workbook?
Alternatively, are there any alternative methods to accomplish this outcome?