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.
Hi Peter,
Thanks for sharing the Influence link, in that way other partners and consultant can Up Vote this enhancement as well.
Best,
Ivan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ivan,
thank you - just noticed that such a request is already in the system: Link to influencer proposal 52084
Best regards, Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I am also highly interested in a possible solution to "freeze" the forecast entry in the current month, and (depending on the date) also the upcoming month.
I see this lack of functionality functionality in SOP and Demand Planning as a considerable hole in IBP (now running 1711), and I hope that a not too distant update will start providing this.
We had to develop a cumbersome and clumsy way using helper key-figures and some HCI jobs running at a certain date to build the functionality.
I would strongly support some development by SAP to make this functionality available.
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
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.