Forecast Category for Customizeable Forecast:
Each value of Opportunity Stage is mapped to Type, Probability and Forecast Category. Changing the Stage of in Opportunity page layout will automatically change Probability and Forecast Category, but user can manually overwrite the default value of Probability and Forecast Category.
We can customize Forecast Category value from Forecast Category field in Opportunity object.
From above screenshot, Forecast Category value has been modified from Best Case to Best Case OK, but the Status Category will remain as Best Case.There are 5 Forecast Category values and we cannot add/delete it, although you can skip to use in from Stage assignment:
- Commit
- Closed
- Omitted
Forecasts tab
When you click Forecasts tab, you will find the 5 Forecast Category:
- Quota
- Closed
- Commit
- Best Case
- Pipeline
The Forecast Category on the Opportunity record do NOT maps directly on a one-to-one basis to the one on Forecast tab. Amount in Closed, Commit, Best Case, Pipeline is NOT total from the same Forecast Category in Opportunity Forecast Category. Click the Forecasts tab and notice that your forecast amounts are listed in different categories.
Forecasting Category value calculation:
Closed includes amounts for closed/won opportunities.
Status Category = Closed
Commit includes amounts you are confident about closing and closed/won opportunity amounts.
Status Category = Closed + Commit
Best Case includes amounts you are likely to close, closed/won opportunity amounts, and amounts in the Commit category.
Status Category = Closed + Commit + Best Case
Pipeline includes amounts from all open opportunities.
Status Category = Commit + Best Case + Pipeline
Sample of source data from Opportunity and relation with Forecast Category (bottom image):
Salesforce Customizeable Forecast Report:
we discussed about Forecast Category, and now we would like to continue on how to create forecast report in this blog.
You can create forecast vs quota report the same as you usually create Salesforce report, just select report type 'Customizable Forecasting: Forecast Summary' or 'Customizable Forecasting: Forecast History'.
You will find the same forecast category as in Forecast tab:Quota (Rev), Closed (Rev), Commit (Rev), Best Case (Rev), Pipeline (Rev). With additional infoClosed % of Quota (Rev) and Closed + Pipeline (Rev) which is actually total Amount of all Opportunity.
Do you realize the amount is exactly the same with amount in Forecast tab?
Issue: a Sales Director come to me and asked, why I can only see forecast for managers in my direct report, not for users underneath those managers?
After do some finding, issue found in Forecast Hierarchy. Go to Setup - Customize - Forecasts (Customizable) - Forecasts Hierarchy, make sure each role in Forecast Hierarchy have user enable, so user in higher role hierarchy can see forecast of user below.
Each value of Opportunity Stage is mapped to Type, Probability and Forecast Category. Changing the Stage of in Opportunity page layout will automatically change Probability and Forecast Category, but user can manually overwrite the default value of Probability and Forecast Category.
We can customize Forecast Category value from Forecast Category field in Opportunity object.
From above screenshot, Forecast Category value has been modified from Best Case to Best Case OK, but the Status Category will remain as Best Case.There are 5 Forecast Category values and we cannot add/delete it, although you can skip to use in from Stage assignment:
- Pipeline
- Best Case- Commit
- Closed
- Omitted
Forecasts tab
When you click Forecasts tab, you will find the 5 Forecast Category:
- Quota
- Closed
- Commit
- Best Case
- Pipeline
The Forecast Category on the Opportunity record do NOT maps directly on a one-to-one basis to the one on Forecast tab. Amount in Closed, Commit, Best Case, Pipeline is NOT total from the same Forecast Category in Opportunity Forecast Category. Click the Forecasts tab and notice that your forecast amounts are listed in different categories.
Forecasting Category value calculation:
Closed includes amounts for closed/won opportunities.
Status Category = Closed
Commit includes amounts you are confident about closing and closed/won opportunity amounts.
Status Category = Closed + Commit
Best Case includes amounts you are likely to close, closed/won opportunity amounts, and amounts in the Commit category.
Status Category = Closed + Commit + Best Case
Pipeline includes amounts from all open opportunities.
Status Category = Commit + Best Case + Pipeline
Sample of source data from Opportunity and relation with Forecast Category (bottom image):
Salesforce Customizeable Forecast Report:
we discussed about Forecast Category, and now we would like to continue on how to create forecast report in this blog.
You can create forecast vs quota report the same as you usually create Salesforce report, just select report type 'Customizable Forecasting: Forecast Summary' or 'Customizable Forecasting: Forecast History'.
You will find the same forecast category as in Forecast tab:Quota (Rev), Closed (Rev), Commit (Rev), Best Case (Rev), Pipeline (Rev). With additional infoClosed % of Quota (Rev) and Closed + Pipeline (Rev) which is actually total Amount of all Opportunity.
Do you realize the amount is exactly the same with amount in Forecast tab?
Issue: a Sales Director come to me and asked, why I can only see forecast for managers in my direct report, not for users underneath those managers?
After do some finding, issue found in Forecast Hierarchy. Go to Setup - Customize - Forecasts (Customizable) - Forecasts Hierarchy, make sure each role in Forecast Hierarchy have user enable, so user in higher role hierarchy can see forecast of user below.
No comments:
Post a Comment