DP Macro

[former_member309586]

Hi Gurus,

We have DP & PPDS in scope. We wanted to have a macro which calculates the "Target inventory level" based on my forecast using the below formula

Months                           M0            M1          M2          M3     M4            M5             M6

Total Forecast                               100          100          100     100          50               100

Target stock in Months                    3               4              2        3

Taraget inventory qty=                     300

                              M1   =     (Total Forecast ( M1+M2+M3))

                              M2   =     (Total Forecast ( M2+M3+M4 +M5)             

Please it will be really helpful if i can have logic to write a macro

Thanks in advance

Thanks & Regards,

Rajesh Kumar

[ruchi_das2 · Accepted solution]

Hi Rajesh,

The macro you are looking for can be achieved by using the Macro function SAFETY_CALC() which is used in SNP Data views for safety stock calculation. You can replace the Total Demand Key Figure to Total Forecast and Safety Days to Target Stock in Months. You can always look at examples in Macro Workbench and come up with your own. The only problem i see would be maintaining the Product and Location in the macro when using a DP data view.

Regards

AK

[former_member309586 · Accepted solution]

Thanks Abhishek