We are using NetSuite Advanced Manufacturing and MRP, and we're trying to determine whether there is a standard configuration that controls how planned work orders are generated. Our setup is as follows:
- A top-level assembly is created as a Special Work Order from a Sales Order.
- The top-level assembly contains subassemblies/components (1 unit each) that are stock-planned items (Item Source = Stock), rather than Work Order sourced.
- We intentionally use stock-planned subassemblies because we want MRP to generate supply based on demand instead of automatically creating child work orders for every parent's work order.
The issue is that when multiple Sales Orders have similar required dates, MRP combines the demand for the stock-planned subassemblies into a single Planned Work Order. For example:
- Sales Order 1 generates Parent Work Orders WO1, WO4, WO5, WO6, and WO8.
- Sales Order 2 generates Parent Work Orders WO10 and WO12.
Expected MRP result of the subassembly:
- Planned Work Order A = Qty 5 (to satisfy the demand from WO1, WO4, WO5, WO6 and WO8)
- Planned Work Order B = Qty 2 (to satisfy the demand from WO10 and WO12)
Actual MRP result of the subassembly:
- One Planned Work Order = Qty 7 covering demand for all parent Work Orders from different sales orders.
Our question is:
Is there any standard MRP configuration, planning parameter, lot-sizing rule, planning group, demand grouping option, or other feature that allows MRP to generate planned work orders separately by parent work order or by originating Sales Order, while still keeping the subassemblies as stock-planned items?Or is this aggregation simply standard NetSuite MRP behavior unless the subassemblies are Work Order sourced?We would appreciate any recommendations or best practices from others who have implemented a similar manufacturing process.
Note: Our Supply Lot Sizing Method Is "Lot for Lot".