web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

In what Work Center is the Production Order?

(8) ShareShare
ReportReport
Posted on by 3,949
Hi:
 
Is there a report or screen in Business Central that will show at what Work Center the Production Order is at?
 
In other words, is there a way to tell at what "spot" in the Routing the Production Order is at?
 
John
I have the same question (0)
  • Verified answer
    Ben Baxter Profile Picture
    7,079 Super User 2026 Season 1 on at
    There isn't much in base BC to see the specific Operation a Production Order is on.  However, you can open the Prod. Order Routing Line (5409) table directly and then filter by Routing Status to get the view you want:
     
    Without development, you can do this through change the site to include table=5409 at the end to open the table, then apply the filters you want.
     
    You could also ask a Developer to give you a link to this table with preset filters for easier access.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Verified answer
    Sumit Singh Profile Picture
    11,795 Super User 2026 Season 1 on at
    Agreed with Ben. I have checked Power BI standard reports also but not fulfills this requirement
     
    Based on Prod. Order Routing line table, you can use configuration package to extract the data. 
     
    Else, guide technical resource to develop this or use this as an standard but yes navigation is difficult. 
     
  • Suggested answer
    YUN ZHU Profile Picture
    101,018 Super User 2026 Season 1 on at
    Currently, you can only analyze the table by directly opening it or exporting it from a Configuration Package.
    Or, you can have a developer customize a new list page.
     
    Thanks
    ZHU
  • Verified answer
    Chavda Dharmendra Profile Picture
    1,004 Super User 2026 Season 1 on at
    You can create a custom List page or report to show this data.
    There is not any standard page or report to display.
  • Verified answer
    Cenzo Profile Picture
    336 on at
    In Microsoft Dynamics 365 Business Central, there is no direct standard report or screen that explicitly shows the current Work Center or exact "spot" in the routing where a Production Order is at in real-time. However, there are some key tools and reports that can help track production order routing progress and work center status:
    1. Prod. Order - Routing List Report: This standard report provides a detailed overview of the routing steps for a production order, listing operations with their assigned work centers and the sequence of steps. Though it shows the routing structure and assignments, it does not dynamically show at which step the order currently is but can be used to track progress when combined with operation status data.
    2. Operation Status Columns and Lists: Business Central shows operation status (Not started, Started, Partially completed, Completed) in production order operation lists. This helps understand which operations have started or completed and thus infer the current routing step.
    3. Production Order Queues on Role Center: The Role Center in Business Central can display lists of released orders and their routing steps, providing visibility into what is currently on the floor and operations started, helping with shop floor management and production tracking
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    6,227 Super User 2026 Season 1 on at
    In the standard Business Central setup, there is limited visibility into the specific operation stage of a Production Order. However, the Manufacturing Power BI app for Business Central gets a lot of updates in the 2025 release wave 2. 
     
    You can download the pbix file from GitHub here
    BCTech/samples/PowerBi/PBI27Apps/Public Preview/Manufacturing app.pbix at master · microsoft/BCTech · GitHub
     
    They are updating the following report pages (read all about the actual changes on Yammer) 
    📊 Gantt Chart report
    📊 Posted Output Quantity
    📊 Finished Production Order Breakdown       
    📊 Task List Drill Through                                   
    📊 Work Center Load
    📊 Production Order Overview
    📊 Finished Production Order Breakdown
    📊 Released Production Orders
    📊 Prod Order - List
     
    Out of all these reports, they also have a "Prod. Order Routing Gantt" report. This might help you to know the exact status of each routing of a released production order. 
     
    Regards
    Rishabh Kanaskar

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,029 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,226 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,201

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans