on 05-13-2016 4:01 AM
Hello Guru's,
Can any one help me with the logic of a macro to identify all the CVC's which do not have any forecast or sales order in the last 4 months and generate an alert.
Regards,
Nick
Hi,
You can calculated the sum of last 4 moth forecast and sales order. If the sum id zero then generate the alert. You have to create a alert type to generate the alert.You can run the macro in background.
Regards
Kishor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nick
You should select the respective KF representing the Sales history and FCST and check if if the values for last 4 i.e. 4 monthly buckets iteration is > 0. If yes then generated the resective alert. You can execute the macro in background job for all the given CVCs.
Please let me know if this information helps you.
Thanks
Amol
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.