Purchase Order Reconciliation
The Purchase Order Reconciliation dataset matches Purchase Order lines to Work Orders and Events, for comparing expected cost with actual cost.
At a glance
| Item | Value |
|---|---|
| Picker heading | Data Tables |
| One row is | One Purchase Order line raised for a Work Order |
| Presentations | Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Sparklines, Grouped Line, Double Line, Mixed / Combo |
| Default presentation | Table |
| Default period | Last 30 Days. Time charts start on Last Month. |
| Date basis | The Work Order's Started At, Scheduled At or Completed At. A line matches when any falls in the Period. |
| Default columns | All columns |
| Group Modes | Detail tables. Charts are Consolidated. |
| Drill-through | Not available |
Measures
| Measure | Unit | Aggregation | Definition |
|---|---|---|---|
| Purchase order line count | Lines | Count | Number of Purchase Order lines. |
Double Line and Mixed / Combo charts also plot expected and actual cost. See Chart notes.
Columns
| Column | Type | Description |
|---|---|---|
| Asset Number | Text | The Work Order's Asset. |
| Class, Group, Asset Type, Manufacturer | Text | The Asset's classification. |
| Asset Department | Text | The Asset's department. |
| Asset Status, Criticality, Planning Type, Hire Status | Text | The Asset's details. |
| Project, Customer | Text | The Asset's Project and Customer. |
| Event Name, Event Start, Event End, Event Status | Mixed | The Work Order's Event. |
| Work Order Number, Work Order Title, Work Order Description, Work Order Status | Text | The Work Order. |
| Purchase Order Number, Purchase Order Status, Supplier | Text | The Purchase Order. |
| Item Code, Purchase Order Line Description | Text | The line. |
| External Invoice Status, External Payment Status | Text | The invoice and payment status from your finance system. |
| Expected Parts Cost, Expected Labour Cost, Expected Services Cost, Expected Total Cost | Number | The cost expected on the line. |
| Actual Parts Cost, Actual Labour Cost, Actual Services Cost, Actual Total Cost | Number | The invoiced cost. |
Sort By offers the Asset, Event, Work Order and Purchase Order values, because these are shared across a Work Order's lines.
Filters
| Filter | Choice | Behaviour |
|---|---|---|
| Work Order | Multiple | Specific Work Orders. |
| Work Order Status, Custom Status | Multiple | The Work Order's status. |
| Priority, Source | Multiple | The Work Order's values. |
| Team, Crew Member | Multiple | The assigned team and crew. |
| Task Type, Task Code | Multiple | The linked Task's type and code. |
| Cost Responsibility | Multiple | Who is responsible for the cost. |
| Site or Department | Multiple | The Work Order's own department. |
| Asset Department | Multiple | The Asset's department. |
| Asset Number | Multiple | The Work Order's Asset. |
| Asset Class, Asset Group, Asset Type, Manufacturer | Multiple | The Asset's classification. |
| Asset Status, Criticality, Planning Type | Multiple | The Asset's details. |
| Hire Status | Yes, No, All | Whether the Asset is on hire. |
| Project, Customer | Multiple | The Asset's Project and Customer. |
| Supplier | Multiple | The Purchase Order's supplier. |
| Event Name, Event Type, Event Status | Multiple | The Work Order's Event. |
| Event Responsibility, Event Location | Multiple | The Work Order's Event. |
| Scheduled Within, Actual Within | One choice | The Work Order's scheduled or actual dates. |
| Breakdown, Compliance Task, Linked Work Request, Overdue | Yes, No, All | Limits to Work Orders with or without the flag. |
| Job Ready, Confirm Completion | Yes, No, All | Limits to Work Orders with or without the flag. |
| Fitted Component Start Usage | Number | Shown only when component serial tracking is on. |
Group By
| Group By | Groups by |
|---|---|
| By Asset Number | The Work Order's Asset. |
| By Event Description | The Work Order's Event. |
| By Work Order Number | Each Work Order. |
| By Purchase Order Number | Each Purchase Order. |
| By Asset Department | The Asset's department. |
| By Class, By Group, By Asset Type, By Manufacturer | The Asset's classification. |
| By Planning Type, By Asset Status, By Criticality | The Asset's details. |
| By Hire Status | On Hire or Off Hire. |
| By Project, By Customer | The Asset's Project and Customer. |
Chart notes
- Compare offers Expected versus actual cost, on Double Line and Mixed / Combo charts.
- Series by and Compare with are not available.
Business rules
- Expected cost is each line's total. It includes tax, like the invoice total.
- Actual cost comes from the invoice. The invoice total is divided between a Purchase Order's Work Orders by their share of its lines, then into Parts and Services in the same way.
- Invoice values appear once. An invoice covers the whole Purchase Order, so its values show on the first line of each Work Order and Purchase Order.
- Purchase Orders carry no labour. Labour cost is not split from the invoice.
- Dates come from the Work Order. A line can match the Period even if the Purchase Order is older.
For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.