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 Invoicestab to set up tolerances for invoices.
Header
Presentation
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.
Close
Fields
The following fields are present on this tab :
| Single code identifying the matching tolerance. This code can contain up to five signs. |
|
|
| 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 used for the Three-way match (reconciliation of the purchase price or the total amount). |
Close
Tab Receipts
Presentation
Use this tab to set up tolerances for receipts.
Quantity shortage / exceeded: When the Controlcheck 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 Controlcheck 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.
Close
Fields
The following fields are present on this tab :
Quantity shortage
| 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. |
| 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 |
| 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 |
|
| 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
| 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. |
| 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 |
| Specify a quantity that the matched document cannot exceed when receiving quantities related to a specific purchase order line to be accepted for matching |
|
| 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
| 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. |
| 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. |
| 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
| 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. |
| 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. |
| 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. |
Close
Tab Invoices
Presentation
Use this tab to set up tolerances for purchase Invoices.
Quantity shortage / exceeded: When the Controlcheck 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 Controlcheck 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.
Fields
The following fields are present on this tab :
Quantity shortage
| 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. |
| 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 |
| 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. |
|
| 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
| 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. |
| 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 |
| 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 |
|
| 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
| 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. |
| 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 |
| 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 |
|
| 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
| 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. |
| 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 |
| 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 |
|
| 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
| 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. |
| 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 |
| 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 |
|
| 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
| 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. |
| Specify a percentage that the matched document cannot exceed when compared to the purchase order extended line amount to still be accepted for matching |
| Specify an amount that the matched document cannot exceed when compared to the purchase order extended line amount to still be accepted for matching |
|
| 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. |