Safety stock macro is not showing correctly at 'Total' level

[PK09]

Hi All,

We are using custom macro with some logic to calculate period-based safety stock. Recently we had noticed that the safety stock results are not consistent at different levels in the planning book. At a detailed level (product-location) the safety stock results are correct. But when we select few products together in a location and load the data in the planning book, the safety stock values are not correct at the 'Total' and 'Details (all)' level. From this level when i go to single product-location the safety stock values are correct.

I had already checked other treads similar to this issue and maintained settings as recommended i.e. selected 'All planning objects' in the settings for execution in the macro. However we still have this issue with the safety stock macro.

Please share your thought or suggestion to make it work. Thanks a lot for seeing this post.

Regards

PK

[werner_mhansen · Accepted solution]

Hello,

Could you please give more details about the Macro?
If possible screenshots about its settings and logic.

Also, what would be your expectation after the aggregation?

Thank you.
Werner Hansen