Using Routes in Dynamics 365 Finance & Operations for Accurate Costing
One of the most common conversations I have with manufacturers starts with a costing problem.
They know what their raw materials cost, but understanding the true cost of production is much more challenging. Labor, machine time, setup activities, quality inspections, and overhead all influence profitability, yet those costs are often difficult to track accurately.
When estimated costs don’t match actual production results, manufacturers are left asking the same questions: Where are variances coming from? Which operations are driving costs? And can they trust the numbers they’re using to make decisions?
In this article, I’ll walk through how routes support accurate costing, how to build a routing structure that reflects real production processes, common costing mistakes to avoid, and how routes, cost categories, and costing sheets work together in Dynamics 365 Finance & Operations.
Table of Contents
- What Is a Route in D365 F&O?
- Route Structures
- How to Build a Route
- Cost Categories
- Costing Sheet
- Common Production Costing Problems
If you’d like a deeper walkthrough of these concepts, including live demonstrations of route setup, route versions, cost categories, costing sheets, and production costing calculations, you can also watch my recorded webinar:
Note: Even though most customers, commentators, and consultants still call it Dynamics 365 Finance & Operations or D365 F&O, Microsoft now technically licenses it as Dynamics 365 Finance and Supply Chain Management.
What Is a Route in D365 F&O?
When I explain routes to clients, I usually describe them as a digital representation of what actually happens on the shop floor.
At a high level, a route defines the sequence of operations required to manufacture a product. It identifies the steps involved, the resources that perform them, and the time required to complete them.
What makes routes valuable from a costing perspective is the fact that every operation creates an opportunity to capture production costs.
That could include:
- Labor time
- Machine utilization
- Setup activities
- Quality inspections
- Resource consumption
- Indirect manufacturing activities
A route shouldn’t simply describe how production flows. It should help the system understand where costs are occurring and how they contribute to the finished product.
The goal isn’t to create a route that looks impressive on paper. The goal is to create a route that closely reflects reality to support accurate costing and meaningful analysis.
Route Versions
A route defines how a product is manufactured, but a route version determines when and where that route should be used.
This distinction becomes important because most manufacturers do not operate with a single production process forever. Equipment changes, production methods evolve, new facilities come online, and products are redesigned.
Rather than continuously modifying a route, D365 F&O allows multiple route versions to exist for the same released product.
When a production order is created, D365 F&O typically selects the active route version associated with the released product. This allows manufacturers to maintain historical production processes while introducing new processes over time.
Choosing the Right Route Structure
Not every manufacturing process requires the same routing structure. One of the advantages of D365 Finance & Operations is the flexibility to model different production environments without forcing every organization into the same approach.
Some environments are straightforward and linear. Others involve multiple parallel activities, branching production flows, and complex dependencies.
Understanding the differences can help determine the appropriate level of detail for your environment.
For most organizations implementing routes for the first time, I recommend starting with the simplest structure that accurately reflects reality. Complexity should be added only when it provides meaningful scheduling or costing value.
The following example illustrates how simple, complex, and parallel routes can be structtured within a manufcaturing environment:
How to Build a Route That Supports Accurate Costing
When helping manufacturers improve production costing, I generally follow the same process.
Step 1: Map the Real Production Process
Before opening D365 F&O, spend time understanding what actually happens on the shop floor.
Ask questions such as:
- What activities are involved in production?
- Which resources perform those activities?
- Where do bottlenecks occur?
- What quality checks are performed?
- Where are materials consumed?
The objective is to document reality before attempting to model it.
Step 2: Create Route Operations
Once the process is documented, create route operations that reflect those major production activities.
Avoid the temptation to capture every tiny task and instead focus on activities that meaningfully affect scheduling, costing, or reporting.
Step 3: Assign Resources
Next, identify who or what performs each operation.
Resources may include:
- Workers
- Machines
- Tools
- Work centers
- Resource groups
Resource groups can be particularly useful when multiple machines are interchangeable and the organization does not care which specific machine completes the work.
Step 4: Establish Time Standards
This is where costing accuracy often rises or falls.
Define:
- Setup time
- Runtime
- Queue time
- Transit time
For example, transit time may represent how long it takes an operator to retrieve materials before work can begin. These values directly influence labor and machine costing calculations.
When manufacturers tell me their production costs seem wrong, this is often one of the first areas I review.
Step 5: Assign Cost Categories
Each operation should be connected to a cost category that reflects the type of work being performed.
A setup activity may require one cost category. Machine runtime may require another. Quality inspections may require a third. This creates the connection between production activity and financial costing. Without this connection, production costs cannot be rolled up accurately.
Step 6: Validate Against Production Results
After production orders begin flowing through the route, compare estimated costs against actual results.
If actual runtimes consistently exceed routing assumptions, update the route. If labor costs are being allocated incorrectly, review resource assignments and cost categories.
The objective is not to build a perfect route on day one. It is to create a route that becomes increasingly accurate over time.
How to Set Up Cost Categories
Once route operations have been defined, the next step is to configure cost categories.
Cost categories drive the accumulation of labor, machine, setup, and overhead costs throughout the production process. They also support reporting, analysis, and cost rollups.
In my experience, cost categories are often one of the most overlooked components of a manufacturing implementation. Organizations may spend considerable time designing routes while giving relatively little thought to how production activities should actually be categorized from a costing perspective.
The result is often a route structure that accurately reflects production but fails to provide meaningful financial insight.
When creating cost categories, think about the types of activities you want to analyze and report on. Separating these activities provides greater visibility into where production costs are occurring and allows for more meaningful reporting later. Well-designed cost categories allow manufacturers to:
- Separate labor and machine expenses
- Analyze production costs more effectively
- Support variance analysis
- Improve work-in-progress reporting
- Create more meaningful overhead calculations
The screenshot below shows an example of how cost categories can be configured in D365 F&O to capture different types of production costs and support more detailed analysis:
One best practice I consistently recommend is using clear naming conventions. Months or years after implementation, a controller reviewing a variance report should immediately understand what each category represents.
Why The Costing Sheet Matters
Once routes and cost categories are established, the costing sheet brings everything together.
I often describe the costing sheet as the financial lens through which production activity becomes visible. It provides a structured breakdown of production costs and determines how D365 F&O rolls costs into the final manufactured item cost.
Most manufacturers structure their costing sheets around three major categories:
- Material costs: Raw materials and purchased components consumed during production
- Manufacturing costs: Labor and machine costs generated from route operations
- Indirect costs: Electricity, maintenance, facility expenses, etc.
The costing sheet helps separate these areas while supporting calculations for labor overhead, material overhead, machine costs, and plant overhead.
The example below shows how cost groups are organized within the costing sheet to separate and track direct manufacturing costs.
This visibility becomes especially valuable when comparing estimated costs to actual production results.
Instead of simply knowing that costs were higher than expected, organizations can begin identifying why.
- Were labor costs higher?
- Were machine hours underestimated?
- Did overhead rates increase?
The costing sheet helps answer those questions.
How Routes, Cost Categories, and Costing Sheets Work Together
When I’m explaining production costing to new clients, I usually describe these three components as a chain.
The route defines what work happens > cost categories determine how that work should be valued > costing sheet organizes those costs into a meaningful financial structure.
If any one of those pieces is missing, costing accuracy suffers.
You may have perfectly estimated operation times, but if no cost category exists for an operation, costs may never be captured correctly.
Likewise, you may have a sophisticated costing sheet, but if the route doesn’t accurately reflect what happens on the shop floor, the resulting cost calculations will still be misleading.
The most successful costing implementations aren’t necessarily the ones with the most detailed routes or the most complex costing models. They’re the ones where routes, cost categories, and costing sheets work together to represent reality.
Aligning Your BOM With Your Route Structure
Another area I frequently review during costing discussions is the relationship between the BOM and the route.
The BOM defines what materials are consumed, whereas the route defines how the product is produced.
Ideally, those two structures should support one another.
When manufacturers want detailed production visibility, materials can be associated with specific route operations. This allows material consumption to occur as a production order progresses through the manufacturing process.
If those relationships are not defined, materials may instead be consumed at the beginning or end of production. Neither approach is inherently right or wrong. The appropriate approach depends on the level of operational control and costing visibility the organization requires.
Learn more about BOMs in F&O: Product BOMs vs Production Order BOMs in Dynamics 365 Finance & Operations
Troubleshooting Common Production Costing Problems in D365 F&O
When manufacturers tell me their production costs do not look right, I typically review four areas first.
Missing Cost Categories
Missing cost categories are one of the most common causes of inaccurate cost calculations. If an operation lacks the appropriate category, labor and machine costs may not be captured correctly.
Incorrect Time Standards
Small timing inaccuracies can have a surprisingly large impact on costing. Setup times, runtimes, quantities, and production assumptions should be reviewed carefully.
BOM and Route Misalignment
Materials should be consumed in a way that reflects the actual production process. Disconnects between the BOM and route often create confusion during costing analysis.
Costing Sheet Rates and Dates
Costing sheets rely on active rates and financial periods. Using outdated rates or incorrect fiscal periods can result in inaccurate cost calculations or missing overhead costs altogether.
Before You Configure Routes, Build the Foundation First
One of the biggest mistakes I see is spending too much time perfecting routes before the underlying production and costing setup is ready.
Before investing heavily in route design, make sure your resources, BOMs, cost categories, cost groups, and costing sheet are configured consistently. A strong foundation will do more for costing accuracy than an overly complex route ever will.
As your team gains experience and real production data becomes available, routes can be refined, assumptions can be adjusted, and costing accuracy will improve over time.
This is where working with a trusted Dynamics 365 Finance & Operations partner can make a meaningful difference. Accurate production costing depends on more than system configuration. It requires a clear understanding of the manufacturing processes, operational requirements, and financial objectives that the system is designed to support.
Getting that foundation right early, and refining it as your organization grows, can help reduce costly rework, improve costing visibility, and give decision-makers greater confidence in the numbers they’re using every day.
Author
