Reports

Print production orders, analyze operations and material requirements, review final costing, and evaluate WIP.

Purpose

Reports in the Production Order area support operational and financial analysis. They structure production order information for shop floor papers, material and capacity lists, final costing, and WIP valuation.

BE-terna Manufacturing extends standard Business Central reports with additional columns, clearer grouping, and analysis across multiple production levels.

Business Value

  • Production orders can be printed with header, lines, routing lines, and components in a structured format.
  • Shop floor papers contain additional descriptions, quantities, units, times, and QR information.
  • Operation and material requirement lists can be sorted and filtered more precisely.
  • Final costing shows expected and actual costs across several production levels.
  • WIP reports can be reduced to relevant production orders through a threshold.

Use Prod. Order Printout BE

Prod. Order Printout BE arranges production order information in a structured way. It shows information from the production order header, production order lines, routing lines, and components.

  1. Search for Prod. Order Printout BE.

Open Prod. Order Printout BE from search Click to enlarge

  1. Set the required filters for the production order.

Set filters for Prod. Order Printout BE Click to enlarge

  1. Choose Print to generate the report.

The report is structured as follows:

  • Production order header
    • Production order line
      • Routing lines of the production order line
      • Components of the production order line

This structure repeats for all lines in the production order.

Structured Prod. Order Printout BE Click to enlarge

Use Production Order Job Card BE

The Production Order Job Card BE extends the standard Prod. Order - Job Card. It adds information to production order lines, routing lines, and component lines.

On production order lines, the report adds:

  • Description
  • Quantity
  • Unit of Measure

On production order routing lines, the report adds:

  • Description
  • Routing Line QR Code
  • Time Needed
  • Setup Time
  • Run Time

On production order component lines, the report adds:

  • Item No.
  • Description
  • Expected Quantity
  • Unit of Measure Code
  • Location Code
  • Flushing Method
  1. Search for and open Production Order Job Card BE.

Open Production Order Job Card BE from search Click to enlarge

  1. Set the required filters.
  2. Open or print the job card.

Set filters for Production Order Job Card BE Click to enlarge

Example pages of the report:

Production Order Job Card BE page 1 Click to enlarge

Production Order Job Card BE page 2 Click to enlarge

Use Capacity Task List BE

The Capacity Task List BE extends the standard Prod. Order - Capacity Task List. Lines are sorted by Location Code and Line No.

The report adds columns such as:

  • Status
  • Item No.
  • Unit of Measure Code
  • Routing Reference No.
  • Expected Capacity Need
  • Setup Time and Setup Time Unit of Meas. Code
  • Run Time and Run Time Unit of Meas. Code
  1. Search for and open Capacity Task List BE.

Open Capacity Task List BE from search Click to enlarge

  1. Set the required filters.
  2. Select Starting Date or Default as the sorting.
  3. Open or print the capacity task list.

Set filters for Capacity Task List BE Click to enlarge

Example Capacity Task List BE Click to enlarge

Use Prod Order - Material Requisition BE

The Prod Order - Material Requisition BE extends the standard Prod. Order - Mat. Requisition. The report adds Routing Link Code and Expected Quantity. Lines are sorted by Location Code and Line No.

  1. Search for and open Prod Order Material Requisition BE.

Open Prod Order Material Requisition BE from search Click to enlarge

  1. Set the required filters.
  2. Open or print the material requisition list.

Set filters for Prod Order Material Requisition BE Click to enlarge

Example Material Requisition BE Click to enlarge

Use Production Order - Final Costing

The Production Order - Final Costing report shows costs across all production levels. It helps users understand how material and capacity costs from lower levels roll up into the monitored item.

The report shows in particular:

  • Quantity and cost information for all production orders involved in producing the monitored item.
  • Comparison between expected and actual costs by level.
  • Separate material and capacity cost totals.
  • Accumulated costs by production order and production level.
  1. Open the Finished Production Order Card of the item you want to analyze.
  2. Select the production order line.
  3. Choose Line > Production Order - Final Costing.

Open Production Order - Final Costing from the line Click to enlarge

  1. On the request page, decide whether details should be shown.
  2. Choose Print or Preview.

Request page for Production Order - Final Costing Click to enlarge

When Detail is enabled, the report shows a detailed analysis for each production order involved in producing the monitored item. Without details, only the summary page is shown.

Final costing detail level 0 Click to enlarge

Final costing detail level 1 Click to enlarge

Detail pages include, among other things:

  • Production order number, item, description, planned quantity, and finished quantity.
  • Level in the production hierarchy, where the monitored item is level 0.
  • Routing lines with expected and actual time and capacity costs.
  • Components with expected and actual consumption, deviations, and costs.

The All Level Summary page aggregates the detail pages across all levels.

Summary across all production levels Click to enlarge

Important interpretation points:

  • Cost Amount (Actual) is the sum of Promoted Cost Amount (Actual), Direct Cost Amount (Actual), and Capacity Cost on the same line.
  • Promoted Cost Amount (Actual) of one level represents the costs from the lower level that roll up into the parent product.
  • Consumed Qty. (Parent Item) shows the quantity consumed into the parent item.

Use WIP Valuation with a Threshold

WIP valuation shows Work in Progress for selected production orders. It includes values from consumption, capacity usage, and output. The extension is based on the standard Production Order - WIP report and adds the ability to skip entries below a defined threshold.

The report shows invoiced amounts. Run Adjust Cost - Item Entries before reviewing production WIP.

Prepare the Threshold

  1. Open Manufacturing Setup.
  2. Enter the required value in Prod. Order WIP to G/L Threshold Amount.

WIP threshold in Manufacturing Setup Click to enlarge

The value is transferred to Production Order - WIP Additional and can be adjusted before printing.

Review the Standard Production Order - WIP Report

  1. Start Production Order - WIP.
  2. Enter starting date and ending date.
  3. Filter production orders if needed.

Request page for Production Order - WIP Click to enlarge

The standard report shows all WIP values including zero amounts.

Standard WIP report page 1 Click to enlarge

Standard WIP report page 2 Click to enlarge

Use Production Order - WIP Additional

  1. Start Production Order - WIP Additional.
  2. Enter starting date and ending date.
  3. Review or change the G/L threshold amount.
  4. Filter production orders if needed.

Request page for Production Order - WIP Additional Click to enlarge

The report shows WIP values above the threshold and therefore reduces report length.

WIP Additional with threshold Click to enlarge

Result

After setup and use, you can print production orders in a structured format, print operational operation and material lists, trace costs across production levels, and limit WIP valuation to relevant production orders.

Links

Further Information

Related content