Prod. order routing Gantt (Power BI report)

APPLIES TO: Generally available in Business Central 2025 release wave 1 (version 26.x).

The Prod. Order Routings Gantt report provides an overview of production processes, combining visual and tabular formats to enhance understanding. The report helps you monitor and analyze production tasks, offering insights into scheduling, durations, and task locations.

[Screenshot of the Prod Order Routing Gantt Power BI Report]

The Production Time Line (Gantt Chart Visual) visualization provides a Gantt chart representation of production processes, enabling you to effectively monitor and analyze tasks within production orders. Key features of this visualization include:

  1. Hierarchy:

    • Parent: Production orders serve as the primary grouping level.
    • Nested Tasks: Routing line descriptions represent individual tasks in the process.
  2. Timeline Configuration:

    • By default, the timeline displays at a daily level.
    • Nonworking days are shaded for improved clarity.
  3. Task Duration:

    • Task durations calculate based on the routing line's starting and ending date-time values.
  4. Task Bar Representation:

    • The color of the task bars differentiates between routing through machine centers and work centers.
    • Within each bar, the name of the machine center or work center displays, providing added context about where the task is done.

The Routing Line Details table shows production orders, routing and operation numbers, and work center or machine center names. Starting Date Time and Ending Date Time show the scheduled start and completion times. Duration Total Hours and Duration Total Days express the elapsed scheduled duration, not posted actual time. The table also shows posted output quantity and routing status.

Use the report

Manufacturing Managers use the report to gain an overview of production scheduling and routing processes. The Production Time Line Gantt chart helps you monitor task durations and sequencing. The bar colors and contextual information on machine centers or work centers allow you to quickly identify resource usage and task assignments. Paired with the Routing Line Details table, you can analyze scheduled production timelines and durations. These durations come from routing line start and end times, not posted actual time. These details help you detect scheduling conflicts, optimize schedules, and ensure you allocate resources effectively across work centers and machine centers.

Production supervisors rely on the report to manage day-to-day production tasks and maintain operational efficiency. The Gantt chart shows production order tasks so that you can easily track which operations are occurring at what locations and for how long. The shaded nonworking days help you identify gaps or conflicts in scheduling and address potential bottlenecks. Meanwhile, the Routing Line Details table provides starting and ending date times with total task durations by day and by hours. Together, the Gantt visual and tabular components of the report support effective coordination for smooth production workflows.

Key performance indicators (KPIs)

The Prod. Order Routing Gantt report includes the following KPIs and measures:

Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Data used in the report

The report uses data from the following tables in Business Central:

  • Prod. Order Routing Line
  • Production Order
  • Capacity Ledger Entry
  • Work Center
  • Machine Center

Try the report

Try the report here: Prod. Order Routing Gantt

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

Track your business KPIs with Power BI goals
Power BI Manufacturing app
Built-in production reports
Manufacturing overview

Find free e-learning modules for Business Central here