Display Purchasing Statistics

When you click Purchases, the Executive Information Summary (EIS) program displays these statistics:

Note
The program uses the purchasing branch on the purchase order to determine whether the order matches the scope you have set.

Field Name

Displays

Open PO lines

Month/period column: Current total value of open purchase order lines for inventory items:

Quantity ordered x PO unit cost

Actions that update this value:

  • Release a requisition with Requisition Maintenance (IRM) or enter a purchase order with PO Maintenance (VOE)

  • Close a line with PO Maintenance (VOE)

  • Receive with Receiver Maintenance (IRC) and/or inspect and receive with Receiving and Inspection (IRI)

Other columns: See below.

Open supply reqs

Month/period column: Total value of requisitions for vendor contracts released in the current period:

Suggested cost x (Quantity requested - Quantity received)

Actions that update this value:

  • Run Material Requirements Planning to create requisitions for a vendor contracts

  • Receive a vendor contract with Receiver Maintenance (IRC) and/or inspect and receive with Receiving and Inspection (IRI)

  • Close a vendor contract with Vendor Contract Maintenance (VCM)

Other columns: See below.

Inventory purchases

Month/period column: Total value of purchase orders for inventory items with a PO date in the current period, including consignment inventory moved to on-hand:

Quantity ordered x PO unit cost

Actions that update this value:

  • Release a requisition with Requisition Maintenance (IRM) or enter a purchase order with PO Maintenance (VOE)

Other columns: See below.

Purchased services

Month/period column: Total value of purchase orders for purchased services with a PO date in the current period:

Quantity ordered x PO unit cost

Actions that update this value:

  • Release a requisition for labor with Requisition Maintenance (IRM) or Release Outside Services (WOS) or Order Release Selection (MRR) or enter a labor purchase order with PO Maintenance (VOE)

  • Receive with Receiver Maintenance (IRC) and/or inspect and receive with Receiving and Inspection (IRI)

Other columns: See below.

PO receipts

Month/period column: Total value of purchase order lines received during the current period:

Quantity Received x Actual unit cost

Actions that update this value:

  • Receive with Receiver Maintenance (IRC) and/or inspect and receive with Receiving and Inspection (IRI)

Other columns: See below.

PO price variance

Month/period column: Total variance between purchase price and standard cost for purchase order lines received during the current period:

(Actual unit cost x Quantity received) - (Standard unit cost x Quantity received)

Actions that update this value:

  • Receive with Receiver Maintenance (IRC) and/or inspect and receive with Receiving and Inspection (IRI)

Other columns: See below.

Rejected material

Month/period column: Total value of materials rejected during inspection during the current period:

Quantity rejected x Actual unit cost

Actions that update this value:

  • Reject an inspected item with Receiving and Inspection (IRI)

Other columns: See below.

Other purchases

Month/period column: Total value of purchase order lines for non-stock items and capital assets:

Quantity ordered x PO cost

Actions that update this value:

  • Release a requisition for a non-stock or capital item with Requisition Maintenance (IRM) or enter a purchase order with PO Maintenance (VOE)

Other columns: See below.

Column heading:

Year-to-date
This month last year
Last month
Enterprise
Enterprise YTD
Last year total
Last YTD

For each category of statistics:

Total for the year-to-date
Total for the current month/period last year
Total for the last month
Month-to-date total for the enterprise
Year-to-date total for the enterprise
Last year total (end of year) for the enterprise
Last year's year-to-date total

  1. (Optional) Highlight a purchasing statistics category and click Detail or double click the line to display further details:

Purchasing Statistics

See

Open PO lines, Inventory purchases, Purchased services, and Other purchases

Display Vendor Purchases

Open supply reqs

Display Requisitions

PO receipts and PO price variance

Display Receipt Costs

Rejected material

Display Rejected Materials

Click OK to return to this screen.

  1. Choose the appropriate options:

To

Do This

Print the displayed data

Click Print. See Print an Inquiry.

Display details of the selected purchasing statistics

Highlight a category and click Detail or double click the line. See step 1.

Display open purchase orders by month/period

Highlight a category and click Open stats. See Display Open Purchase Orders by Months/Periods. Click OK to return to this screen.

Return to the Executive Information Summary screen

Click OK. See Display Executive Information Summary Statistics.

Exit and return to the menu

Click Quit.