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.