Rounding Rules for AP Invoices to avoid penny difference — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Rounding Rules for AP Invoices to avoid penny difference

edited Jul 14, 2023 11:50AM in Payables, Payments & Cash Management 4 comments

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:

  1. Invoice Header value: 37.68
  2. Invoice Line Value: 31.41
  3. Tax created at 20% on line, value = 6.282
  4. Standard Tax Amount: 6.28
  5. 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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!