Scenario
When a Purchase Order is saved with 0.00 Rate and Amount, and which is subsequently billed, and an unexpected error will be encountered if 3 Way Match for Vendor Bills is turned on. Despite the unexpected error, the Bill would still be saved.
Steps to follow
- Create a purchase Order using subsidiary and vendor that was modified
- Make sure the item in the purchase order has Rate = 0.00 and Amount = 0.00
- Bill the purchase order
- Change the Rate to a value greater than 0.00 (also in the amount column)
- Save the bill
Actual Result: is an unexpected error will be occurred, But
Expected Result: is no error and vendor bill status showing as Pending Approval.
Solution:
- Either the tolerance was set to zero or any positive amount, if the Purchase Order transaction total is equal to 0.00 but the Bill transaction total is higher that the Purchase Order amount, an error will be encountered but the Bill will still be saved.
- Either the tolerance was set to zero or any positive amount., if the Purchase Order transaction total is equals to 10.00 or any number higher than 0.00 and the Bill transaction total is higher that the Purchase Order amount, no error will be encountered, and the Bill will be saved as well.
- A Suite Script error can be avoided in billing the Purchase Order if a Purchase Order total is not equal to 0.00. If the Vendor Bill Tolerance is equals to 0 but the Purchase Order total is greater than 0.00, there will be no issue in billing the Purchase Order even if the Bill and Purchase Order has a different transaction total. It will also be routed to the Next Approver.