ANS-1500 · PURCHASE & VENDOR MANAGEMENT
Understanding Vendor Bill Matching Tolerances and Differences in NetSuite
NetSuite's Vendor Bill Matching feature utilizes both percentage-based tolerances and absolute value differences to automatically flag discrepancies between item receipts and vendor bills.
Short answer
NetSuite's Vendor Bill Matching section uses 'Tolerance' (a percentage difference) and 'Difference' (an absolute value). Tolerance flags bills if the item receipt amount exceeds a set percentage of the total order. Difference flags bills if the item receipt quantity deviates by more than a specified number of items. Both settings cause the bill to appear in the Post Vendor Bill Variance Screen.
Scenario
Users often seek to understand the specific functions of the 'Tolerance' and 'Difference' fields within the Vendor Bill Matching section on an item's Purchasing/Inventory subtab. Clarifying these settings is crucial for managing discrepancies between item receipts and vendor bills effectively.
Solution
The Vendor Bill Matching section on an item's Purchasing/Inventory subtab defines how variances between item receipts and vendor bills are handled using two key settings: Tolerance and Difference.
Tolerance:
The tolerance is a percentage difference of the item.
Ex. If tolerance is 10%, an item receipt of greater than 10 or less than 10 on a total order amount of 100 will automatically trigger the bill to appear in the Post Vendor Bill Variance Screen.
Difference:
The difference is an absolute value of the item.
Ex. If difference is 5. An item receipt of greater than 5 items + or minus, will trigger the bill to appear in the Post Vendor Bill Variance Screen.
Expert NetSuite Support
Need help with this NetSuite issue?
Purchase & Vendor Management consulting and configuration support