Our Manufacturing process can take several months and we've therefore started utilizing BOM Routing Links to link our raw materials to specific sequences in our Routings. This allows us to better forecast (via MRP) when our raw materials are needed. MRP appears to use the BOM Routing Links to calculate the Planned Picks when looking at existing Manufacturing Orders. However, we want to use Sales Forecasting. When using Sales Forecasting, MRP is always setting the Planned Pick date as the planned release date on MO and ignores the BOM Routing Links.
For example:
The BOM for "FG001" has 1 Raw Material item ("RM001") and the Qty is 100
The Routing has 3 sequences,
- SEQ 1 takes 30 days
- SEQ 2 takes 90 days
- SEQ 3 takes 30 days
using the BOM Routing Link we link RM001 to SEQ 3 which implies that we don't need to pick RM001 until 120 days after the release date of the MO
If we create an MO for 100 units of "FG001" with a release date of 07/01/2020 and regenerate MRP, the Planned Pick for RM001 is 10/29/2020 (120 days after the release date) - this appears correct.
If we create a Sales Forecast with "FG001" due on 11/01/2020 and regenerate MRP, the Planned Pick for RM001 is 06/04/2020, the planned released date of the Planned MO. This is incorrect because it is ignoring the BOM Routing Link. The Planned Pick date should be 10/02/2020 which is 120 days after the planned release date.
I'm wondering if anyone is experiencing the same. Not sure if this is a limitation in the calculation of MRP if I'm missing something in setup.
