Skip to Content
0
Jan 19, 2023 at 05:52 PM

Roll over of demand in DP

166 Views

Hello Folks,

This is regarding rollover of unconsumed forecast.

The requirement is to roll over unconsumed forecast from one week to the next. This has to be done cumulatively.

In the ex below, the last row 'Updated Demand' has the cumulative unconsumed forecast.

rollover.png

Restriction is to rollover unconsumed forecast within that month only. So, for current Jan month, the open forecast cannot be rolled over from Dec month and the current unconsumed forecast for the Jan month cannot roll over to Feb month.

Had thought to use Dynamic Rolling aggregation (IBP_DYNAMIC_RAGGR), however, not sure how to ensure the constraints for maintaining the current month.

Any other direction?

Thanks

Attachments

rollover.png (13.3 kB)