We have a currency invoice for 481.29 USD @ 1.4000, which has 3 lines, each for 160.43 USD. Clearly this totals fine in USD, but when the invoice is posted the result is “Sum of the lines isn’t equal to the total value.”
Switching to GBP in AP Invoice Entry, it does show a Rounding value of 0.01. (The invoice total is 343.78 GBP but the line amounts are 343.77 - from 3 * 114.593).
So far we have tried:
Book Maintenance - Posting/Rounding Difference Tolerance
The GL Control for AP Account/APDEF has a GL Account for the Rounding Difference context
This is a new Epicor system, so it’s bound to be something obvious …
The problem here is that the system did the math of the line items to the total FIRST, and then rounded all the values. This does turn into a currency rounding issue. I believe that this is why we have special GL accounts to resolve any rounding differences.
That said, I agree, that there may be a problem here that Tech Support may have a resolution for. it does not seem reasonable to have an invoice that doesn’t add up.
@joji - thanks, we are on 10.1.500.9, that seems possible.
@timshuwy - exactly, sometimes the “sum of the rounds” differs from the “round of the sum”. Can you point us to where to set the special GL account for this difference? The ones we tried so far are:
Book Maintenance - Posting/Rounding Difference Tolerance
The GL Control for AP Account/APDEF has a GL Account for the Rounding Difference context