Open Purchase Orders

The Open Purchase Orders data model tracks all purchase orders that haven't been fully received or closed. It includes measures like quantity ordered, quantity received, quantity backordered, quantity invoiced, quantity open, unit cost, extension amount, and purchase order amount. Open orders are categorized by delivery status: late by 30 days or less, late by more than 30 days, to be delivered within 30 days, and to be delivered beyond 30 days. Use it to monitor order status, track backorders, and review purchasing activity by vendor or product line.

How to use this data model

• Monitor open order status to see what's been ordered, what's been received, and what's still outstanding.
• Track backorders to identify items that haven't been delivered and how long they've been delayed.
• Review quantities by vendor to understand ordering volume and compare activity across suppliers.
• Check expected deliveries using the delivery status categories to plan for what's coming in and what's overdue.

Available views

View	Type	What it shows
Amount Per Product Line	Pie	Shows purchase order amounts split by product line as a proportion.
Back Orders	KPI	Shows backorder count and impact as a quick status indicator.
Quantities by Vendor	Combination	Compares quantities ordered by vendor to see ordering volume across suppliers.
Open Orders Status	Worksheet	Lists all open purchase orders with quantities, amounts, and delivery status.
Procurement Amount and Quantity	Combination	Shows total purchase amounts and quantities together to compare spending against volume.
Back Orders	Worksheet	Lists backordered items with quantities and delay details.