Matching tolerance
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
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). |
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. |