Four reports create rankings: the work orders with the highest costs or the most resource hours, and the technical objects with the highest costs or the longest standstill. Each report shows the ranking as a table and as a chart. You decide how many places it outputs.
Where to find the reports
- Maintenance Role Center: all four reports under Planning > Reports.
- Maintenance - Manager, Maintenance - Workplanner and Maintenance - Worker Role Centers: under Reports, the entries Work Order Statistics (Top 10) and Work Order Statistics (Top 10 Technical Object). There, Work Order Statistics (Top 10) starts the Work Order Statistics Quantity (Top 10) report.
- Using search (Alt+Q) with the name of the report.
| Report | Ranking by | Data source |
| Work Order Statistics Costs (Top 10) | Costs per work order | Work order value entries from consumption and purchase |
| Work Order Statistics Quantity (Top 10) | Resource quantity per work order in one unit of measure, e.g. hours | Work order ledger entries for the consumption of resources |
| Work Order Statistics (Top 10 Technical Object) | Costs per technical object | Work order value entries with detail costs |
| Work Order Standstill (Top 10 Technical Object) | Standstill hours per technical object | Posted work order feedbacks with standstill |
In all four reports, Amount of Results determines how many places the ranking has. The default is 10. To get a meaningful ranking, limit the period with a date filter.
Work Order Statistics Costs (Top 10)
The report totals the amounts of the work order value entries with the work order entry type Consumption or Purchase for each work order and lists the work orders with the highest costs.
| Option | Effect |
| Amount to analyse |
|
| Amount of Results | Number of work orders in the ranking. If it is empty, the message You have to specify the number of work orders, you want to analyse! appears. |
| Date Filter (Posting Date), Date Filter (Execution Date), Date Filter (Document Date) | Only value entries whose posting date, execution date or document date is within the period are included. |
| Item, Resources, External Item, External Resources, External Service, G/L Account | Determine which costs are included: value entries of type Item, Resource or G/L Account. For External Item, External Resources and External Service, value entries of type External Service are counted whose item has the corresponding item type. |
| Work Order Category Filter, Type of Activity Filter | Only work orders with these work order categories or types of activity are included. You enter a filter or select a code from the list. |
On the Resource (No., Type, Resource Group No.), Item (No.) and Work Order (No.) tabs, you can restrict the analysis further, also by other fields.
Result: For each place, the table shows the No. and description of the work order, the detail no. and Detail Description, Work Order Category, Type of Activity and the amount. Work orders without an amount do not appear. In addition, there is a chart of the top work orders and the Spreading Main Costs chart, which splits the costs into items, external services, resources and G/L accounts.
Work Order Statistics Quantity (Top 10)
The report totals the quantities of the work order ledger entries with the entry type Consumption and the type Resource for each work order and lists the work orders with the most units, for example the most working hours. Consumed items are not evaluated.
| Option | Effect |
| Amount of Results | Number of work orders in the ranking. If it is empty, the message You have to specify the number of work orders, you want to analyse! appears. |
| Unit of Measure | Mandatory. Unit of measure in which the quantities are totaled, for example hour or day. Only enter time units. Without a unit of measure, the message Please select a Unit of Measure! appears. |
| Date Filter (Posting Date), Date Filter (Execution Date), Date Filter (Document Date) | Only work order ledger entries whose posting date, execution date or document date is within the period are included. |
| Work Order Category Filter, Type of Activity Filter | Only work orders with these work order categories or types of activity are included. |
On the Resource (No., Type, Resource Group No.) and Work Order (No.) tabs, you can restrict the analysis further.
maintool converts the posted quantity of each resource into the selected unit of measure using the resource's unit of measure. If a resource does not have the selected unit of measure, its entries are not included. The report lists such resources under Not included Resources (missing unit of measure …).
Result: For each place, the table shows the No. and description of the work order, the detail no. and Detail Description, Work Order Category, Type of Activity and the Quantity, plus a chart.
Work Order Statistics (Top 10 Technical Object)
The report evaluates the costs that work orders have caused on technical objects. It is based on the work order value entries with detail costs, that is, the costs that maintool assigns to the technical objects of a work order.
| Option | Effect |
| Type | Kind of objects: Component Address (default), Mounting Position, Technical Component or Vehicle. |
| Amount to analyse | Cost Amount (expected) or Cost Amount (actual). |
| Amount of Results | Number of objects in the ranking. |
| Date Filter | Only value entries whose posting date is within the period are included. maintool rejects an invalid filter expression with a message. |
Result: For each place, the table shows the rank, the number and description of the object and the amount, plus a bar chart.
Work Order Standstill (Top 10 Technical Object)
The report evaluates posted work order feedbacks in which a standstill is recorded. It includes feedbacks with the Standstill toggle switched on whose Reference Object matches the selected Type. For each object in the detail lines of such a feedback, maintool adds the Standstill Duration of the feedback in hours and lists the objects with the longest standstill.
| Option | Effect |
| Type | Kind of objects: Component Address, Mounting Position, Technical Component (default) or Vehicle. |
| Amount of Results | Number of objects in the ranking (default 10). |
You set the period on the Posted Work Order Feedback Header tab with the Posting Date filter.
Result: For each place, the table shows the rank, the number and description of the object and the Standstill Duration (Hours), plus a bar chart.
Notes and limitations
- The amounts are in local currency and come from the work order value entries.
- The Cost Consolidation (Technical Object) report shows the costs per technical object across several levels (component address with all subordinate objects), see Analyzing work order costs.
Related articles
Related to