Purchase Interactive Mix Dashboard

Use this dashboard to analyze the purchase order performance by combining the grouping dimensions with purchase metrics to create an interactive matrix using the SyteLine ERP data.

These are the filters in this dashboard:

  • Entity
  • Site
  • Warehouse
  • Year
  • Year/Month
  • Vendor
  • Purchase Order
  • Purchase Order Status
  • Purchase Order Date
  • Buyer
  • Buyer Name
  • Product Code

The data in this 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 1option:

  • 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

The metrics in the purchase interactive mix dashboard are displayed using two selectors. You can select a value in the PO Measure 1 option to track the primary metric and then select a value in the

PO Measure 2 option to track the secondary metric. This selection creates a comparison of two related or contrasting metrics.

These are the possible values for PO Measure 1 and PO Measure 2 options:

  • Ordered Amount
  • Invoiced Amount
  • Received Amount
  • Fill Ratee Line
  • Fill Rate Order
  • Qty Received
  • Qty Ordered
  • Avg Lead Time
  • Orders

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

Ordered Amount
The total value of purchase orders.
The value is calculated using this formula: Sum (PO line ordered qty* PO line unit price)
Received Amount
The total value of received goods.
The value is calculated using this formula: Sum (receipt qty* PO line unit price)
Invoiced Amount
The total invoice amount that is associated with purchase order lines. This amount is used for reconciliation between procurement and finance.
Total Orders
The sum of all purchase orders.
Fill Rate Line
The percentage of purchase order lines that are fully received compared to total PO lines.
Fill Rate Order
The percentage of purchase orders where all the lines are fully received.
Qty Received
The quantity of items received for this grouping criteria.
Qty Ordered
The quantity of items ordered for this grouping criteria.
Avg Lead Time
The average number of days taken for a purchase order line to be fulfilled.
Orders
The total number of orders for this grouping criteria.