Delivered Match Rules

PeopleSoft delivers match rules that most organizations need. Use the match rule set that best meets your organization's requirements. You can also create new match rules or modify delivered match rules.

Match rules are applied at either the header summary level or the line summary level. Define what level to apply the match rule on the Match Rules - Rule Definition page.

System Match Rules

System errors indicate that data is missing and prevents the system from retrieving all of the voucher, purchase order, and receiver data. If no system errors exist, the system applies matching rules.

This table describes the system match rules delivered with the system:

Rule ID	Description	Long Description
RULE_S100	Invalid Match Control ID.	Invalid Match Control ID.
RULE_S110	Credit Adjustment Quantity > PO Matched Quantity.	RTV/Credit Adjustment Quantity is greater than the PO Matched Quantity.
RULE_S111	Credit Adjustment Amount > PO Matched Amount.	RTV/Credit Adjustment Amount is greater than the PO Matched Amount.
RULE_S120	Credit Adjustment Quantity > Receiver Match Qty.	RTV/Credit Adjustment Quantity is greater than the Receiver Matched Quantity.
RULE_S121	Credit Adjustment Amount > Receiver Match Amount.	RTV/Credit Adjustment Amount is greater than the Receiver Matched Amount.
RULE_S122	Credit Adjustment Quantity > Receiver Match Qty.	RTV/Credit Adjustment Quantity is greater than the Receiver Matched Quantity.
RULE_S123	Credit Adjustment Amount > Receiver Match Amount.	RTV/Credit Adjustment Amount is greater than the Receiver Matched Amount.
RULE_S200	Invalid PO ID exists not set for match.	Invalid PO ID exists but not set for matching.
RULE_S201	Invalid Receiver exists but not set for matching.	Invalid Receiver exists but not set for matching.
RULE_S210	Invalid PO Status.	Invalid PO Status.
RULE_S300	Invalid UOM conversion for PO.	Invalid UOM conversion for PO.
RULE_S400	Invalid currency exchange rate for PO.	Invalid currency exchange rate for PO.
RULE_S500	Invalid UOM conversion for Receipt.	Invalid UOM conversion for receipt.
RULE_S600	Invalid currency exchange rate for Receipt.	Invalid currency exchange rate for receipt.
RULE_S700	Invalid Global exchange rate conversion error.	Invalid Global exchange rate conversion error.

Standard Match Rules

PeopleSoft delivers standard match rules that are similar to the match rules delivered in previous releases.

This table describes the standard match rules delivered with the system:

Rule ID	Description	Long Description
RULE_E100	Extended Price Tolerance.	The voucher extended price exceeds the purchase order extended price plus or minus (+/-) the extended price tolerance, and the tolerance is not equal to (<>) 0.
RULE_E200	Extended Price % Tolerance.	The voucher extended price exceeds the purchase order extended price plus or minus the extended price percentage tolerance, and the tolerance does not equal 0.
RULE_E250	Voucher Ext Amt <> PO Ext Amt (No Tolerances).	The voucher extended price does not equal the purchase order extended price when the extended percentage and price tolerances are 0.
RULE_H100	Voucher Pay Terms <> PO Pay Terms.	The payment terms code on the purchase order does not equal the payment terms code on the voucher.
RULE_H200	Voucher Supplier/Loc<>PO Supplier/Loc.	The supplier on the purchase order does not equal the supplier on the voucher.
RULE_H400	Voucher Supplier/Loc<>Receiver Supplier/Loc.	The supplier on the voucher does not equal the supplier on the receipt.
RULE_I100	Inspection Required but not Complete.	The item ordered requires inspection but inspection has not been completed.
RULE_L100	Voucher item <> PO item.	The item on the voucher line does not equal the item on the purchase order line.
RULE_L200	Voucher item <> Receiver item.	The item on the voucher line does not equal the item on the receiver line.
RULE_L300	Voucher Packing Slip <> Receiver Packing Slip	The Packing Slip on the voucher line is not equal to the Packing Slip on the receiver line.
RULE_P100	Voucher Unit Price <> PO Unit Price (No Tolerance).	The voucher price does not equal the purchase order price when the unit price percentage and price amount tolerances are 0.
RULE_P400	Voucher Unit Price <> PO Unit Price + % Unit Tol.	The price percentage tolerance does not equal 0, and the voucher price (converted to the purchase order UOM) does not fall within the purchase order price range (calculated using price percentage tolerance). The rule does not generate an exception for an amount-only purchase order and a non-purchase order receipt.
RULE_P500	Voucher Unit Price <> PO Unit Price + Unit Price Tolerance.	The unit price tolerance does not equal 0, and the voucher price does not fall within the purchase order price range (calculated using unit price tolerance).
RULE_R500	No receipts found.	The Matching process could not find any receipts for the purchase order specified on the voucher line that were available for matching (for example not matched, not on hold, and not canceled).
RULE_R600	No receipt found, but unmatched ones exist.	The Matching process found receipts for this purchase order that were available for matching (for example not matched, not on hold, and not canceled) but could not make an association to the voucher line using any of the document association criteria.
RULE_R650	Voucher line amt > Sum of received amount.	Voucher line amt > Sum of associated receiver line amt (Amount Only Matching)
RULE_R651	Voucher line amt > Sum of received amount.	Voucher line amt > Sum of associated receiver line amt (Amount Only Matching).
RULE_R900	Total voucher received quantity > Accepted Qty	The total quantity received (including across all voucher lines and previously matched receivers) exceeds the accepted quantity on the receiver.
RULE_R901	Total voucher received quantity > Accepted Qty.	The total quantity received (including across all voucher lines and previously matched receivers) exceeds the accepted quantity on the receiver.
RULE_R950	Voucher Quantity greater than Assoc. Receipt Qty.	The quantity on the voucher line exceeds the remaining unmatched quantity on the associated receipt(s).
RULE_R951	Voucher Quantity greater than Assoc. Receipt Qty.	The quantity on the voucher line exceeds the remaining unmatched quantity on the associated receipt(s) (non-PO Receipt).
RULE_R960	Invoiced Line Qty <> Sum of Assoc. Receipt Qty.	Voucher line invoiced total quantity is not equal to the sum of all receiver accepted quantities that are associated with this voucher line.
RULE_V200	Life to Date Voucher Qty > PO Qty.	The total quantity vouchered (including previously matched vouchers) exceeds the quantity on the purchase order plus the allowed over-receiving quantity.
RULE_V250	Life to Date Voucher Qty > PO Qty.	The receiving percentage tolerance does not equal 0, and the total quantity vouchered (including previously matched vouchers) exceeds the quantity on the purchase order plus the allowed over-receiving quantity.
RULE_V300	Life to Date Voucher Amount > PO Amount.	The receiving tolerance is 0 and the total quantity vouchered (including previously matched vouchers) exceeds the quantity on the purchase order. An exception is not generated for an amount-only purchase order or non-purchase order receipt.
RULE_V400	Life to Date > Sched Amt + % ext tol.	The extended price percentage tolerance is not 0, and the total amount vouchered (including amounts on previously matched vouchers) exceeds the purchase order amount (calculated using extended price percentage tolerance).
RULE_V500	Life to Date > Sched Amt + ext amt tol.	The extended price tolerance is not 0, and the total amount vouchered (including amounts on previously matched vouchers) exceeds the purchase order amount (calculated using extended price tolerance).

Merchandise Match Rules

Merchandise match rules verify that the organization receives the goods or services and that the price matches the price on the purchase order.

This table describes the merchandise match rules delivered with the system:

Rule ID	Description	Long Description
200	Merch amt = PO merch amt with rule amt tol.	Compare the total voucher merchandise amount (gross amount less miscellaneous charges and tax) to the total merchandise amount on the POs less any previously matched amounts. Include amount tolerances from the rule, if any, when comparing the amounts.
210	Merch amount = PO merch amt with rule % tol.	Compare the total voucher merchandise amount (gross amount less miscellaneous charges and tax) to the total merchandise amount on the POs less any previously matched amounts. Include percent tolerance from the rule.
220	Merch amount = recv merch amt with rule amt tol.	Compare the total voucher merchandise amount (gross amount less miscellaneous charges and tax) to the total merchandise amount on the receipts less any previously matched amounts. Include amount tolerances from the rule, if any, when comparing the amounts.
221	Merch amt = non PO recv merch amt w rule amt tol.	For non PO receipts, compare the total voucher merchandise amount (gross amount less miscellaneous charges and tax) to the total merchandise amount on the non PO receipts less any previously matched amounts. Include amount tolerances from the rule, if any, when comparing the amounts.
230	Merch amount = recv merch amt with rule % tol.	Compare the total voucher merchandise amount (gross amount less miscellaneous charges and tax) to the total merchandise amount on the receipts less any previously matched amounts. Include percent tolerances from the rule, if any, when comparing the amounts.
231	Merch amt = non PO recv merch amt w rule % tol.	For non PO receipts, compare the total voucher merchandise amount (gross amount less miscellaneous charges and tax) to the total merchandise amount on the non PO receipts less any previously matched amounts. Include percent tolerances from the rule, if any, when comparing the amounts.
240	Merch amount not = PO merch amt with rule amt tol.	Compare the total voucher merchandise amount (gross amount less miscellaneous charges and tax) to the total merchandise amount on the POs. Include amount tolerance from the rule and create an exception when the difference exceeds the tolerance.
250	Line amount not = PO line amt with PO amt tol.	Compare the voucher line amount to the PO line schedule amount less any previously matched amounts. Include amount tolerances from the PO, if any, when comparing the amounts.
260	Line amount not = PO line amt with PO % tol.	Compare the voucher line amount to the PO line schedule amount less any previously matched amounts. Include percent tolerances from the PO, if any, when comparing the amounts.
270	Line amount not = recv line amt with PO amt tol.	Compare the voucher line amount to the receipt line amount less any previously matched amounts. Include amount tolerances from the PO, if any, when comparing the amounts.
280	Line amount not = recv line amt with PO % tol.	Compare the voucher line amount to the receipt line amount less any previously matched amounts. Include percent tolerances from the PO, if any, when comparing the amounts.
290	Line amount not = PO line amt with rule amt tol.	Compare the voucher line amount to the PO line schedule amount less any previously matched amounts. Include amount tolerances from the rule, if any, when comparing the amounts.
300	Line amount not = PO line amt with rule % tol.	Compare the voucher line amount to the PO line schedule amount less any previously matched amounts. Include amount tolerances from the rule, if any, when comparing the amounts.
310	Line amount not = recv line amt with rule amt tol.	Compare the voucher line amount to the receipt line amount less any previously matched amounts. Include amount tolerances from the rule, if any, when comparing the amounts.
311	Line amt not = non PO recv line amt w rule amt tol.	For non PO receipts, compare the voucher line amount to the non PO receipt line amount less any previously matched amounts. Include amount tolerances from the rule, if any, when comparing the amounts.
320	Line amount not = recv line amt with rule % tol.	Compare the voucher line amount to the receipt line amount less any previously matched amounts. Include percent tolerances from the rule, if any, when comparing the amounts.
321	Line amt not = non PO rec line amt with rule % tol.	For non PO receipts, compare the voucher line amount to the non PO receipt line amount less any previously matched amounts. Include percent tolerances from the rule, if any, when comparing the amounts.
330	LTD vchr qty greater than PO qty with receipt tol.	Current voucher quantity plus previously matched voucher quantities, if any, greater than PO line schedule quantity. Include quantity received percent over, if any, from the PO when comparing the values.
335	LTD vchr qty greater than PO qty with receipt tol.	Current voucher quantity plus previously matched voucher quantities, if any, greater than PO line schedule quantity. Include quantity received percent over, if any, from the PO when comparing the values.
340	LTD vchr amt greater than PO amt with PO amt tol.	Current voucher line amount plus previously matched voucher line amounts, if any, greater than PO line schedule amount. Include amount tolerances from the PO, if any, when comparing the values.
350	LTD vchr amt greater than PO amt with PO % tol.	Current voucher line amount plus previously matched voucher line amounts, if any, greater than PO line schedule amount. Include percent tolerances from the PO, if any, when comparing the values.
380	LTD vchr amt greater than PO amt with rule amt tol.	Current voucher line amount plus previously matched voucher line amounts, if any, greater than PO line schedule amount. Include amount tolerances from the rule, if any, when comparing the values.
390	LTD vchr amt greater than PO amt with rule % tol.	Current voucher line amount plus previously matched voucher line amounts, if any, greater than PO line schedule amount. Include percent tolerances from the rule, if any, when comparing the values.
450	LTD vchr amt greater than recv amt.	Current voucher line amount plus previously matched voucher line amounts, if any, greater than receipt line amount.
470	Line price not = PO price with PO price amt tol.	Compare voucher price with PO price. Include price amount tolerances, if any, from the PO when comparing the values.
480	Line price not = PO price with PO price % tol.	Compare voucher price with PO price. Include price percent tolerances, if any, from the PO when comparing the values.
490	Line price not = PO price + rule amt tol.	Compare voucher price with PO price. Include price amount tolerances, if any, from the rule when comparing the values.
500	Line price not = PO price with rule % tol.	Compare voucher price with PO price. Include price percent tolerances, if any, from the rule when comparing the values.
510	Line price not = receipt price with rule amt tol.	Compare voucher price with receipt price. Include price amount tolerances, if any, from the rule when comparing the values.
520	Line price not = receipt price with rule % tol.	Compare voucher price with receipt price. Include price percent tolerances, if any, from the rule when comparing the values.
550	Line qty not = PO line qty with PO received % tol.	Compare voucher quantity with PO line schedule quantity. Include quantity received percent over, if any, from the PO when comparing the values.
580	Line qty not = recv qty with PO received % tol.	Compare voucher quantity with receipt line quantity. Include quantity received percent over, if any, from the PO when comparing the values.

Nonmerchandise Match Rules

Nonmerchandise match rules verify nonmerchandise data, such as freight, on the purchase order.

Note:

The system assumes that for Match Rule ID 700, Freight not Allowed but Included on Voucher, the freight terms are configured and used properly on the purchase order.

This table describes the nonmerchandise match rules delivered with the system:

Rule ID	Description	Long Description
700	Freight not allowed.	PO freight terms = paid by seller but voucher includes freight cost.
710	Supplier's Financial Sanctions Status.	Check whether Supplier is on a Financial Sanctions Listing.

Data Accuracy Match Rules

Data accuracy match rules verify data entry accuracy. These match rules include comparisons on supplier IDs and item IDs.

This table describes the data accuracy match rules delivered with the system:

Rule ID	Description	Long Description
100	No Receipts Found.	No available receipts (not matched, not on hold, and not canceled) were found for the purchase order specified on the voucher line.
120	Pay terms not = PO pay terms.	The payment terms code on the purchase order does not equal the payment terms code on the voucher.
130	Supplier/Loc not = PO Supplier/Loc.	The supplier or supplier location on the purchase order does not equal the supplier or supplier location on the voucher.
140	Voucher item not = PO item.	The item on the voucher line does not equal the item on the purchase order line.
150	Inspection required but not completed.	The item ordered requires inspection but inspection has not been completed.
160	Supplier/Loc not = Receiver Supplier/Loc.	The supplier or supplier location the voucher does not equal the supplier or supplier location on the receipt.
170	Voucher item not = receiver item.	The item on the voucher line does not equal the item on the receiver line.

Organization Limits and Global Tolerances Match Rules

The organization limits match rules applies tolerances to successfully match exceptions.

Note:

To successfully match vouchers based on organization limits, match rules 800, 810, or 811 should follow system rules in the rule order of the match rule control.

This table describes the organization limits and global tolerances match rules delivered with the system:

Rule ID	Description	Long Description
800	Small dollar purchase; match automatically.	For small amount purchases, automatically match the voucher.
810	Cost exception less than minimum rule tol.	Ignore exceptions when the exception amount is less than the cost of processing the exception.
811	Cost exception less than min rule tol non PO recv.	For non PO receipts, ignore exceptions when the exception amount is less than the cost of processing the exception.
820	Global Amount Tolerance.	Match when voucher line amount greater than or equal to PO line amount - rule under amount and less than or equal to PO line amount + rule over amount.
830	Global Percent Tolerance.	Match when voucher line amount greater than or equal to PO line amount - rule under % and less than or equal to PO line amount + rule over %.