Widgets

Purchase Order Past Due Receipts

These columns are displayed in this widget:

Site

The site associated with the invoice or sales transaction.

Vendor ID/ Name

The supplier responsible for delivering the items.

Purchase Order

A unique identifier for the order placed with a vendor.

Purchase Order Line

The line associated with purchase order that specifies a particular item.

Release

The number of ordered items fulfilled through this purchase order line.

Item

The code of the item for the ordered material.

Ordered Quantity

The quantity ordered on the purchase order line.

Received Quantity

The quantity of items received for the purchase order line.

Open Quantity

The quantity of items ordered that are yet to be received for the purchase order.

Due Date

The expected delivery date for the purchase order.

Days Overdue

Number of days past the due date for a purchase order that is not yet delivered.

Open PO Aging

This widget displays the total number of open purchase order lines that are past due date. The purchase order lines are categorized into aging buckets based on the aging days.

You can use this widget to identify the overdue procurement lines that require attention or escalation.

The open purchase order lines can be calculated using these formulas:

• Open Qty (per line) = Ordered Qty − Received Qty
• Aging Days (per line) = Current Date − Due Date

The values can be grouped using these dimensions:

• Year
• Month
• Vendor
• Buyer
• Item
• Site/ Warehouse
• Purchase Order Number
• Purchase Order Line