Rounding Rules for AP Invoices to avoid penny difference
Summary:
Rounding Rules for AP Invoices to avoid penny difference
Content (required):
Hi - I previously asked a similar question here: Invoices - Line variance hold due to 0.01 differences
My question is about this scenario, where invoices are generated like this:
- Invoice Header value: 37.68
- Invoice Line Value: 31.41
- Tax created at 20% on line, value = 6.282
- Standard Tax Amount: 6.28
- Line Value + Tax Value = 31.41 + 6.28 = 37.69
Because the Line Value + Tax Value is 0.01 greater than the Invoice Amount, a Line variance hold is placed against the invoice.
Via the ticket mentioned above, the issue could in theory be resolved by adding a value of 6.7 in the Control Amount on the Invoice Line or instead, in the Control Amount field in the Tax tab on the Invoice Header.