Rounding Discrepancies in Work In Process Valuation Account
Hello,
We are experiencing a discrepancy in our Work In Process (WIP) Valuation account between DR/CR after WO closing due to rounding.
Example:
DR Side (Unrounded Values):
1.89
2.340821256
3.84915493
4.707307692
8.38
48.3859186
361.2661338
Total : 430.8193363
CR Side (Unrounded Values):
-430.8193363
Summing the unrounded DR amounts equals the unrounded CR amount.
However, when each DR line is individually rounded to two decimal places and then summed, the total becomes 430.83, introducing a discrepancy of 0.011 due to rounding.
DR Side (Rounded Values):
1.89
2.34
3.85
4.71
8.38
48.39
361.27
Total : 430.83
CR Side (Rounded Values):
-430.82
Is there a system-configured solution to address this rounding issue ? Have other customers encountered similar differences, and if so, how have they resolved them?