We have dozens of active Opportunities. To forecast future revenue we show in a report only those Op's that are above 50% probability. Often, the total total future revenue in this report changes significantly. This is because an Op Probability was adjusted down (e.g. 70% to 30%) or the Op value is adjusted down. When this occurs our Sales VP's want to know why. I do not want them to scroll through dozens of Op's looking for which ones had a significant change.
My thought is that a BPM could be used as an alert when a significant downward change occurs. For example, if Probability changes from >50% to <50% OR Amount changes by more than 30% send an email to Op Owners manager. However, this seems difficult to implement. I'm looking for someone who may have developed a solution or something similar.
