Purchase Interactive Cross Tab Dashboard
Use this dashboard to analyze the purchasing activity by combining the grouping dimensions with purchase metrics to create an interactive matrix using the SyteLine ERP data.
The procurement and operations teams can use this dashboard for informed and data-driven decisions. You can define the grouping hierarchy to analyze purchasing behaviour, profitability drivers, and operational performance.
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 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 purchase interactive cross tab dashboard:
- Ordered Amount
- The total ordered purchase amount for each purchase order based on the order date.
- Received Amount
- The total ordered purchase amount for each purchase order based on the received date.
- Quantity Ordered
- The total ordered quantity for each purchase order based on the order date.
- Invoiced Amount
- The total invoice amount that is related to the purchase order lines. This amount is used for reconciliation between procurement and finance.
- Quantity Received
- The total received quantity for each purchase order based on the received date.