Rounding Difference Exists in AR
Hello, I have the following scenario:
the client imports from a system called Gescom the transactions, to Oracle AR like the following:
(Tax rate = 20%)
Current System calculation:
line 1: 1.89 * 0.02 = 2.26
line 2: 35.2 * 0.2 = 42.24
Total Amount with Tax = 44.5
Explanation of the desired calculation:
1) The sum of all lines = 1.89 + 35.2 = 37.09
2) The sum of all lines * tax percentage = 37.09 * 20% = 7.42
3) Total Amount with Tax = 37.09 + 7.42 = 44.51
How can we reach the desired calculation?
Thank you
1