Setting up Tolerances for Purchase Invoice Matching
They are set up using Miscellaneous Permissions in the Security. The current business unit is searched first to find any tolerance settings. If none are set, the Miscellaneous Permissions form is searched to find the default business unit (that is, the business unit that does not have a business unit code) and uses these tolerance settings.
Tolerances can be applied to help match lines which are not identical, but are within the tolerances defined. There are three types of tolerance as explained in the examples below:
Quantity Percentage Tolerance
- Quantity Percentage Tolerance set = 10
- Purchase order quantity = 100
- Therefore, the acceptable range = 90 - 110
If the purchase invoice is raised for a quantity of 95 or 105, the order and invoice are matched.
If the purchase invoice is raised for a quantity of 80 or 120, the order and invoice are not matched.
Value Percentage Tolerance
- Value Percentage Tolerance set = 10
- Purchase order value = 100
- Therefore, the acceptable range = 90 - 110
If the purchase invoice is raised for a value of 95 or 105, the order and invoice are matched.
If the purchase invoice is raised for a value of 80 or 120, the order and invoice are not matched.
Absolute Value Tolerance
- Value Tolerance set = 30
- Purchase order value = 200
- Therefore, the acceptable range = 170 - 230
If the purchase invoice is raised for a value of 180 or 220, the order and invoice are matched.
If the purchase invoice is raised for a value of 150 or 260, the order and invoice are not matched.