Viewing Procurement Statistics

This section discusses how to view procurement statistics.

Page Name

Definition Name

Usage

Procurement Statistics inquiry Page

PRCR_TXN_HISTORY

View requisition, purchase order, and receipt statistical information.

Use the Procurement Statistics inquiry page (PRCR_TXN_HISTORY) to view requisition, purchase order, and receipt statistical information.

Navigation:

Purchasing, Analyze Procurement, Review Procurement Information, Procurement Statistics

This example illustrates the fields and controls on the Procurement Statistics inquiry page. You can find definitions for the fields and controls later on this page.

Procurement Statistics inquiry page

Note: You must run the Procurement Statistics process (PRCR_TXN_HIST) before data will appear on this inquiry page.

See Generating Procurement Statistics.

Search Criteria

Field or Control

Description

Document Type

Select the type of information you want to view. Document types are:

  • Purchase Order

  • Receipt

  • Requisition

Depending on the document type you select, the grid in the lower portion of the page will display differently.

Reporting Entity ID

Select the reporting entity. Only reporting entities IDs that are associated with a Spend Analysis reporting entity type will appear for selection. The reporting entity ID specified here should correspond to the one entered on the run control request. The reporting entity determines which business units purchase orders are included in the statistical calculations.

Business Unit From and Business Unit To

Select the range of business units whose information you wish to view. If no business unit is specified here, the information for all business units will be displayed.

From/Period Year and To/Period Year

Select the date range you want to view the transactions summary for. The period range specified on the Update Procurement Statistics run control determines the periods and years available for selection.

Purchase Order Transactions

Field or Control

Description

Average # of PO Lines (average number of purchase order lines)

Displays the average number of purchase order lines for the period. For each business unit, all the purchase order lines associated with the purchase orders in the period are counted. That number is then divided by the total number of purchase orders in the period to give you the average number of purchase order lines.

Max # of PO Lines (maximum number of purchase order lines)

Displays the maximum number of purchase order lines for the period. For the time period, this is the most number of purchase order lines contained on one purchase order.

High Monetary Amount

Displays the highest monetary amount of one purchase order for the period. Each purchase order is converted into the currency specified on the reporting entity ID, using the rate indicated. The highest amount associated with one purchase order displays.

Low Monetary Amount

Displays the lowest monetary amount of one purchase order for the period. Each purchase order is converted into the currency specified on the reporting entity ID, using the rate indicated. The lowest amount associated with one purchase order displays.

Receipt Transactions

Field or Control

Description

Average # of Receipt Lines (average number of receipt lines)

Displays the average number of receipt lines for the period. For each business unit, all the receipts lines for a receipt in the period are counted. That number is then divided by the total number of receipts in the period to give you the average number of receipt lines.

Max # of Receipt Lines (maximum number of receipt lines)

Displays the maximum number of receipt lines for the period. For the time period, this is the most number of receipt lines contained on one receipt.

# of Receipts from Receive Loader (number of receipts from receive loader)

Displays the number of receipts processed through the Receive Load process for the period.

Requisition Transactions

Field or Control

Description

Average # of Req Lines (average number of requisition lines)

Displays the average number of requisition lines for the period. For each business unit, all the requisition lines associated with the requisitions in the period are counted. That number is then divided by the total number of requisitions in the period to give you the average number of requisition lines.

Max # of Req Lines (maximum number or requisition lines)

Displays the maximum number of requisition lines for the period. For the time period, this is the most number of requisition lines contained on one requisition.

High Monetary Amount

Displays the highest monetary amount of one requisition for the period. Each requisition is converted into the currency specified on the reporting entity ID, using the rate indicated. The highest amount associated with one requisition displays.

Low Monetary Amount

Displays the lowest monetary amount of one requisition for the period. Each requisition is converted into the currency specified on the reporting entity ID, using the rate indicated. The lowest amount associated with one requisition displays.

# of Reqs From Req Loader (number of requisitions from requisition loader)

Displays the number of requisitions processed through the Purchasing Requisition Loader process for the period. Any requisition that contains a system source of BCP (configurator product batch), BIN (inventory batch), BOM (order management batch), BPO (purchase order batch), POU (point of use), PPC (project costing or line entry page), and WM (Maintenance Management) is counted and considered processed through the requisition loader.