Calculate Vendor Rating Batch Job

The Calculate Vendor Rating batch job calculates a score for the hard criteria of each receipt or return shipment line. The batch job is accessed using Tell Me. Choose the Lightbulb that opens the Tell Me feature icon, enter Calculate Vendor Rating, and then choose the related link.

The fields on the Options FastTab are described in the following table.

Option	Description
100 Points for missing QC Rating	Assigns the full score if there is no other information about the quality rating. This is useful if a quality rating is only to be processed for deficient purchase receipts/return shipments.
Partial Receipt Quantity Rating	Determines if the quantity rating will be calculated based on the quantity of each individual purchase receipt line, which enables the rating of partial deliveries (toggle on), or based on the total received quantity of the purchase order line after there is no outstanding quantity remaining (toggle off). For more information, see Rating of Quantity Variations at Delivery. This field can be set by default in the Vendor Rating Setup page.
Recalculate Vendor Rating Entries	Recalculates historically calculated rating entries. This might be useful if configurations of parameters or other vendor rating-specific settings have been changed. Otherwise, the history will not use new settings and only the calculation of new entries will be based on the new settings.

Note

This batch job does not automatically process a re-classification of the vendor. Therefore, the Vendor Rating report must be executed (see Vendor Rating Batch Job).

The rating of the due date, received quantity, returns and quality criteria that have been automatically created by the batch job per purchase/return shipment line are transferred to the Vendor Rating Entries page.

In the Vendor Rating Entries page, a total score is calculated per purchase/return shipment line. This score is calculated by the multiplication of the individually ascertained scores for appointed time, quantity and quality.

For example, the following scores are generated and used to calculate the total score:

Quality Score	Appointed Time Score	Quantity Score	Total Score		Total Score Calculation
60	100	100	60		0.6 x 1.0 x 1.0 = 0.60

The vendor rating only considers the purchase lines that have the Duty of Rating check box selected and the return shipment lines with the Return Reason Code field populated.

If a Posted Purchase Receipt/Posted Return Shipment line is cancelled using the Undo Receipt/Undo Return Shipment function, a negative purchase receipt/return shipment line is created. The Correction check box is selected on the original line and the negative purchase receipt/return shipment line has no effect on the vendor rating. The Calculate Vendor Rating batch job deletes existing Vendor Rating Entries for purchase receipt/return shipment lines that have the Correction check box selected.

Promised Receipt Date Rating

In this rating, the Arrival Date and Promised Receipt Date fields are compared. If the arrival date differs from the promised receipt date, the allocated score is based on the scores from the master data depending on the calculated schedule variance.

Rating of Quantity Variations at Delivery

A quantity rating will only be processed if an outstanding receipt is to be posted. The scores in this rating are allocated based on the Vendor Rating Parameter Quantity.

Quantity ratings can be calculated based on the quantity of the purchase receipt line (partial receipts) or the purchase order line (overall quantity variation). Using either method, the Assert Purchase Order Quantity field in the purchase line is compared to the actual delivered quantity (Quantity field) to calculate the rating.

Overall Quantity Variation Rating

When a quantity rating is calculation based on the purchase order line, then the overall variation between the expected quantity and delivered quantity is rated.

If the delivered quantity differs from the value in the Assert Purchase Order Quantity field, the Quantity in the purchase line must be adjusted. Therefore, a quantity variance is recognized even over several partial receipts.

This method is determined by turning off the Partial Receipt Quantity Rating toggle in the Calculate Vendor Rating batch job.

Partial Receipt Quantity Rating

When a quantity rating is calculated based on the purchase receipt line, then the partial deliveries are rated individually.

If the delivered quantity differs from the value in the Assert Purchase Order Quantity field, the quantity variance is based on each partial receipt and is the summarized quantity of all deliveries up to the arrival date of the individual posting.

This method is determined by turning on the Partial Receipt Quantity Rating toggle in the Calculate Vendor Rating batch job.

Example

An item is added to a purchase order for a quantity of 500 with an expected receipt date of January 30st. Partial receipts are received as follows:

Receipt Date	Quantity	Over-Receipt Quantity
January 26th	100
January 29th	300
January 30th	100	50

When the Calculate Vendor Rating function is run, the 100 Points for missing QC Rating and Partial Receipt Quantity Rating toggles are turned on and then the Vendor Rating function is run. The rating results for the partial receipts are:

Arrival Date	Quantity (Base)	Appointed Time Score	Quality Score	Quantity Score	Return Score	Total Score
January 26th	100	92	100	10	100	9
January 29th	300	99	100	70	100	69
January 30th	150	100	100	95	100	95

The rating deviation is visible in the Appointed Time Score and Quantity Score. Both scores rise as the partial receipts get closer to the expected receipt date, with the Appointed Time Score set to 100 on the final receipt because it meets the expected date. However, the Quantity Score for the last receipt is set to 95 instead of 100 because it is impacted by the Over-Receipt Quantity of 50.

Quality Rating

For further information about the quality rating, see Quality Rating for Purchase Receipt Line.

Feedback

Submit feedback for this page .