Hi everyone,
I’m currently implementing ERPNext for a garment manufacturing setup and facing a limitation with how MRP is working for our use case.
Our requirement is slightly different from standard MRP logic, and I’d appreciate suggestions on how to approach this.
Current Scenario:
-
We manufacture garments based on sales orders.
-
We maintain stock of both raw materials (fabric, trims) and finished goods.
-
We also hold inventory on behalf of specific customers (dedicated stock).
What we need from MRP:
-
Generate material requirements based on:
-
Confirmed Sales Orders
-
Forecasted demand (optional but preferred)
-
-
Consider:
-
Existing raw material stock
-
Open Purchase Orders
-
Reserved / customer-specific stock
-
-
Planning Logic:
-
We want procurement planning for a rolling 3-4-months stock level, not just order-based planning
-
Maintain minimum stock based on historical consumption / pullouts
-
-
Customer-Specific Inventory:
- Certain fabrics are reserved for specific customers and should not be used for others
-
Cross-Order / Cross-Customer Material Usage Visibility (Important):
-
If a material (fabric/trim) is being used across multiple orders or customers, we want:
-
A consolidated usage summary
-
Visibility of total demand across all orders
-
Ability to see which orders/customers are consuming that material
-
-
Essentially, a material-wise demand aggregation view, not just order-wise planning
-
-
Required Outputs:
-
Shortage vs available stock
-
Excess stock
-
Coverage (in months)
-
Consolidated demand per material
-