Scenario:
We are using Time Phased replinishment with Forecast Consumption Demand Source from a manual demand plan, with 90 backwards and 90 forwards consumption days.
The manual Demand Plan for an item has deman qty 500 for November and 500 for December. Safety Stock is set to 100. No Open Sales Orders, No Open Purchase Orders. Generating the Item Supply plan from 10/25/22 through 4/1/23 will suggest PO's of 1100 units. Perfect (500+500+100)
Enter a Sales Order with a Supply Required by Date of 12/8/22. Regenerate Supply Plan, still suggests 1100. Perfect, the sales order demand is consumed by the forecast.
Enter a Purchase Order for 400 with receipt date of 12/01/22. Regenerate Supply Plan, now suggests 700. Perfect. 400 on order plus another 700 = 1100
Change receipt date on Purchase Order to 12/9/22 (1 day later than the Sales Order required date). Regenerate Supply Plan, now suggests 1100 again even though the other 400 are coming only 1 day late.
How can I tell Netsuite that I want to include that purchase order in my item supply plan even though it is a little late? The reality of the situation is that if I order 1100 (400 more), I will have 400 too many and with a seasonal business, I would have to carry the extra 400 until next year.
Thanks!