Skip to main content

Purchase Orders

The data model includes measures such as Ext Amount, Unit Cost, Quantity Original, Quantity Ordered, Quantity Invoiced, Quantity On BO, Quantity Received, Quantity Return (CR), and Quantity Open to Rcv. Views like PO Amounts by Vendors provide insights on purchase order amounts grouped by vendors, PO Qty Ordered - Top 5 Items highlights the top 5 items by quantity ordered, Warehouse Buyer Quantity Area 100% shows the quantity of items in the warehouse with 100% area coverage, and Purchase Ordered vs. Received compares ordered items to received quantities.

Benefits of This Data Model​

  • Improved Vendor Performance Tracking: The data model allows for tracking and analyzing vendor performance based on metrics such as purchase order amounts and quantities ordered, helping in vendor management and negotiations.
  • Enhanced Inventory Management: By providing insights into warehouse quantities with 100% area coverage and comparing ordered items with received quantities, the data model facilitates better inventory management and optimization.
  • Efficient Purchase Order Analysis: The data model enables detailed analysis of purchase orders by top items ordered, original quantities, and quantities invoiced, aiding in identifying trends, discrepancies, and potential cost-saving opportunities.
  • Streamlined Buyer Performance Evaluation: With dimensions like buyer code and name, the data model supports evaluating buyer performance against key metrics like quantity ordered and quantities returned, streamlining the buyer appraisal process.

Key Performance Indicators (KPIs)​

  • Ext Amount: The total extended amount of the purchase order, which is calculated by multiplying the unit cost by the quantity ordered.
  • Unit Cost: The cost of a single unit of the item being purchased.
  • Quantity Original: The original quantity of items ordered in the purchase order.
  • Quantity Ordered: The total quantity of items ordered across all purchase orders.
  • Quantity Invoiced: The total quantity of items that have been included in an invoice.
  • Quantity On BO: The quantity of items that are on backorder and awaiting fulfillment.
  • Quantity Received: The total quantity of items that have been received from the purchase order.
  • Quantity Return (CR): The quantity of items that have been returned or credited.
  • Quantity Open to Rcv: The quantity of items that are open and pending receipt.

Available Visualisations​

View NameDescription
PO Amounts by VendorsInsights on purchase order amounts grouped by vendors.
PO Qty Ordered - Top 5 ItemsHighlights the top 5 items by quantity ordered in purchase orders.
Purchase Ordered vs. ReceivedCompares the quantity of items ordered in purchase orders to the quantity received.
Warehouse Buyer Quantity Area 100%Shows the quantity of items in the warehouse meeting 100% area coverage.