How to Configure Forecasting in Dynamics 365 Customer Engagement

by | Updated November 3, 2020 | Dynamics CRM

How to configure forecasting in dynamics 365 customer engagement

Forecast Setup in Dynamics 365 Sales & Customer Engagement

Are you using the forecast feature in Dynamics 365 Sales or Dynamics 365 Customer Engagement? If you are there are some enhancements that came out in the Dynamics 365 Wave 1 2020 Release that make forecasting even better. If you are not using forecasting but want to, this blog will help you set it up.

When you set up and use forecasting in D365 Sales you give your users a way to track their performance against targets and help them identify issues that may hinder their ability to reach their targets. Management can also benefit from this tool by using it to provide coaching, anticipate sales, or change product strategy. With the new features in forecasting, projecting your revenue has never been easier. Let’s configure forecasting and look at some of the new features along the way.

Note: You must be a system administrator or have the Forecast Manager role to configure forecasts.

In the left-side navigation bar, navigate to App Settings then scroll down to Performance Management and select Forecast Configurations, here you will find the forecast configuration home screen (shown below).

  1. You can choose to configure your forecast with the Org chart template or with the Territory template by clicking on the one you want to use:
    • The Org chart template is based on your reporting structure, it uses the Manager field on the User entity for the hierarchy
    • Territory forecasts are based on your sales territory hierarchy

The Territory forecast option was added before the Wave 1 release so technically not a new feature and there may be a product-based forecast added soon so keep checking for that if interested.

  1. Below the Recommended Templates you will find a list of all your current forecasts:
    • You can view them by Active, Draft and Inactive
    • The More Options icon at the end of the forecast name gives you options to Edit, Deactivate or Delete the forecast

Fast-Track your Forecast

General Properties

In this example, we have chosen the Org Chart Forecast template. The Forecast Configuration screen opens up as shown below.

  1. Give the Forecast a Name, being as descriptive as possible
  2. Select a Default underlying records view, this is the view that will show the opportunities that make up the forecast
  3. Lookup the user that will be the top of the hierarchy
  4. In the scheduling section specify the Forecast period, Fiscal year, Start this forecast and Number of periods – the valid from and to will auto-populate
  5. Select Next to move to the Permissions configuration

Low Forecast

New Feature – Permissions

  1. The User lookup field is defaulted based on which template you chose at the very beginning of the setup:
    • for the Org chart forecast, the value will be USER
    • for the Territory forecast, the value will be MANAGER
  2. Under the Additional security roles section select the option that fits your needs:
    • No additional security roles – only the selected hierarchy users see the forecast
    • All security roles – all security roles in your organization see forecasts
    • Specific security roles – allows you to choose the security roles that see the forecasts
  3. After you make your selection a message appears to help you understand your selection
  4. Select Next to move to the Layout and Column Configuration


Layout and Columns

This section is where we define the option set fields from the opportunity that can be configured for the forecast grid layout that your users will see.

  1. In the Layout and Columns section, click the + Add from option set
  2. Chose an option set, (we recommend that you use the out-of-the-box Forecast category option set to begin with) and click Choose selected
  3. You will now see a preview of the columns and a window will open asking if you want to Auto-Configure the columns, click Auto-Configure
  4. You can add or remove columns by unchecking them or dragging and dropping them on the grid
  5. NEW FEATURE – You can also configure each column individually by clicking on the More Options icon and selecting Configure, in the configure option you can modify the column in several ways, the new feature here is that you can now configure a columns Type to be Roll-up or Calculated and we also now have the ability to manually adjust columns to fit your needs
  6. NEW FEATURE – Click on the + Add Filters button to filter out certain opportunities that are included in the forecast calculations
  7. Click Next to move on to the Activate and add quotas configuration

NOTE: The Prediction column is only available when predictive forecasting is enabled.

Layout and Columns


Activate and Add Quotas

  1. Click on the Activate forecast button, this may take a few minutes. You will see the Forecast successfully activated message when it is done calculating
  2. In the Upload quota and other static data for this forecast section, you should see an option to Download simple data column template click on this to download a template (Excel Workbook) that shows the forecast time frame columns and the users in your hierarchy
  3. Open the quota template (Excel workbook), notice there are two tabs on the excel sheet one for Quota (Parent) and one for Quota (Direct), enter the quota data accordingly:
    • Column (Direct) tab: shows all the sales reps or territories in your forecasting hierarchy
    • Column (Parent) tab: shows anyone who has direct reports in the selected hierarchy

NOTE:  Do NOT change the Record ID values in the workbook or your forecast will display inaccurate values.

  1. Save and Close your workbook
  2. In the Upload quota and other static data for this forecast section, choose the Click to upload or drag and drop your template here
  3. Once the workbook is uploaded you should see a status message at the bottom, select FINISH and your forecast is ready to be viewed in the Sales area under the Performance section!

Add Quotas

We hope you enjoy the forecasting feature in D365 CE and the recent enhancements that became available with the 2020 Release wave 1 update and look for future blogs on using the forecasting feature. Please reach out to our Stoneridge Software Team for any questions you may have on setting up or using this feature in your organization!

Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV


06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

13oct12:00 pm12:30 pmWave 2 Release – What’s Coming for Dynamics 365 Sales and Customer Service

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!