Use Routines and Groovy Scripts to Set Forecast Category Values
You can use routines or Groovy scripts to set the Best Case and Committed forecast categories. For example, your sales administrators can allow salespeople update the forecast category based on win probability, sales stage, or any criteria on the Opportunity details page or on the Edit Products (revenue lines) page. They can also use Groovy scripts on an ongoing basis to set the opportunity forecast category to Best Case or Committed.
Routines
- Routine 1: Update forecast category to BEST CASE for opportunities with a Win Probability >= 40% and <60%
- Routine 2: Update forecast category to COMMITED for opportunities with a Win Probability >= 60% and <100%
You can also use a single routine to call a smart action or object function to run if/then/else logic similar to Groovy script logic.
Groovy Scripts
- Win Probability >= 40 and <60 set forecast category to BESTCASE
- Win Probability >= 60 and <100 set forecast category to COMMIT
By default, new opportunities are created with a forecast category = PIPELINE, and when an opportunity is closed as Won the forecast category = WON, or if the opportunity is closed as Lost, the forecast category = OMIT