on 05-18-2017 2:08 PM
Dear Experts,
We have a requirement to set Frozen Horizon flexibly based on Product Class. As such,
1. For Product Class A, forecast cannot be entered for current week and next week -> any updates can be done from Week 3 onward (considering current week as Week 1)
2. For Product Class B, forecast cannot be entered for current week and next 3 week -> any updates has to be entered from Week 5 onward
and so on.
We have written a macro to identify the time period as frozen or editable locally in excel worksheet, but the refresh time is significantly higher -> due to macro reading each cell one by one and locking.
As we are only using S&OP module for Sales Forecasting modelling, we are not configuring Product-Location based Frozen Horizon, and use Heuristics/Optimizer to prevent Supply Plan change due to changes in Sales Forecast entered in the 'frozen horizon' .
Please guide, if there is any other elegant methods that can be used fo rthis.
Regards,
Shivpriye
Hi Shivpriye, Peter,
Besides the mentioned workarounds, I am not aware of other ways to accomplish this functionality. I would suggest you to submit this enhancement directly to the Demand/Supply Product Management teams, via the IBP Influence Channel: https://launchpad.support.sap.com/#/notes/2479068
Best,
Ivan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.