Skip to main content

Production Management

Sage 100 North America, Dashboard

The Production Management dashboard for Sage 100 North America shows active work orders, overdue production, remaining quantities, completion levels, and make to order activity. It combines top level production KPIs with backlog, status, finished item, and late order analysis. Use this dashboard to monitor production workload, identify overdue work orders, and understand which finished items account for the largest outstanding quantities.

The top row summarizes the current production position, including the number of active and overdue orders, total remaining quantity, average completion percentage, and the proportion of make to order activity. The charts below explain where the backlog sits, how orders are distributed by status and production type, and which finished items contribute most to the workload. The detail worksheet provides the work order records behind the late and overdue totals.

How to use the production management dashboard​

  • Monitor active and overdue work orders to understand the size and urgency of the current production backlog.
  • Review remaining production quantity to see how much work is still outstanding.
  • Track average completion percentage to assess overall progress across active work orders.
  • Compare make to order and make to stock activity across work order status groups.
  • Identify finished items with the largest production volume or remaining workload.
  • Investigate late work orders using the worksheet to review due dates, days late, remaining quantities, completion, and status.

Filters​

Use the filtering panel at the top of the Production Management dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.

Company: multiple values
Product Type: multiple values
Item Type: multiple values
Product Line: multiple values
Production Order Status: multiple values
Work Order Date: value range
Due Date: value range

Key performance indicators (KPIs)​

The key performance indicators (KPIs) are displayed at the top of the dashboard. They show the current production workload, and update based on the filters you apply.

KPIWhat it measures
Active OrdersNumber of work orders currently considered active.
Overdue OrdersNumber of active work orders whose due date has passed.
Overdue %Percentage of active work orders that are overdue.
Total Remaining QtyTotal quantity still required to complete the selected work orders.
Avg Completion %Average completion percentage across the selected work orders.
MTO %Percentage of selected work orders classified as make to order.

Visual components​

View nameType of viewWhat it shows
Backlog by Date BucketColumnShows remaining work ticket quantity by due-date bucket, making it easy to distinguish overdue backlog from upcoming production requirements.
MTO/MTS Orders by Status GroupStacked ColumnCompares make-to-order and make-to-stock work orders across status groups such as Estimate, Open, and Released.
Production by Finished ItemHorizontal BarRanks finished items by production quantity, highlighting the products contributing the most to the selected workload.
Late / Overdue Work OrdersWorksheetLists late and overdue work orders with details such as work ticket number, parent item, due date, days late, remaining quantity, completion percentage, and status.