Sales Forecasting: Dynamics 365 New Feature

crystal ball with text sales forecasting Dynamics 365 new feature and Hot and New burst

Note: Since this post was written Microsoft have updated this feature. We will be writing a new post to cover the updates soon.

Microsoft have introduced another new (preview) feature in Dynamics 365 Customer Engagement apps. Sales Forecasting helps companies to project revenue over time periods based on opportunities being created by the sales team. In this extended post we take a look at the new preview feature.


For a long time, Goals has existed as a poorly adopted feature in Dynamics 365. The primary reason for poor adoption is that it’s only possible to create one goal at a time. For example, to create 12 monthly goals for a sales team member I would need to arduously create 12 individual goals, then set a parent goal. It is not possible to create recurring goals unless you use some kind of workaround. The new sales forecasting functionality in Dynamics 365 allows us to create monthly goals/forecasts for a user or group without all the additional replicated effort.


Now to have a look at Sale Forecasting

Note: To use the new feature, you need to turn it on in the system settings preview tab and if you don’t have it on your navigation pane you may need to edit the sitemap in your Model driven app to add it.

Once the feature is turned on, click on App Settings, then click on Forecast Definitions to get started.

P2 sitemap

You will be presented with a form to create a Forecast Definition. In the two images below, I have created a quarterly definition and a monthly definition for all of our UK opportunities.

A tour of the fields on the form

General Section:

  • Forecast name (free text) sensible name for the forecast.
  • Forecast metric (lookup to Goal metric entity) You will want to select Revenue here.
  • Quota source (option set) You can select Goal-based or Manual. If you select Goal-based then the system will look for your existing Goals and base the Forecast on the goals that fall within the Rollup Query. Personally I don’t see the point of creating Goals as well as Forecasts, so I will set this to manual. (We will enter the actual quota amounts onto an editable grid in a later step).

Fields review continues after the next two images

P3 forecast definition screen set to quarterly forecasts

P4 forecast definition screen set to monthly forecasts

fields continued:

  • Rollup query (lookup to Rollup queries) This is the filter that sets which opportunities are included in the forecast. I created a rollup query to include all opportunities for UK based companies (see below). Only the rollup queries with opportunity as the parent entity are available and valid for selection for Forecasts.
  • Owner (lookup to user) The owner of the forecast definition.

P5 Roll up query for UK accounts

Then, click the View records button to preview the records.

P6 rollup query viewing records in filter

Scheduling Section

  • Forecast period (Option Set) Select whether you will set forecasts for a Monthly, Quarterly or Custom period. The default is Quarterly.
  • Fiscal year (Option Set) Select the fiscal year for the forecast. This is populated based on the org’s fiscal year settings. This is found in the system settings area.

P7 fiscal year settings in dynamics 365

  • Start month/Start quarter. (Option set) Select when to start forecasting. If you select the forecast period as Monthly, you can select the month from which you want to start forecasting. If you select the forecast period as Quarterly, then select the quarter from which forecasting should start.
  • Number of forecasts. Enter the number of forecasts that need to be generated. At time of writing this is limited to 12 occurrences.

P8 scheduling section on forecast definition

Custom Periods

  • Start date – If you selected Custom in Forecast period, select the start date.
  • End date – If you selected Custom in Forecast period, select the end date.
    Note: You can only create one forecast when the Forecast period is custom.

P9 scheduling section on forecast definition showing custom forecast periods

Categorising the Opportunities

In order for the sales forecasting feature to work, sales people will need to update their opportunities to reflect how confident they are of bringing each one home.
There is a new field on opportunities called Forecast Category.
The field is an option set with four values:

  • Pipeline (low confidence) – This is the default value and represents early stages of an opportunity.
  • Best Case (moderate confidence) – This represents a moderate chance of winning the opportunity.
  • Committed (high confidence) – This value is used when the sales person is positive and wants to definitively add the amount to their pipeline of committed revenue
  • Omitted (exclude from forecast) – This value will omit the opportunity from forecasting.

P10 forecast category field drop down on opportunity

Viewing the Forecasts

Navigate to Forecasts on the menu and select the forecast you want to view.

P11 site map showing forecasts

P12 Forecasts area showing forecast dropdown

Populating the Quota Amount

When you first open a forecast that has been set to use a Manual amount you will need to populate the Quota field in the inline editable grid.

P13 editing quota on inline grid

Below, I am looking at my teams monthly forecasts for the current fiscal year

P14 viewing my monthly forecasts

Now I have changed the view to look at the teams quarterly forecasts.

P15 viewing my quarterly forecasts

Use the Show Opportunities button to see a breakdown of the included opportunities.

P16 showing the included opportunities on a forecast line

Hierarchy Sales Forecasting

If you are using Sales team hierarchy, the forecasts also include opportunities of direct reports.
In the Example below, Iain is the manager of Keith and Sarah.

P17 sales team hierarchy view

Click on Recalculate and refresh hierarchy (this may take a little while)

P18 Recalculate button

The opportunities of my team are also included in my forecast.

P19 Forecast view showing opportunities of direct reports

For more on Hierarchy security see the link below

Summary of Sales Forecasting

When we heard that Microsoft were introducing sales forecasting we got a bit excited, thinking that they were going to allow users to split a larger total revenue into periodic draw downs. i.e. Think of an opportunity for a contract worth £120,000. When the opportunity is closed as won the whole £120,000 is considered closed and won (which, to some extent it is). However, the customer is going to pay the money in 12 monthly installments, as the work progresses over the next year. As a manager, I would like to be able to predict/forecast my monthly income but currently this is not possible with Dynamics 365 Customer Engagement. So for a years, partners have had to create custom entities and solutions to accommodate this requirement. Sadly, this new feature does nothing to address this particular problem so, for the time being at least, we will have to continue creating custom solutions for this.

However, Sales Forecasting looks to be a great tool and we like it a lot. At the time of writing it is still in preview and it is advised not to deploy it to a production environment just yet. The reason for caution is because features in preview will likely change and undoubtedly will have a few bugs such as the one in the images below where my opportunity for $500,000 is shown as £500,000 in the forecast.

Rocket CRM Verdict: Sales Forecasting is a great tool, enable now for sandbox. Wait for General Release to use in production.

P20 dollar opportunity

P21 error shows gbp for the dollar opportunity


Rocket CRM are a Dynamics 365 Customer Engagement consultancy, based in London, England. We work with SMB clients both, large and small. Get in touch to tell us about your requirement and we will be more than happy to have a no obligation chat to see if it’s something we can help with. Contact Us.

Learn more about how to track sales performance in Dynamics 365.



Rocket CRM is a Microsoft Dynamics 365, and a platinum ClickDimensions accredited partner, helping small to medium-sized businesses and charities harness the power of scalable CRM technology. Our mission is to make powerful CRM software simple with custom-built, user-focused solutions.


Podcast: RocketPod

Social: LinkedIn

share with your friends