Macro to Identify Obsolete CVC

[former_member906762]

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

[Former Member]

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

[Former Member]

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