Purchase order analytics - ION Manual

PO Lines

The default sub-tab tracks the open order book:

• KPI cards: Open PO Lines, Past Due, Open Outstanding Value, and Avg Days Since Receipt.
• PO Line Status: distribution of lines by status.
• Past Due Aging: late lines bucketed by days past due.
• Supplier On-Time %: on-time delivery rate for the ten suppliers with the most lines.
• Purchase Order Lines: a detail table with columns including ION PO #, Line #, Part, Supplier, Status, Qty Ordered, Qty Received, % Received, Need Date, Need Date Age (Past Due, Due in 2wk, Due in 1mo, 1mo+, or No Need Date), and Est. Cost.

Receipts

The receiving side of the pipeline, scoped to recent activity:

• KPI cards: Receipts (30d), Quantity Received (30d), Avg Lead Time (30d) (PO creation to receipt, purchase receipts only), and Non-Purchase (30d) for receipts not tied to a purchase order.
• Receipts by Week: receipt counts over the last 12 weeks, stacked by Purchase versus Non-Purchase.
• Receipts: a detail table with columns including Receipt Date, Type, ION PO #, Supplier, Part Number, Qty Received, and Received By.