on 12-21-2015 8:36 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
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.