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.