Procurement Analysis

The purpose of the Procurement Analysis model is to analyze a broad set of data for purchase order processing and the company’s suppliers. The data that is needed to analyze procurement performance is captured throughout the procurement process. The process steps include purchase order entry, purchase order confirmation, goods receipt, quality inspection, and invoice matching.

The analysis covers these topics:

  • Delivery time accuracy
  • Order-line and quantity-based fill rate
  • Quality of delivered products
  • Monetary measures, for example, ordered values and prices versus invoiced prices and values

You can gain various insights about the procurement process by adding different types of dimensions, suppliers, purchased items, and the buying organization.

Invoice Date and Order Date are used to analyze the facts in this model. See Infor M3 Analytics for M3 CloudSuites Administration Guide for a list of available dates for this model.

Source information

The main source for the model is the Purchase Statistics table (MPURST). It contains the basic statistics for measuring purchasing and supplier performance. Additional date, time, and price information are fetched from the purchase order line table (MPLINE). Actual delivery date and time are retrieved from the Stock Transactions table (MITTRA). The model is populated by several scripted sources, combining details from MPURST and delivered/invoiced purchase order lines from MPLINE, and delivery date and time information from MITTRA.