The Supplier Service Performance Analysis Report lists late shipments, early shipments, rejected shipments, and shipments to wrong locations. You can use this report to derive a supplier service penalty by multiplying the days variance quantity by a percentage of the price.
The % Open Current is the percentage of the ordered quantity not yet received, but within the receipt tolerance days or not past due.
The % Open Past Due is the percentage of the ordered quantity not received by the promise date and beyond the receipt tolerance days.
The % Received On Time is the percentage of the ordered quantity received on the promise date or within the receipt tolerance days.
The % Received Late is the percentage of the ordered quantity received after the promise date and outside the receipt tolerance days.
The % Received Early is the percentage of the ordered quantity received before the promise date and outside the receipt tolerance days.
The Days Variance is calculated as the summation of the date differential (transaction date subtracted from promise date) multiplied by the corrected received quantity (the received quantity plus or minus corrections) for each shipment, all divided by the total corrected received quantity. The result is the quantity per day the supplier is in variance.
In the Submit Requests window, select Supplier Service Performance Analysis Report in the Name field.
Enter the beginning and ending item numbers.
Enter the beginning and ending supplier names.
Enter the beginning and ending purchasing categories.
Enter a buyer name to restrict the report to a specific buyer.
Enter the beginning and ending creation dates.
Enter Yes or No to indicate whether you want to print detail information for each purchase order on the report.
Enter the decimal precision for quantities on the report.