On demand · Webinar recording
Addressing planning and forecasting challenges in Business Central
Inaccurate demand forecasts and complex purchase planning workflows can disrupt inventory management and purchasing accuracy. This topic is particularly relevant for Business Central users and Microsoft Partners responsible for inventory forecasting and procurement planning.

Summary
Demand forecasting and purchase planning in Microsoft Dynamics 365 Business Central can be extended to improve inventory accuracy and vendor-driven purchasing workflows. Understanding these challenges and how to interpret forecasting data, adjust planning parameters, and apply vendor-centric strategies can lead to more precise inventory control and improved purchasing decisions.
Key topics
- Demand forecasting in Business Central and how to extend it
- Common data issues in inventory forecasting
- Impact of forecast adjustments on planning parameters
- Vendor-based planning and threshold managementInterpreting supply and demand data in planning worksheets
- Evaluating planning scenarios with Business Central workflows
Attendee questions, answered
18 questions asked during this webinar, each answered in its own article.
- Why are some items missing from planning suggestions in Microsoft Dynamics 365 Business Central?
- How can Microsoft Dynamics 365 Business Central calculate safety stock and reorder points automatically?
- How can safety stock adjust dynamically in Microsoft Dynamics 365 Business Central planning?
- Why do planning suggestions sometimes ignore safety stock in Microsoft Dynamics 365 Business Central?
- Can I filter forecast data and set custom start dates in Microsoft Dynamics 365 Business Central planning?
- How can we import and use customer forecasts in Microsoft Dynamics 365 Business Central planning?
- How can I generate component demand from usage in Microsoft Dynamics 365 Business Central planning?
- What data does Item Planning Review analyze in Microsoft Dynamics 365 Business Central?
Show all 18 questions
- How does Microsoft Dynamics 365 Business Central handle netting of inventory, purchase orders, and demand?
- How does Microsoft Dynamics 365 Business Central manage new demand with existing supply?
- How should I choose Between Min Max and Lot for lot planning for long lead items in Microsoft Dynamics 365 Business Central?
- How can I reduce planning noise in Microsoft Dynamics 365 Business Central?
- How do overflow settings affect planning in Microsoft Dynamics 365 Business Central?
- How can I manage SKU-level planning parameters in Microsoft Dynamics 365 Business Central?
- Will planning generate supply suggestions separately for each item variant in Microsoft Dynamics 365 Business Central?
- How does Microsoft Dynamics 365 Business Central handle planning and execution with different units of measure?
- How can planning be managed for perishable goods in Microsoft Dynamics 365 Business Central?
- What training options support planning improvement in Microsoft Dynamics 365 Business Central?
Read the transcript
Introduction to Forecasting and Planning
Hey, good afternoon or morning everyone. This is Mark here. Today we’re going to go through forecasting and planning inside Business Central using some of the tools that Insight Works has to offer.
We’ll start with a brief overview of who we are and the solutions we provide, then jump into how you can use Business Central to do planning and forecasting more effectively. This session will run about 45 minutes depending on questions, so feel free to enter questions as we go.
Overview of Insight Works Solutions
We primarily work in manufacturing and distribution, and everything we cover today applies to both warehousing and manufacturing. Planning includes purchasing for warehouses or component parts for manufacturing facilities.
We offer a full suite of applications, many of which are free. These include tools for production scheduling, document management, shipping, and warehouse management. Most of our solutions are delivered through reseller partners, so they are your first point of contact for pricing or implementation support.
Enhanced Planning Pack Overview
The Enhanced Planning Pack is the focus of today’s session. It includes the Enhanced Planning Worksheet and Enhanced Forecasting Worksheet, both of which are free for SaaS users. These tools improve usability and efficiency compared to standard Business Central planning features.
The goal is to eliminate the need for external tools like Excel and allow you to manage purchasing and planning directly within Business Central.
Enhanced Forecasting Worksheet
Forecasting is the first step in planning. The Enhanced Forecasting Worksheet uses Microsoft’s Azure Machine Learning forecasting model and makes it more usable by allowing you to forecast multiple items at once.
You can filter by item, location, and other criteria, then define parameters such as forecast period and historical data range. The system calculates expected demand based on past sales history.
Forecast Output and Usage
Once calculated, the forecast shows expected demand for upcoming periods. You can then update the demand forecast in Business Central, which feeds directly into planning processes like MRP and MPS.
Alternatively, instead of updating demand forecasts, you can use the results to automatically update planning parameters such as minimum stock levels, reorder points, and maximum inventory.
Importance of Historical Data
Forecasting relies on historical sales data. If that data is missing, tools like the Import-Export Power Tool can be used to bring in historical transactions without affecting system integrity.
Managing Components with Item Planning Review
Forecasting is typically done at the finished goods level. For components, the Item Planning Review tool is used instead. It calculates average usage rather than forecasting and allows you to define formulas to determine reorder points and inventory levels.
This tool provides flexibility by allowing you to define which transactions count as usage and apply custom formulas to calculate planning parameters.
Enhanced Planning Worksheet
The Enhanced Planning Worksheet improves on the standard planning worksheet by simplifying purchasing and reducing noise. One key feature is the Calculate Purchase Plan function, which focuses on new demand and eliminates unnecessary action messages.
This makes it especially useful for distribution environments where speed and clarity are critical.
Performance and Efficiency
The purchase plan is significantly faster than standard MRP. For example, planning 50,000 SKUs can take less than two minutes. It can also run automatically in a job queue to continuously accumulate purchasing requirements.
Improved Visibility
The worksheet provides enhanced fact boxes showing supply, demand, and projected inventory. It also includes vendor planning summaries, allowing you to track purchasing totals and determine when to release purchase orders based on thresholds like prepaid freight.
Visual Verification
A built-in chart allows you to visually verify planning suggestions. This helps identify issues such as over-ordering and quickly adjust planning parameters without navigating through multiple screens.
Planning Parameters in Business Central
Effective planning depends on correctly configured planning parameters. These include reordering policies, safety stock, reorder points, and order quantities.
Reordering Policies
- Fixed Reorder: Orders a fixed quantity when inventory drops below a threshold.
- Maximum Quantity: Replenishes inventory up to a defined maximum level.
- Lot-for-Lot: Orders exactly what is needed based on demand.
- Order: Creates supply only when demand exists.
Each policy impacts inventory levels differently. For example, maximum quantity increases inventory levels, while lot-for-lot minimizes them.
Reducing Planning Noise
Parameters like rescheduling period, dampener period, and overflow level help reduce unnecessary planning messages. These settings control how sensitive the system is to changes in demand or supply.
Planning Flexibility
Planning flexibility can be set on purchase or production orders to prevent the system from suggesting changes. This is useful when orders are fixed and should not be modified by the planning engine.
Key Takeaways
The Enhanced Planning Pack significantly improves planning efficiency in Business Central. Forecasting helps determine demand, while the planning worksheet simplifies supply generation and reduces noise.
Proper configuration of planning parameters is critical to getting accurate and actionable results. Small enhancements like better visibility, faster processing, and easier parameter adjustments can save hours of work each week.
Closing Remarks
If you’re using the cloud version of Business Central, you can install the Enhanced Planning Pack and start using it right away. Explore the tools, test them in your environment, and reach out to your partner or Insight Works if you have questions.
Thanks everyone for joining. Hope you have a great rest of your week.
Questions about this webcast?
Send your question and the Insight Works team will reply by email. Ready to plan a project? Contact your Microsoft Partner.
Ask a question
Apps in this recording
Enhanced Forecasting WorksheetTurn the Azure AI sales forecast into demand forecasts and item planning parameters
Enhanced Planning PackA bundle of six planning, forecasting, and production analysis apps for Business Central, licensed together per company
Enhanced Planning WorksheetPlan purchases by stockkeeping unit with supply, demand, history, and vendor thresholds on one screen
More recordings
Webinar recording · 60 min8 free Business Central apps for warehouse, shipping, production, and safetyBarcode Generator PowerTool · DocXtender · Enhanced Planning Pack · Graphical Scheduler · Order Ship Express · PrintNode Connector PowerTool · Safety Logbook · WMS ExpressRecorded October 2026
Webinar recording · 46 minExtending Business Central for everyday operations without added complexityEnhanced Planning Worksheet · WMS ExpressRecorded February 2026
Webinar recording · 52 minMaximize your Business Central experience with free appsDynamic Ship · Enhanced Forecasting Worksheet · Enhanced Planning Worksheet · Graphical Scheduler · Warehouse Insight · WMS ExpressRecorded February 2026