E1: 07: Payroll Rounding Issue For Hourly Employees.
(Doc ID 2735255.1)
Last updated on DECEMBER 08, 2020
Applies to:JD Edwards EnterpriseOne US Payroll - Version 9.2 and later
Information in this document applies to any platform.
Pay rate calculation per time card vs pay stub is different.
On the surface, this doesn't seem like a large issue, but when you have 400 employees doing this, it starts to add up. The bigger issue is what will appear on the pay advice. As more time cards are included, it has the potential to get larger or smaller.
STEPS TO REPRODUCE
For five of the time cards, totaling 31.5 hours, working at 15.550 per hour.
The other three timecard entries, totaling 8.5 hours, working at 18.770 per
hour. If you do the math, the following shows:
Time card 1 -> 7.5 hours * 15.550 = 116.625 (which would concat to 116.63)
Time card 2 -> 7.5 hours * 15.550 = 116.625 (which would round to 116.63)
Time card 3 -> 4.5 hours * 15.550 = 69.975 (which would round to 69.98)
Time card 4 -> 6.5 hours * 15.550 = 101.075 (which would round to 101.08)
Time card 5 -> 5.5 hours * 15.550 = 85.525 (which would round to 85.53)
Time card 6 -> 2.5 hours * 18.770 = 46.925 (which would round to 46.93)
Time card 7 -> 3.5 hours * 18.770 = 65.695 (which would round to 65.70)
Time card 8 -> 2.5 hours * 18.770 = 46.925 (which would round to 46.93)
This would total to (actual) 649.37 and (rounding) 649.41.
On the surface, this doesn't seem like a large issue, but when you have 400 employees doing this, it starts to add up. The bigger issue is what will appear on the pay advice. Our pay advice shows the hourly employees (from R07231):
Hourly Rate Total Hours Total Pay at that Rate
So for this one, Joe would see:
15.550 31.5 489.85
18.770 8.5 159.56
You can see, however, that these numbers don't foot.
15.550 * 31.5 = 489.825 -> 489.83
18.77 * 8.5 = 159.545 -> 159.55
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document