Date Range and Routing Filters for Microsoft Dynamics 365 Business Central
An analysis that mixes old and new ways of running an operation can hide whether a change on the floor made any difference. Routing Analysis lets you choose the routing and the date range of finished production orders to analyze in Business Central, using Routing No., Prod. Order Start Date, and Prod. Order End Date.
Only finished production orders whose finished date falls inside the range are counted.
How Date range and routing filters works in Routing Analysis
- Open Routing Analysis.
- Enter the routing number, or leave it blank for every routing.
- Set Prod. Order Start Date and Prod. Order End Date.
- Set Routing Line Display and any thresholds.
- Choose Generate and review the results for that window.
Key capabilities
Pick the routing
Enter the routing number to analyze one routing and all the finished production orders that used it.
Pick the window
Prod. Order Start Date and Prod. Order End Date set the period. A production order counts when its finished date falls inside it.
Finished orders only
Orders still in progress are not included, so the figures change only as orders are finished.
Compare periods
Run the analysis for one window and then another to see whether an operation's recorded times changed after a process change.
Every routing at once
Leave Routing No. blank to return every routing. See Review All Routings on One Page.
Details that matter on the floor
Enough history in the window
A narrow window with only a few finished orders produces figures that are technically correct but say little. Widen the range until each operation has enough orders behind it.
A look back, by design
Routing Analysis looks back at what was finished. It is a review of completed work, not a live view of the floor.
Who uses Date range and routing filters
Manufacturing engineers
Analyze a routing over the period that reflects the current process.
Production managers
Compare how operations ran before and after a change.
Questions about Date range and routing filters
Can I analyze run times for a specific period?
Yes. Set Prod. Order Start Date and Prod. Order End Date, and Routing Analysis counts finished production orders whose finished date falls inside that range.
Are production orders in progress included?
No. Only finished production orders are included.
Can I analyze every routing at once?
Yes. Leave Routing No. blank to return every routing.
Related Routing Analysis features
All Routing Analysis features →Part of Routing Analysis
Optimize production with routing analysis to reduce variability and enhance costing accuracy.
Have a question about Date range and routing filters?
Send us a note and the Routing Analysis team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.