Reviewing Supplier Performance

This chapter provides an overview of supplier performance metrics, lists prerequisites, and discusses how to:

See Also

Using PeopleSoft eSupplier Connection Pagelets

Click to jump to parent topicUnderstanding Supplier Performance Metrics

Supplier performance is crucial to your ongoing relationship with your suppliers. Problems (such as poor quality or late delivery) with supplier shipments can lead to additional expense, a breakdown in the relationship, and, ultimately, exclusion of the supplier.

You can provide your employees (and your suppliers) with ongoing performance measurements against various metrics and provide instant feedback (against predefined targets) if there are delivery or quality problems.

You can generate metrics to track a vendor's on-time, quantity, quality, and quantity ordered versus received performance.

This section discusses:

Click to jump to top of pageClick to jump to parent topicSupplier Metric Access

Supplier performance metrics are available to your internal users as a regular PeopleSoft eSupplier Connection feature. Your suppliers can use the supplier performance pagelets to view these metrics for the vendors to whom they have access in a graphical display and navigate to the performance detail pages.

All users can navigate from one metric to another by changing their selections in the Metric field on any performance detail page, provided that their security settings allow access to all of the pages.

See Also

Using PeopleSoft eSupplier Connection Pagelets

Click to jump to top of pageClick to jump to parent topicOn-Time Metric

The On-Time metric tracks the percentage and actual number of vendor shipments that are on time, early, and late for all of the items within a period. You can base your measurements on one of two methods:

See Also

Defining Supplier Performance Targets and Tolerances

Viewing On-Time Performance Details

Click to jump to top of pageClick to jump to parent topicQuantity Metric

The Quantity metric tracks the percentage and actual number of vendor shipments (receipts) with correct quantities, over-shipment quantities, and under-shipment quantities by period.

Using the previous example for on-time metrics, the calculation would reflect a 75 percent under metric (three of four receipts were less than the correct scheduled quantity).

See Also

Viewing Quantity Performance Details

Click to jump to top of pageClick to jump to parent topicQuantity Ordered Versus Received Metric

The PO/Received Quantity (purchase order/received quantity) metric tracks the percentage and actual quantity of the receipts against purchase order (PO) quantity by period.

Using the previous example, the calculation would reflect a 100 percent received metric (100 were scheduled, and 100 were received, regardless of the number of receipts).

See Also

Viewing PO Versus Receipt Performance

Click to jump to top of pageClick to jump to parent topicQuality Metric

The Quality metric tracks the percentage and actual number of vendor shipment quantities that are inspected, accepted, rejected, and returned by period.

The system calculates a percentage rejected and a percentage returned as part of the quality performance metric. This calculation uses only return-to-vendor records that have a receiver ID and ignores canceled receipts.

You can exempt (or include) certain receiving reject or return reason codes from the percentage of defectives that your supplier performance metrics reflect.

For example, you may not want to use incomplete shipments as a performance measurement for product quality. You can use the Return/Reject Reasons page to remove the Include in Quality Metric flag from that particular reason code.

See Also

Viewing Quality Performance Details

Defining Procurement Options

Click to jump to parent topicPrerequisites

Before the system can calculate performance metrics, you must:

  1. Build a calendar using the Calendar Builder page in the Common Definitions menu.

  2. Set up a procurement analysis reporting entity using the Define Procurement Controls page in the Analyze Procurement menu.

    In particular, you must:

    1. Select the Include Receiver Data and Include PO Data check boxes.

    2. Enter at least one receiving and one purchasing business unit.

      Note. Your business unit selections must include all of the business units that contain the data that you want your suppliers to view. The metrics that appear to suppliers are related only to the reporting entity that you attach to the PeopleSoft eSupplier Performance setup record.

  3. Define system targets and tolerances for the reporting entity.

  4. (Optional) Define vendor-specific targets and tolerances for the setID.

  5. Run the Procurement History Update process (FS_PRCRUPD).

See Also

Defining Financials and Supply Chain Management Common Definitions

Configuring Procurement Analysis Inquiries

Generating Procurement History

Click to jump to parent topicDefining Supplier Performance Targets and Tolerances

To define supplier performance targets and tolerance levels, use the Supplier Performance Setup component (WV_PE_METRIC_SETUP). To vendor supplier performance targets and tolerance levels, use the Supplier Performance Vendor component (WV_PE_METRIC_VNDR).

You can define how the system derives and displays supplier performance metrics by setting performance targets and tolerances.

This section provides an overview of metric display and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Metric Display

This section discusses the appearance of the charts that display supplier metrics.

Graph Colors

The target and tolerance percentages that you enter on the metrics setup pages determine certain performance graph bar colors. Values that are:

Performance graph bars can also represent particular metric values; for example, the percentage of early shipments is expressed in blue on the On-Time Performance graph.

We use a PeopleTools 2D Bar chart type.

See Enterprise PeopleTools PeopleBook: PeopleCode Language Reference

Metrics

The system displays metrics against a specific target and tolerance for a particular vendor within a reporting entity if you define targets and tolerances on the Supplier Performance Vendor page. Otherwise, the system uses the general system-level targets and tolerances, which you define on the Supplier Performance Setup page.

Periods

The data (percentages) that appear are an aggregation of the items and units of measure for which receipts have been made. For each period shown, the user must navigate to view the underlying data that supports the chart.

The number of periods that appear is determined at the system level. The periods that appear in the performance detail pages (and their associated supplier pagelets) are based on the date ranges that the calendar ID that is associated with the reporting entity ID in PeopleSoft Purchasing defines.

See Defining Reporting Entities.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Supplier Performance Targets and Tolerances

Page Name

Definition Name

Navigation

Usage

Supplier Performance Setup

WV_PE_METRIC_SETUP

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Supplier Performance Setup

Define system targets and tolerances for the Purchasing reporting entity.

Supplier Performance Vendor

WV_PE_METRIC_VNDR

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Supplier Performance Vendor

Define vendor-specific targets and tolerances for a setID.

Click to jump to top of pageClick to jump to parent topicDefining System Targets and Tolerances

Access the Supplier Performance Setup page (Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Supplier Performance Setup).

To set up system targets and tolerances for the reporting entity:

  1. Determine the reporting entity:

    Reporting Entity ID

    Select to establish system targets and tolerances for this reporting entity. Define reporting entities on the Define Procurement Controls page in PeopleSoft Purchasing.

    See Defining Reporting Entities.

  2. Establish performance targets and tolerances (these metrics are expressed in percentages):

    On-Time Performance Target

    The optimal percentage of on-time deliveries (quantity or receipts) for the given period.

    See Viewing On-Time Performance Details.

    Quantity Performance Target

    The optimal percentage of correct shipments in terms of quantity received versus scheduled quantity for the given period.

    See Viewing Quantity Performance Details.

    Quality Performance Target

    The optimal percentage of receipts that are received without being rejected due to quality for the given period.

    See Viewing Quality Performance Details.

    PO/Receipt Qty Perf. Target (purchase order/receipt quantity performance target)

    The optimal percentage of ordered versus received quantities for the given period.

    See Viewing PO Versus Receipt Performance.

  3. Set the chart and grid settings:

    Number of Periods to Display

    The number of periods that you want to appear in the graphical charts. The calendar definition determines a period's length.

    Max Rows to Return (maximum rows to return)

    The maximum number of rows that the system retrieves when the supplier selects detail for a period. This limits how much data the system retrieves to conserve web server resources.

  4. Select early and late metric display settings.

    You can calculate early and late metrics in one of two ways:

    Early/Late Metrics by Receipts

    Bases the metric on the total number of receipts in relation to the schedule date. You may prefer this method when you want to measure timing of shipments regardless of quantity.

    Early/Late Metrics by Quantity

    Bases the metric on the aggregated receipt quantity in relation to the schedule date. You may prefer this method when you typically have several receipts for a given PO schedule line (versus the metric based on receipt count only).

    See Understanding Supplier Performance Metrics.

Click to jump to top of pageClick to jump to parent topicDefining Vendor-Specific Targets and Tolerances

Access the Supplier Performance Vendor page (Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Supplier Performance Vendor).

This page is nearly identical to the Supplier Performance Setup page with the exception that you are defining values for a specific vendor in a SetID rather than system-wide reporting entity values.

Click to jump to parent topicViewing Supplier Performance Metrics

Your employees and your suppliers can access the supplier performance detail pages.

This section provides an overview of viewing supplier performance metrics, lists common elements, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Viewing Supplier Performance Metrics

The internal-facing versions of the supplier performance detail pages are identical to the external-facing versions, with one exception: internal-facing pages include a SetID field with which internal users can access all vendors that are associated with the setID. However, vendors who use the external-facing pages can access only the vendors to whom you have granted them access. Vendors don't have access to the internal-facing detail pages.

Click to jump to top of pageClick to jump to parent topicCommon Elements Used in This Section

Metric

Select On-Time Performance, Quality Performance, Quantity Over/Under Performance, or PO/Receipt Qty Performance (purchase order/receipt quality performance). Available options depend on whether the user has security for the pages.

Vendor

This field appears when the user is associated with more than one vendor. Internal users can select a vendor that is associated with the setID. The system displays only setID-vendor combinations for which there is data in the PRCR_ITEM_HST table.

Period/Year

Click a value to append complete procurement analysis data to the page that you are viewing. This summarizes the metrics for the item ID during the period.

See Viewing On-Time Performance Details for an example.

The periods that appear are based on the date ranges that the calendar ID that is associated with the report ID in PeopleSoft Purchasing defines.

When you select a period or year on a performance page, the system appends performance detail information and redisplays the page with the following information, which you can filter using several criteria.

From Percentage/To Percentage displays all items where the on-time, quantity, or quality percentage falls in a specific percentage range. Initially, From Percentage is set to 0, and To Percentage is set to the target percentage for the metric.

If the from and to criteria don't return any data, the system changes the To Percentage to 100, and the system displays the selection again so that at least one row is returned in the grid.

If the from and to criteria return more rows than the Max Rows setting allows, the system displays an error message prompting the user to modify the from and to percentages to reduce the number of returned rows.

Performance Detail

Once you refresh a performance detail page, the system redisplays the page and adds further detail for the selected period. In particular:

Item ID and Vendor Item ID

Click a value to access the Review Receipts - Receipt Lines page, which displays individual receipt line details.

Note. For the PO/Receipt metric, this link takes you to the Review Purchase Orders - Purchase Order List page; you can access the Receipt pages by drilling into the associated PO pages.

See Reviewing Receipts.

Ship To

The ship to business unit. Click a value to access the Ship To Details page.

Send Email

Click to send an email that includes links that external and internal users can click to return to the specific pages that they were viewing.

Note. The web server must be configured for email.

See Sending Email Messages.

Click to jump to top of pageClick to jump to parent topicPages Used to View Supplier Performance Metrics

Page Name

Definition Name

Navigation

Usage

View Vendor Shipment Performance - On-Time Performance

WV_PE_METRIC_DTL

  • Internal users: Purchasing, Analyze Procurement, Review Supplier Performance

    Select a setID, the appropriate metric, and vendor.

  • External users: Click the Detail link on the appropriate pagelet.

Track the percentage and actual number of shipments that are on time, early, and late for all items within the period.

View Vendor Shipment Performance - Quantity Performance

WV_PE_METRIC_DTL

See above.

Track the percentage and actual number of vendor shipments with correct quantities, over-shipment quantities, and under-shipment quantities by period.

View Vendor Shipment Performance - Quality Performance

WV_PE_METRIC_DTL

See above.

Track the percentage and actual number of vendor shipment quantities that are inspected, accepted, rejected, and returned by period.

View Vendor Shipment Performance - PO/Receipt Qty Performance

WV_PE_METRIC_DTL

See above.

Track the percentage and actual number of vendor shipment quantities that are inspected, accepted, rejected, and returned by period.

View Vendor Shipment Performance - Ship To Details

IN_SSQBALBUNIT_DET

Click a ship to business unit link on the Ship To/Category tab of any performance detail page.

View ship to details.

Email Message

WV_PE_EMAIL

Click the Send Email link on any performance detail page.

Send an email from within the detail page about the data that you or the supplier are reviewing.

Click to jump to top of pageClick to jump to parent topicViewing On-Time Performance Details

Access the View Vendor Shipment Performance - On-Time Performance page (internal users - Purchasing, Analyze Procurement, Review Supplier Performance; external users - click the Detail link on the appropriate pagelet).

The system displays on-time performance summary information. This table displays the equations that the system uses to derive this page's metric fields:

Metric Name

Equation Used to Derive Metric

% On Time

Depending on the early/late metric display setting that you select, the number of receipts minus early ships minus late ships divided by:

The total number of receipts.

The total receipt quantity.

% Early

Depending on the early/late metric display setting that you select, the early ships divided by:

The total number of receipts.

The total receipt quantity.

% Late

Depending on the early/late metric display setting that you select, the late ships divided by:

The total number of receipts.

The total receipt quantity.

 

These columns appear when you select Early/Late Metrics by Receipts when setting system-wide or vendor-specific targets and tolerances.

Number of Receipts

Total number of receipts for a specific item and vendor for a period (includes all items).

Early Ships

Number of receipts (by period) that are marked as received early.

Note. A receipt is marked early when the receipt date from the receipt header is less than the due date from the PO schedule, minus the reject days from PURCH_ITEM_ATTRIB.

Technically the system updates the PS_RECV_LN_SHIP.SHIP_DATE_STATUS field with the value 2.

Late Ships

Number of receipts (by period) that are marked as received late.

Note. A receipt is marked late when the receipt date from the receipt header is greater than the due date from the PO schedule, plus the reject days from PURCH_ITEM_ATTRIB.

Technically the system updates the PS_RECV_LN_SHIP.SHIP_DATE_STATUS field with the value 3.

 

These columns appear when you select Early/Late Metrics by Quantity when setting system-wide or vendor-specific targets and tolerances:

Receipt Quantity

Total quantity received for a specific item and vendor for a period (includes all items).

Qty Early

Quantity received (by period) that is marked as received early.

Note. A receipt is marked early when the receipt date from the receipt header is less than the due date from the PO schedule, minus the reject days from PURCH_ITEM_ATTRIB.

Technically the system updates the PS_RECV_LN_SHIP.SHIP_DATE_STATUS field with the value 2.

Qty Late

Quantity received (by period) that is marked as received late.

Note. A receipt is marked late when the receipt date from the receipt header is greater than the due date from the PO schedule, plus the reject days from PURCH_ITEM_ATTRIB.

Technically the system updates the PS_RECV_LN_SHIP.SHIP_DATE_STATUS field with the value 3.

See Also

Viewing On-Time Performance Details

Common Elements Used in This Section

Click to jump to top of pageClick to jump to parent topicViewing Quantity Performance Details

Access the View Vendor Shipment Performance - Quantity Performance detail page (internal users - Purchasing, Analyze Procurement, Review Supplier Performance; external users - click the Detail link on the appropriate pagelet).

The system displays quantity performance summary information. This table displays the equations that the system uses to derive this page's metric fields:

Metric Name

Equation Used to Derive Metric

% Correct

Number of receipts minus overships minus underships divided by number of receipts.

% Over

Overships divided by number of receipts.

% Under

Underships divided by number of receipts.

Number of Receipts

Total number of receipts for a specific item and vendor for a period (includes all items).

Over Ships

Number of receipts (by period) that are marked as over-received.

Note. A receipt is marked over-received when the total quantity that is received for the PO schedule is greater than the PO quantity plus the receipt tolerance percent from PO_LINE_SHIP (obtained by default from PURCH_ITEM_BU or PURCH_ITEM_ATTRIB). Technically the system updates the PS_RECV_LN_SHIP.SHIP_QTY_STATUS field with the value 2.

Under Ships

Number of receipts (by period) marked as under-received.

Note. A receipt is marked as under-received when the total quantity that is received for the PO schedule is less than the PO quantity minus the receipt tolerance percent from PO_LINE_SHIP (obtained by default from PURCH_ITEM_BU or PURCH_ITEM_ATTRIB.) Technically the system updates the PS_RECV_LN_SHIP.SHIP_QTY_STATUS field with the value 3.

See Also

Viewing Quantity Performance Details

Common Elements Used in This Section

Click to jump to top of pageClick to jump to parent topicViewing Quality Performance Details

Access the View Vendor Shipment Performance - Quality Performance page (internal users - Purchasing, Analyze Procurement, Review Supplier Performance; external users - click the Detail link on the appropriate pagelet).

The system displays quality performance summary information. This table displays the equations that the system uses to derive this page's metric fields:

Metric Name

Equation Used to Derive Metric

% Reject

Rejected quantity divided by receipt quantity.

% Return

Returned quantity divided by receipt quantity.

% Net Received

Receipt quantity minus rejected quantity minus returned quantity divided by receipt quantity.

% Defective

Rejected and returned quantities that you tag to be included in the quality metric (on the Return/Reject Reasons page in the Procurement Options menu).

Receipt Quantity

Sum of quantity that is received for all receipts for a specific item and vendor combination within a period.

Rejected Quantity

Sum of quantity that is rejected for all receipts for a specific item and vendor combination within a period.

Returned Quantity

Sum of quantity that is returned for all receipts for a specific item and vendor combination within a period.

Net Received Quantity

Receipt quantity minus rejected quantity minus returned quantity. This is a derived field and is not stored on any table within the system: it is available through the WV_PRCR_AAA_VW view.

Quantity Defective

Sum of rejected and returned quantities that you tag to be included in the quality metric (on the Return/Reject Reasons page in the Procurement Options menu).

Note. You can control at the setID level which return or reject reason codes are included in these equations.

See Also

Viewing Quality Performance Details

Common Elements Used in This Section

Click to jump to top of pageClick to jump to parent topicViewing PO Versus Receipt Performance

Access the View Vendor Shipment Performance - PO/Receipt Quantity Performance Detail page (internal users - Purchasing, Analyze Procurement, Review Supplier Performance; external users - click the Detail link on the appropriate pagelet).

The system displays quantity performance summary information based on the difference between the PO schedule quantities and the actual receipt quantities. This table displays the equations that the system uses to derive this page's metric fields:

Metric Name

Equation Used to Derive Metric

% Received

QTY_PO (quantity ordered) minus QTY_OPEN (quantity open), divided by QTY_PO-derived from the PRCR_ITEM_HST table.

PO Quantity

Quantity ordered (as shown on the PO schedules) for x period in the graph and x item (on PRCR_ITEM_HST). The particular period that shows the ordered quantity is based on the PO schedule due date.

Open Quantity

This is the nonreceived quantity of the ordered quantity that is stored on PRCR_ITEM_HST and is determined regardless of when the receipts were made. In other words, it was the quantity received or not. Therefore a PO schedule for 100 could be due in June, and there are receipts in July for 25 and August for 25. The PRCR_ITEM_HST table should show a line for June with a QTY_PO of 100 and QTY_OPEN of 50.

See Also

Viewing PO Versus Receipt Performance

Common Elements Used in This Section