Building Smart Supply Chains: Forecasting, Routing, and Costing in Dynamics 365 SCM

🛡️ Welcome to the AxmedJay Journey

In supply chain management, planning isn't just about forecasting — it's about executing smart strategies to meet customer demand at the right time, at the right cost.

Microsoft Dynamics 365 Supply Chain Management offers powerful tools like Master Planning, Routing, Costing Sheets, and Item Cost Calculations to manage production, forecast demands, and maintain profitability.

In this guide, we’ll walk step-by-step through how to set up Master Planning, manage product routes, configure costing models, and ensure accurate item costs — because great operations start with great planning.

Scenario: Why Master Planning and Accurate Costing Are Critical

Imagine a manufacturing company producing customized machinery parts:

• The sales team forecasts a spike in orders next quarter.
• The production team needs to plan for enough materials, workers, and time.
• The finance team must ensure the production cost doesn’t overrun budgets.

Without proper Master Planning and accurate cost modeling:

• Production may stall due to missing components.
• Item prices may not reflect true costs, hurting profit margins.
• Delivery delays could cost future business.

🔍 Key Point:
Master Planning and Costing in D365 SCM align demand, supply, production, and financial targets — creating a smarter, leaner, and more responsive operation.

Process Walkthrough

Master planning:

Master planning uses information from many different areas of the system to determine how much of each item you must purchase and by what date you must purchase the inventory (based on lead times in Dynamics 365 for Supply Chain Management) to fulfill the item requirements on time.

Master Planning Setup

Master Planning -> Setup -> Master Planning parameters.

Under the master planning parameters need to be set the Current forecast plan, Current static master plan, Current dynamics master plan, general coverage group, and other parameters as shown below.

Configure Master Plans

Master Planning -> Setup -> Plan -> Master Plans.

Create new Master Plan add name and description. Under the General fastTab link Forecast model and enable the Include Demand Forecast checkbox

Demand Forecasting Lines:

Master Planning -> Forecasting -> Manual Forecast Entry -> Demand Forecast Lines.

Under the demand forecast lines need to add forecast model, Item, Site & Warehouse, Sales quantity, and Sales Price.

Route Management:

Product Routes

Product Information Management -> Products -> Released Products -> Engineer -> Route to create a new route. 

In the Route details form, on the General FastTab, in the Route number field, specify an alphanumeric identifier for the route. You can also use the number that is automatically generated. In the Name field, enter a descriptive name for the route. In the Item group field, select the item group for the item. To approve the route, on the Action Pane, click Approve. In the Approved by field, select the worker who approved the route.

Route Setting

Route Overview

Need to add Operation no. Priority, Operation, Process quantity, Route group and Route code.

Setup

Under the Setup Tab need to add Formula, Scrap percentage, Factor, Costing Resource and Cost Categories

Cost Categories:

Production Control -> Setup -> Routes -> Cost Categories.

Create Cost Categories add Category ID, Name, Category, Cost Price and Cost Group

Costing Sheets:

Cost Management -> Indirect cost accounting policies setup -> Costing Sheets Click New add Costing Sheet setup, Identification (Node type, Code Description and Setup type)

Cost Management -> Indirect cost accounting policies setup -> Costing Sheets -> Overheads Setup

Under Overheads setup configure General tab, Absorption Basis, Rate, Ledger Posting and Financial dimensions.

 Calculate Item Cost:

For Calculate item cost need to go Product Information Management -> Products -> Released Products -> Select Item -> Click on Item Price Set up under Manage Cost then Click on Pending Prices and then click on Calculate Item Cost.

Here we can see the Costing type, Price type, Version, Price, Price quantity and Charge quantity.

View Calculation Details

Under the view calculations details we can see the overview of Calculation, General Setup, Prices, and Costing Sheet (Variable, fixed and Total cost).

Key Takeaways:

• Master Planning ensures inventory is available at the right time based on real demand forecasts.
• Routes define the manufacturing steps, operations, and processes for items.
• Cost Categories and Costing Sheets organize production costs into manageable parts.
• Item Cost Calculation ties everything together — providing true cost visibility and profitability tracking.
• A solid setup improves not only production planning but also pricing strategies and financial health.

🛡️ Thanks for Walking the Path with AxmedJay

Behind every successful supply chain is smart planning and precise cost control.

By mastering these foundational setups in D365, you build systems that not only meet demand — they drive long-term profitability and operational excellence.

Stay tuned for more real-world insights from the frontline of digital supply chain transformation. Until next time — stay sharp, stay curious, and plan smarter.