How Your Sales Team Benefits from a Dynamics 365 Sales Forecast (Part 2)
How Your Sales Team Benefits from a Dynamics 365 Sales Forecast (Part 2) Dynamics 365 for Sales offers a lot of nice features to facilitate managing your business opportunities. Over the years, SyncraTec has compiled a list of recommended customizations to the out of the box Opportunity Sales Process that add a lot of value to opportunity management. And now, Dynamics 365 for Sales has added sales forecasting to increase the probability of success for your sales team even more! It’s beneficial for a sales manager to have access to a list view of open opportunities that their team is nurturing. Dashboards and charts can improve the data visualization of these opportunities by such things as Estimated Revenue, Estimated Close Date and Probability. But, a sales forecast can help a sales team track their performance against their targets and identify risks to achieving their quotas. My previous blog highlighted how simple it is to set up and configure a sales forecast for your organization in Dynamics 365. This blog will demonstrate how sales team members and sales managers can use forecasts to achieve their sales goals. All of the functionality discussed in this blog comes FREE with Dynamics 365 for Sales, along with some additional Sales Insights functionality. Viewing and Adjusting a Forecast as a Sales Team Member A sales manager needs to have the Forecast Manager security role to configure forecasts for their organization. They can set up the type of forecast, permissions for accessing it, and the columns they want displayed on the forecast grid. After a forecast is activated, the sales team members can access the projected revenue and pipeline predictions accumulated from their opportunities. A sales team member will find forecasts in the Performance area of the navigation menu of the Sales Hub app. The drop-down list of forecasts at the top will display any forecast for which the sales team member has permissions to view. From the next drop-down list, they can choose the forecast period they want to see. These options reflect the forecast periods defined in the forecast configuration. The Forecast Grid The forecast grid displays all relevant columns as defined in the forecast configuration. The totals are aggregated by user or by territory, at each level of the hierarchy and for each period according to the forecast column attributes. The forecast illustrated in this blog was configured as an “org chart forecast”. It also uses the out-of-the-box Forecast Category option set from the Opportunity entity for column configuration (recommended by Microsoft). As a sales team member, the forecast grid summarizes opportunity values from a snapshot of the data. The upper right corner may indicate that “Fresh data is available”. Dynamics gives the user the option to update the grid with the real time values from their Opportunity records. It will include Opportunities where the user (sales team member) is the Owner and the Estimated Close Date falls within the forecast period. The default value for each column is the sum of the Estimated Revenue fields for all the Opportunities with the Forecast Category value indicated by the column name. Note: There are some changes around snapshot history in Dynamics Release 2020 Wave 2. Underlying Opportunity Records At the bottom of the forecast, you will see the underlying Opportunity records in the Opportunities Forecast View. This is the out-of-the-box default view, but it can be changed when the forecast is configured. From this Opportunities Forecast View, the sales team member can: Update the “Forecast category” column to: Pipeline – indicates with low confidence that this Opportunity will be closed as won during the forecast period (default value for new Opportunities) Best case – indicates with medium confidence that this Opportunity will be closed as won during the forecast period Committed – indicates with high confidence that this Opportunity will be closed as won during the forecast period Omitted – identifies an Opportunity that the user wants to be excluded from the estimated revenue forecast values Note: An out-of-the-box workflow automatically updates the Forecast Category to Lost or Won when an Opportunity is closed as lost or closed as won. Update additional Opportunity fields, such as Topic, Potential Customer, Est. Revenue, and Est. Close Date. Select “Show as Kanban” to display the underlying records in a Kanban type of view to easily drag Opportunity records from one Forecast Category to another. Select “Expand” to see more of their Opportunity records at one time. Navigate to the Opportunity record by clicking on the icon in the “Actions” column on the far left. The Opportunity form is opened in a new window to allow the update of any Opportunity record field while staying within the context of the forecast grid. Adjusting the Forecast The columns in the forecast grid can be configured different ways. It is up to the sales team manager to design the forecast grid to facilitate getting the most out of the forecast for their business. The forecast grid created for this blog provides the following functionality: Clicking on a Forecast Category column in the forecast grid will filter the view of underlying Opportunities accordingly. Column descriptions appear as tooltips on the column header to help the users understand what that value represents. Specific columns, like Committed in this forecast grid, have been configured to allow manual adjustments to the system-calculated values. Specific columns, like Pipeline in this forecast grid, have been configured to display a progress bar indicating the attainment percentage compared to the quota column. From the Underlying Records view, a user can modify the individual Opportunity Forecast Category directly in the view. When this occurs, the Estimated Value of the Opportunity will be subtracted out of the previous Forecast Category roll up value and added to the new Forecast Category roll up value. Adjustment Dialog Box There may circumstances where the sales team member estimates the amount that they expect an Opportunity to bring in at the close of a forecast period to be different from the roll up