Purchase Order Interactive Table Dashboard

Use the purchase order interactive table dashboard to analyze purchasing activity, buyer performance, vendor distribution, and open purchase commitments.

The data in the purchase order interactive table dashboard is grouped using two selectors. You can select a value in the PO Group By 1 option to define the first level grouping and then select a value in the PO Group By 2 option to perform a second level grouping within each group of the first level.

These are the possible values for PO Group By 1 option:

Site
Warehouse
Buyer
Vendor
Status
Product Code
Vendor Category

These are the possible values for PO Group By 2 option:

Site
Warehouse
Buyer
Vendor
Status
Product Code
Vendor Category
Purchase Order
PO Line

These are the filters in this dashboard:

Entity
Site
Warehouse
Year
Year/Month
Vendor
Buyer
Buyer Name
Purchase Order
Purchase Order Date
Purchase Order Status
Purchase Order Type
Purchase Order Line Status

These columns are displayed in the sales interactive cross tab dashboard:

Received Amount: The total value of items received for the purchase order line.
Ordered Amount: The total value of ordered items for the purchase order line.; The value is calculated using this formula: Ordered item * Item cost
Invoiced Amount: The total invoiced amount for the received items.; The value is calculated using this formula: Sales Amount – Cost
Quantity Ordered: The total quantity of items ordered for the purchase order line.
Quantity Received: The total quantity of items received for the purchase order line.
Number of Orders: The total count of purchase orders for which receipts are generated.
Number of Lines: The total count of purchase order lines for which receipts are generated.
Average Lead Time: The number of days between the order date and received date.