We have a set up where we have a weekly forecast with a redutcion key of 4 weekly buckets. And up to recently this has been working ok for us. However we have entered a busier period and the disaptching units have fallen behind for sales orders.
For instance we have a item that is forecasted as 600 untis per week. We have 1200 units of sales order for date prior to today. and 50 for the rest of the week from today. The reduction key is only deducting the 50 and the 1200 demand is ignored as it is in the apst and outside the start date of the reduction key.
I ahve tested setting the reduction key to have a effective date of the start of the year and rolling forward 2 months. I ahve about 2 weeks worth of sales orders back logged but with the effective date of 01/01./23 through to 30/05/23. This is resulting in wipeing the fromecast for nearly the whole of the period and that is 1000s of units over what should ahve been deducted.
How do I set up a forecast deduction to offset sales order due in the past?
