Purchase Orders

The Purchase Orders dataset lists Purchase Orders with their amounts and invoice status, for tracking spend by supplier, status or department.

At a glance

Item Value
Picker heading Data Tables
One row is One Purchase Order in Detail, or one group in Consolidated
Presentations Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Sparklines, Grouped Line
Default presentation Table
Default period Last 30 Days. Time charts start on Last Month.
Date basis Order Date or Delivery Date. A Purchase Order matches when either falls in the Period.
Default columns PO Number, Supplier, Status, Order Date, Delivery Date, Total Amount, Currency, Work Order Number, Asset Number, Asset Description
Group Modes Detail and Consolidated for tables. Charts are Consolidated.
Drill-through Column Chart only

Measures

Measure Unit Aggregation Definition
Purchase order count Purchase Orders Count Number of Purchase Orders.

Charts count Purchase Orders only. Consolidated tables also show these totals.

Consolidated column Definition
Group The group's name.
Currency The group's currency.
Purchase Order Count Number of Purchase Orders in the group.
Total PO Amount, Total Tax Amount Sum of Total Amount and Tax Amount.
Total External Invoice Total, Total External Invoice Amount Due, Total External Invoice Amount Paid Sum of the invoice values.

Columns

Column Type Description
ID, PO Number Mixed The Purchase Order's internal ID and number.
Supplier, Status, Department Text The Purchase Order's supplier, status and own department.
Order Date, Delivery Date Date When it was ordered and is due for delivery.
Delivery Contact, Delivery Address, Delivery City, Delivery State, Delivery Zip, Delivery Phone Text The delivery details.
Billing Address Text The billing address.
Total Amount, Tax Amount, Tax Inclusive Mixed The amounts, and whether the total includes tax.
Currency, Exchange Rate Mixed The currency and its rate.
Approved By, Approved Date Mixed Who approved it, and when.
Created By, Created At Mixed Who created it, and when.
Notes, Custom Field 1, Custom Field 2, Custom Field 3 Text Notes and your custom fields.
External Invoice Status, External Invoice Payment Status Text The invoice and payment status from your finance system.
External Invoice Total, External Invoice Amount Due, External Invoice Amount Paid Number The invoice values from your finance system.
Work Order Number Text The linked Work Orders.
Asset Number, Asset Description Text The linked Work Orders' Assets.
Asset Department, Class, Asset Group, Asset Type, Manufacturer Text The linked Assets' values, listed together.
Asset Status, Criticality, Planning Type, Hire Status, Project, Customer Text The linked Assets' values, listed together.

Filters

Filter Choice Behaviour
Supplier, Status Multiple The Purchase Order's supplier and status.
Department Multiple The Purchase Order's own department.
Approved By Multiple Who approved it.
Cost Range A minimum and maximum Total Amount.
Invoice Status Multiple Not Invoiced, Partially Invoiced, Fully Invoiced or Over Invoiced.
Payment Status Multiple Not Paid, Partially Paid or Paid.
Asset Number Multiple Matches when any linked Asset does.
Asset Department, Class, Group, Asset Type, Manufacturer Multiple Matches when any linked Asset does.
Asset Status, Criticality, Planning Type, Project, Customer Multiple Matches when any linked Asset does.
Hire Status Yes, No, All Matches when any linked Asset does.

Group By

Group By Groups by
By Purchase Order Number Each Purchase Order.
By Supplier, By Status, By Currency The Purchase Order's values.
By Department The Purchase Order's own department.
By Approved By Who approved it.
By Asset, By Asset Department The linked Assets' values, as a set.
By Class, By Group, By Asset Type, By Manufacturer The linked Assets' values, as a set.
By Planning Type, By Asset Status, By Criticality, By Hire Status The linked Assets' values, as a set.
By Project, By Customer The linked Assets' values, as a set.

Records with no value appear under Unknown.

Chart notes

  • Charts count Purchase Orders. To show amounts, use a Consolidated table.
  • Series by, Compare and Compare with are not available.

Business rules

  • A Purchase Order's Assets come from its Work Orders. Assets are read through the Work Orders linked to its lines.
  • Several Assets are shown as a set. A column lists every value, and a group uses the whole set, such as Excavator, Truck.
  • Compare amounts in one currency. Use By Currency before comparing totals across suppliers.
  • Either date can match. A Purchase Order ordered before the Period still appears if its Delivery Date falls inside it.

For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.