My Oracle Support Banner

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.

Symptoms

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.