Here are some sample setup and scenarios to help us visualize the difference of Tolerance and Difference Variance:
- Setup the following in Vendor record:
- VENDOR BILL - PURCHASE ORDER QUANTITY TOLERANCE = 0.1
- VENDOR BILL - PURCHASE ORDER AMOUNT TOLERANCE = 0.1
- VENDOR BILL - PURCHASE ORDER QUANTITY DIFFERENCE = 5
- VENDOR BILL - ITEM RECEIPT QUANTITY TOLERANCE = 0.1
- VENDOR BILL - ITEM RECEIPT AMOUNT TOLERANCE = 0.1
- VENDOR BILL - ITEM RECEIPT QUANTITY DIFFERENCE = 5
SCENARIO 1:
- Create PO
- Item A | Qty = 50 | Rate = 15 | Total = 750
- Create Item Receipt
- Receive all 50 quantities.
- Bill PO.
- Qty = Change from 50 to 55 | Amount is still 750
- Status of bill - OPEN
- Reason: The VB-PO QTY Tolerance set is 0.1 (10%). On this case, the difference between QTY of PO and Bill is 5 (55-50). Thus, it meets the 10% tolerance, resulting to the bill being OPEN and not Pending Approval.
SCENARIO 2:
- Create PO
- Item A | Qty = 50 | Rate = 15 | Total = 750
- Create Item Receipt
- Receive all 50 quantities.
- Bill PO.
- Qty = 50 | Change amount from 750 to 900
- Status of bill - PENDING APPROVAL
- Bill Exception button available - Reason: Discrepancy between the Amount on Bill and PO exceeds the Vendor Amount Tolerance limit
- Explanation: The amount change (750 to 900) is 20%, which is more than the tolerance limit set.
- Setup the following in Vendor record:
- VENDOR BILL - PURCHASE ORDER QUANTITY TOLERANCE = 0.1
- VENDOR BILL - PURCHASE ORDER AMOUNT TOLERANCE = 0.1
- VENDOR BILL - PURCHASE ORDER QUANTITY DIFFERENCE = 6
- VENDOR BILL - ITEM RECEIPT QUANTITY TOLERANCE = 0.1
- VENDOR BILL - ITEM RECEIPT AMOUNT TOLERANCE = 0.1
- VENDOR BILL - ITEM RECEIPT QUANTITY DIFFERENCE = 6
SCENARIO 3:
- Create PO
- Item A | Qty = 50 | Rate = 15 | Total = 750
- Create Item Receipt
- Receive all 50 quantities.
- Bill PO.
- Qty = Change from 50 to 56 | Amount is still 750
- Status of bill - PENDING APPROVAL
- Bill Exception button available - Reason: Discrepancy between the Quantity on Bill and PO exceeds the Vendor Quantity Tolerance limit
I hope this helps! ❤ Feel free to share your own tips and tricks under NetSuite Admin Corner to help other members as well. Thank you very much! 😊