E1:07:ADP Periodic File Is Creating Duplicate Entries For School Tax

(Doc ID 2181362.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

JD Edwards EnterpriseOne US Payroll - Version 9.1 and later
Information in this document applies to any platform.


Employee work in 2 digits geo code (in this case 36) and reside in 9 digits Geo code (in this case 361495712) with school code of 7503. When a 9 digits Geocode contained more and one school district codes, system double up the gross wages as well as the tax amount on school tax. For example, the above 9 digits Geocode have two school district code 7501 and 7503. The employee have 7503 on the National and fiscal data. Employee has timecard in 36 with total gross of 393.28. With this gross school tax is 2.95 (393.28 x .0075). When payroll is run, the ADP Periodic Verification Report (R078509) showed the correct gross of 393.28 and tax amount of 2.95. However, under the Grand total by Tax Area and Tax Type, the school district gross is 786.56 (393.28x2) and tax amount 5.90 (2.95 x 2). These amount then show up on the Periodic file. Note*: if you have a large payroll run, the report does not even finish and the end result in the periodic is that the file quits doubling the amount in ADP local code and instead puts the correct amount per School District Code per same Geo Code. In other words, with the same scenario above, if the above employee is included in a large payroll, you will see two school tax; one for school code 7501 and the other is for 7503. Or in some case, if there are three, 4 or more school district codes then it would triple, quadruple etc...


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms