Use this function to set up and maintain tolerances for the three-way matching.
Use the tolerance codes to define the degree to which the quantity of purchased products, the cost of products and the delivery date can deviate from the purchase order, receipts and purchase invoices. The tolerance codes also determine the action that results from a failure that falls outside the specified allowances; warning or blocking.

The tolerance code can be assigned to Supplier, Product and Supplier/Product combination and it is defaulted into purchase order line. The hierarchy of where the tolerance code is defaulted into purchase order line from is:

1. Supplier/Product combination

2. Product

3. Supplier

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

This function contains two tabs: 

  • You use the Receipts tab to set up tolerances for receipts.
  • You use the Invoices tab to set up tolerances for invoices.

Header

A matching tolerance code field is five character alphanumeric field.
The Unit of measure field determines in which unit the tolerance quantity is expressed.
The Currency field specifies in which currency the tolerance amount is expressed.

Matching tolerance (field MATTOL)

Single code identifying the matching tolerance. This code can contain up to five signs.

Description (field TOLDESAXX)
Unit of measure (field TOLUOM)

Unit of measure used during the Three-way match process. If the unit of measure of the receipt line or purchase invoice is different from the Three-way match unit, the quantity is converted before the comparison is made. If the conversion of this unit of measure does not exist in the product record or Unit conversions function, the 'Not unit conversion' message is displayed at the match status level.

Currency (field TOLCUR)

Currency used for the Three-way match (reconciliation of the purchase price or the total amount).
If the receipt line currency or invoice currency is different from the Three-way match currency, the amount is converted before the comparison is made. If no currency conversion exists between the receipt/invoice currency and the Three-way match currency, the message "No currency conversion" is displayed in the match status.

Tab Receipts

Use this tab to set up tolerances for receipts.

Quantity shortage / exceeded: When the Control check box is selected, the receipt quantity is compared to the ordered quantity. When the difference is more than the threshold, whatever the action selected, either warning or blocking, should be displayed.

Early / Late receipt: When the Control check box is selected, the actual receipt date is compared to the expected receipt date. When the difference is more than the threshold, whatever the action selected, either warning or blocking, should be displayed.

Quantity shortage

Control (field QSCTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Percentage (field QSPER)

Specify a percentage that the matched document must not go below when compared to the receiving quantity on a purchase order to still be accepted for processing

Quantity (field QSQTY)

Specify a quantity that the matched document must not go below when receiving quantities related to a specific purchase order line to be accepted for matching

field QSUOM
Action (field QSACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Quantity exceeded

Control (field QECTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Percentage (field QEPER)

Specify a percentage that the matched document cannot exceed when compared to the receiving quantities related to a specific purchase order line to still be accepted for processing

Quantity (field QEQTY)

Specify a quantity that the matched document cannot exceed when receiving quantities related to a specific purchase order line to be accepted for matching

field QEUOM
Action (field QEACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Early receipt

Control (field ERCTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Days (field ERDAYS)

Specify the maximum number of days before the expected receipt date that the shipment can be received. If the shipment date is within the date range specified, it passes the matching process.

Action (field ERACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Late receipt

Control (field LRCTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Days (field LRDAYS)

Specify the maximum number of days after the expected receipt date that the shipment can be received. If the shipment date is within the date range specified, it passes the matching process.

Action (field LRACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Tab Invoices

Use this tab to set up tolerances for purchase Invoices.

Quantity shortage / exceeded: When the Control check box is selected, the receipt quantity is compared to the ordered quantity. When the difference is more than the threshold, whatever the action selected, either warning or blocking, should be displayed.

Under / Over invoice unit: When the Control check box is selected, the invoice purchase price is compared to the order purchase price. When the difference is more than the threshold, whatever the action selected, either warning or blocking, should be displayed.

Under / Over invoice ext amt: When the Control check box is selected, the invoice line total amount is compared to the order line total amount. When the difference is more than the threshold, whatever the action selected, either warning or blocking, should be displayed.

Quantity shortage

Control (field IQSCTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Percentage (field IQSPER)

Specify a percentage that the matched document must not go below when invoice quantity is compared to the receipt quantity or the receiving quantity on a purchase order to still be accepted for processing

Quantity (field IQSQTY)

Specify a quantity that the matched document must not go below when invoice quantity is compared to the receipt quantity or the receiving quantity on a purchase order to still be accepted for processing.

field IQSUOM
Action (field IQSACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Quantity exceeded

Control (field IQECTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Percentage (field IQEPER)

Specify a percentage that the matched document cannot exceed when invoice quantity is compared to the receipt quantity or the receiving quantity on a purchase order to still be accepted for processing

Quantity (field IQEQTY)

Specify a quantity that the matched document cannot exceed when invoice quantity is compared to the receipt quantity or the receiving quantity on a purchase order to still be accepted for processing

field IQEUOM
Action (field IQEACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Under invoice unit

Control (field UIUCTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Percentage (field UIUPER)

Specify a percentage that the matched document must not go below when compared to the unit cost on a purchase order line to still be accepted for matching

Amount (field UIUAMT)

Specify an amount that the matched document must not go below when compared to the unit cost on a purchase order line to still be accepted for matching

field UIUCUR
Action (field UIUACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Over invoice unit

Control (field OIUCTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Percentage (field OIUPER)

Specify a percentage that the matched document cannot exceed when compared to the unit cost on a purchase order line to still be accepted for matching

Amount (field OIUAMT)

Specify an amount that the matched document cannot exceed when compared to the unit cost on a purchase order line to still be accepted for matching

field OIUCUR
Action (field OIUACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Under invoice extended amount

Control (field UILCTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Percentage (field UILPER)

Specify a percentage that the matched document must not go below when compared to the purchase order extended line amount to still be accepted for matching

Amount (field UILAMT)

Specify an amount that the matched document must not go below when compared to the purchase order extended line amount to still be accepted for matching

field UILCUR
Action (field UILACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Over invoice extended amount

Control (field OILCTL)

Select this check box to enable Percent and Quantity / Amount field to specify threshold that the matched document can exceed when performing three way matching.

Percentage (field OILPER)

Specify a percentage that the matched document cannot exceed when compared to the purchase order extended line amount to still be accepted for matching

Amount (field OILAMT)

Specify an amount that the matched document cannot exceed when compared to the purchase order extended line amount to still be accepted for matching

field OILCUR
Action (field OILACT)

Select the action to take when the variance exceeds the specified tolerance. Select Warning to display a warning, but proceed with processing. Select Blocking to to display an error and stop the processing. Blocking can be overridden in Purhcase Invoices with appropriate security, but it cannot be overrided in Receipts.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation