Demand Forecasting Functionality in Dynamics 365 for the Modern Manufacturer

by | Updated October 4, 2021 | Dynamics 365 for Finance and Operations, Manufacturing

Demand forecasting in Dynamics 365 Finance and Supply Chain is used to predict customer demand from sales orders using historical transaction data. This integrated functionality allows output to be modified, updated, and authorized for use in the master plan. In addition to order planning and inventory management capabilities, enhanced demand forecast reduction rules provide an ideal solution that can be adapted to meet a variety of business requirements.

Forecast Model in D365 Finance & Supply Chain

The first step in creating a demand forecast in Dynamics 365 Finance and Supply Chain is assembling a forecast model, which identifies where forecasts are stored. Forecasts should be separated if you have multiple forecasts corresponding to different master plans. Functionality exists to modify your data in Excel before importing it as a forecast model.

forecast model in Dynamics 365 Finance and Supply Chain

Item Allocation Keys in D365 Finance & Supply Chain

The next step involves configuring item allocation keys in Dynamics 365 Finance and Supply Chain, which instruct how items in a demand forecast should be treated. For example, fast-moving, high-volume items should be put in an allocation key with similar items, so the forecast has a consistent output. Item allocations are the basis for demand forecasting as a product must be applied to an item allocation key for the forecasting process to work. Each item must only exist in one allocation key. Additionally, item allocation keys are useful for cross-company forecasting with intercompany planning groups.

item allocation keys in D365 Finance and Supply Chain

Demand Forecasting Parameters in D365 Finance & Supply Chain

Next, determine your demand forecasting parameters and. As shown in the image below, eight transaction types can be included in your demand forecasting parameters. “Sales order” and “Production line” are typically selected when determining future forecasts. A unit is required as demand forecasts are generated based on item quantities.

demand forecasting parameters in D365 Finance and Supply Chain

Within demand forecasting parameters, forecast dimensions are used to segment information. “Item number and dimensions” is the default assigned forecast dimension, though “Warehouse” is often added. Selecting “Warehouse” means you are segregating your forecast by individual warehouses in a multi-warehouse setup.

selecting forecast dimensions

Set up options to treat item allocation keys with different algorithm parameters. If you decide to leave this empty, the parameters set in Demand Forecasting Parameters will be applied to your item allocation keys.

set up options for item allocation keys in D365 Finance and Supply Chain

Algorithm Options in D365 Finance & Supply Chain

Algorithm options in Dynamics 365 Finance and Supply Chain may sound intimidating, but they are fairly user-friendly. This feature allows you to tweak algorithm parameters, generate a statistical baseline forecast, then tweak your parameters again and note differences.


Reduction Keys in D365 Finance & Supply Chain

The Reduction Keys feature in Dynamics 365 Finance and Supply Chain allows you to reduce your demand forecast and planned orders for later periods by a percentage over time, or by actual transactions of the item as orders are received.


Demand Forecasting Process in D365 Finance & Supply Chain

Once you are set up and ready to begin the demand forecasting process in Dynamics 365 Finance and Supply Chain, the first step is to generate the statistical baseline forecast. Microsoft Azure will help you produce a demand forecast based on historical transactions containing demand trends, confidence intervals, and forecast adjustment history. Remove any outliers before authorizing the forecast to be used in master planning.

Generate Statistical Baseline Forecast in D365 Finance & Supply Chain

To generate the statistical baseline forecast in Dynamics 365, specify your historical horizon date range, item allocation key, and future forecast period. Under forecast period, bucket size is how frequently you would like to generate a planned order and forecast horizon describes how far out you would like to generate orders.

generate statistical baseline forecast

Put Demand Forecast to Use

Once your statistical baseline forecast has been generated in Dynamics 365, you will be able to view your demand forecast and include it in your master plan. Your master plan will then plan orders based off the forecast you calculated, generated, analyzed, and authorized.


Learn more about Dynamics 365 functionality for manufacturers by reaching out to our experts.

Related Posts


Submit a Comment

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

Upcoming Events


13jan11:00 am12:00 pmConfab with Stoneridge Livestream - Technology in 2021 Recap

18jan12:00 pm1:00 pmOpportunities and Threats for the Commodity Processor in 2022

19jan10:00 am11:00 amTax Compliance and Coffee – a Virtual Discussion

26jan11:00 am12:00 pm7 Ways Manufacturers Can Stop Cyber Attacks

26jan2:00 pm2:45 pmKeep Your Data Secure and Move to the Cloud with GP

27jan11:00 am12:00 pmConfab with Stoneridge Livestream - The Year of Integrations


10feb11:00 am12:00 pmConfab with Stoneridge Livestream - Microsoft Teams and Microsoft Dynamics Integration

23feb10:00 am10:30 amDeciphering Manufacturing KPIs – What Your Data is Really Telling You

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!