The work order lists output work orders as a list: with dates and responsibilities, with amounts, with duration or standstill, sorted by budget or with the fields relevant for posting. This article describes the five lists, their options and what they show.
You can find all five reports in the Maintenance Role Center under Planning > Reports, and the Work Order List also under Execution > Reports. Alternatively, search for the name of the report (Alt+Q).
Which list for what
| Report | Shows for each work order | Grouping and totals |
| Work Order List | Status, dates, responsibilities and type of activity | none |
| Work Order List - Sales | Customer, planned amount, invoiced amount and sales amount | optionally by customer, totals line |
| Work Order List - Duration / Standstill | Work order duration or standstill duration in hours with category, type of activity, malfunction code and damage identification | optionally by one of eight characteristics, totals line |
| Work Order List - Budget | Planned amount, sorted by budget and budget position | subtotals per budget and position, totals line |
| Work Order List - Commercial | Fields relevant for posting, optionally with amounts | totals line when amounts are shown |
The filters on the Work Order tab are suggestions. As with any Business Central report, you can add further work order fields as additional filters. The Sales, Duration / Standstill, Budget and Commercial lists remember the options you selected last.
Work Order List
The Work Order List is a simple overview of work orders. The suggested filters are No. and Work Order Status Value; there are no options.
For each work order, the list shows: No., description (with Description 2 and 3), work order status, opening date, the two global dimensions, Person in Charge No., shift, type of activity, responsible department, work order priority, execution date-time, planned completion and the dates Reported finish at Date and Reported complete at Date.
Work Order List - Sales
This list compares the planned and posted costs of each work order with the sales amounts, for example for work orders that you invoice to customers.
Suggested filters: No., Sales to Customer No., Work Order Status Value, Work Order Posting Group, Account No., the two global dimensions, Budget No. and Budget Position No.
| Option | Effect |
| Date Filter (Posting Date) | For Invoiced Amount and Sales Amount, only work order value entries with a posting date in this period are included. The Planned Amount does not change. |
| Date Filter (Execution Date) | Shows only work orders whose Execution Date-Time is within the period. |
| Date Filter (Document Date) | Shows only work orders whose Document Date is within the period. |
| Grouping | Blank: no grouping. by Customer: the work orders are grouped by customer, with a subtotal per customer. |
| Print summary | Inserts a totals line at the end. |
| Extended Work Order Description | Prints Description 2 and Description 3 of the work order in a separate line. |
For each work order, the list shows No., description, customer (number and name) and three amounts:
- Planned Amount: total of the line amounts of the planned work order lines. Unscheduled lines are not included.
- Invoiced Amount: actual direct costs from the value entries for consumption and purchase, without overhead costs.
- Sales Amount: sales amount of the value entries for sales (field Invoiced Amount (Sales) of the work order).
Work Order List - Duration / Standstill
This list shows how long work orders take or how long equipment is at a standstill, and totals the hours by a characteristic, for example by malfunction code or type of damage.
Suggested filters: No., Work Order Status Value, Res. Department No., Work Order Category Code, Type of Activity Code, Malfunction Code, Type of Damage, Figure of Damage and Cause of Damage.
| Option | Effect |
| Date Filter (Execution Date) | Shows only work orders whose Execution Date-Time is within the period. |
| Date Filter (Document Date) | Shows only work orders whose Document Date is within the period. |
| Evaluation Type | Duration: evaluates the Work Order Duration of the work order. Standstill: evaluates the Standstill Duration. Both are output in hours. |
| Grouping | Blank or by Work Order Category, by Type of Activity, by Malfunction, by Work Order Priority, by Shift, by Type of Damage, by Figure of Damage, by Cause of Damage. Each group shows the description of the characteristic and a subtotal of the hours; work orders without a value are listed under <empty>. |
| Print summary | Inserts a totals line at the end. |
| Extended Work Order Description | Prints Description 2 and Description 3 in a separate line. |
For each work order, the list shows No., description, responsible department, work order category, type of activity, malfunction code, work order priority, shift, type of damage, figure of damage, cause of damage and the hours.
The report evaluates the Work Order Duration and Standstill Duration fields on the work order. There, the Work Order Duration results from Execution Date-Time and Planed Completion Date-Time. To compare with the times actually reported, use the Work Order Statistics report, see Analyzing work order costs.
Work Order List - Budget
This list shows which work orders are assigned to which budget and how much is planned for them.
Suggested filters: No., Work Order Status Value, Budget Name, Budget No. and Budget Position No.
| Option | Effect |
| Date Filter (Execution Date) | Shows only work orders whose Execution Date-Time is within the period. |
| Date Filter (Document Date) | Shows only work orders whose Document Date is within the period. |
| Date Filter (Posting Date) | Appears in the filter line of the report. It has no effect on the Planned Amount. |
| Print summary | Inserts a totals line at the end. |
| Extended Work Order Description | Prints Description 2 and Description 3 in a separate line. |
| Expand | On: all lines are shown expanded. Off: the budgets are shown collapsed, and you expand them in the report down to the position. |
The list is structured by Budget Name, Budget No. and Budget Position No., each with its description. Below them are the work orders with No., description and Planned Amount, plus subtotals and the grand total.
Work Order List - Commercial
This list shows the fields that matter for posting a work order and, if you like, its amounts. For example, before posting work order costs to the general ledger you can check whether posting group, account and budget are correct. The suggested filters are No. and Work Order Status Value.
Without options, the list shows for each work order: No., description, Work Order Posting Group, the two global dimensions, Budget Name, Budget Position No., Account No., Capitalization, type of activity, work order status, Further Job Costing, Sales to Customer No., Fixed Asset No. and Document Date.
| Option | Effect |
| Show Amounts | Additionally shows Planned Amount, Invoiced Amount, Invoiced Amount incl. OR and Invoiced Amount (Sales) for each work order in a separate line. At the end there is a Total line across all filtered work orders. |
| Show Amount in one line | Shows the amounts in the same line as the other fields of the work order, also with a totals line. Only works together with Show Amounts; otherwise the message Please activate Show Amounts appears. |
The amounts mean:
- Planned Amount: total of the line amounts of the planned work order lines.
- Invoiced Amount: actual direct costs from consumption and purchase.
- Invoiced Amount incl. OR: like Invoiced Amount, plus overhead costs.
- Invoiced Amount (Sales): sales amount of the value entries for sales.
Notes and limitations
- All amounts are in local currency and come from the work order value entries. Unscheduled work order lines are not included in the Planned Amount.
- A date filter on the posting date only affects the posted amounts, not which work orders are selected. The filters on the Work Order tab and the date filters on execution and document date determine which work orders appear in the list.
Related articles
- Reports overview
- Analyzing work order costs
- Top 10 work order analyses
- Fields of the work order card
Related to