This chapter provides an overview of the ADP integration and discusses how to:
Set up ADP integration.
Create the periodic flat file.
File quarterly tax reports using ADP.
Many companies hire outside consultants and service agencies to perform administrative activities. This strategy enables managers to concentrate on critical business functions and core competencies. The processing of payroll and related items is an administrative activity that companies often outsource. Some companies outsource all payroll processing, while others outsource only certain functions, such as tax preparation and filing. The largest provider of payroll outsourcing in North America is Automatic Data Processing (ADP).
ADP Integration enables you to outsource specified payroll functions to ADP. You can integrate the data that you create in JD Edwards EnterpriseOne Payroll with ADP. This combination enables you to process payroll using JD Edwards EnterpriseOne and have ADP report the associated payroll tax information to federal, state, and local taxing authorities.
ADP Tax Filing Service Standalone uses a flat file that contains JD Edwards EnterpriseOne payroll tax detail and summary information to process and file payroll taxes.
The JD Edwards EnterpriseOne system enables you to easily integrate payroll functions with ADP. You can process payroll internally and enable ADP to file tax information for the organization.
Using ADP in the Payroll Cycle
The JD Edwards EnterpriseOne system also enables you to send information that is created during the payroll cycle to ADP. This information enables ADP to file all of the payroll tax information for the organization. Like the journal entries, print payments, and reports steps of the payroll cycle, ADP integration must be performed after pre-payroll but before final update.
Many companies hire outside consultants and service agencies to perform administrative activities. This strategy enables managers to concentrate on critical business functions and core competencies. The processing of payroll and related items is an administrative activity that companies often outsource. Some companies outsource all payroll processing, while others outsource only certain functions, such as payment printing or tax preparation and filing. The largest provider of payroll outsourcing in North America is Automatic Data Processing (ADP).
ADP Integration enables you to outsource specified payroll functions to ADP. You can integrate the data that you create in JD Edwards EnterpriseOne Payroll with ADP. This combination enables you to process payroll using JD Edwards EnterpriseOne and have ADP report the associated payroll tax information to federal, state, and local taxing authorities.
ADP Tax Filing Service Standalone uses a flat file that contains JD Edwards EnterpriseOne payroll tax detail and summary information to process and file payroll taxes.
See Also
Setting Up Payroll Cycle Information
Working with the Payroll Cycle
This section provides an overview of ADP integration setup, lists prerequisites, and discusses how to:
Convert Vertex GeoCodes to ADP codes.
Convert PSFT company codes to ADP company codes.
Complete the ADP PDBA Quarterly Table Setup table.
Complete the ADP Employee Additional Information table.
You must set up ADP Integration to process payroll using JD Edwards EnterpriseOne and direct ADP to report the associated payroll tax information to federal, state, and local taxing authorities for you.
You set processing options in the Pay Cycle Workbench program (P07210) to indicate whether you are using ADP TaxService Filing. The data ADP uses from the JD Edwards EnterpriseOne system must be converted to a format that ADP recognizes. You complete tables to convert Vertex GeoCodes to ADP codes, and JD Edwards EnterpriseOne company codes to ADP company codes. The ADP PDBA Quarterly Table Setup table (F078505) indicates to ADP which pay types, deductions, benefits, and accruals are included in the payroll processing. If you operate in Missouri, Washington, Minnesota , or Michigan, you must also complete the ADP Employee Additional Information table (F078507).
Payroll Workbench Setup for ADP Integration
Before you can use ADP Integration with JD Edwards EnterpriseOne Payroll, you must set the processing option for the Pay Cycle Workbench program (P07210) to indicate that you are using ADP Integration. The processing option that you need to set appears on the ADP Files tab.
See Setting Processing Options for Payroll Cycle Workbench (P07210).
Converting Vertex GeoCodes to ADP Codes
Before ADP can process payroll taxes that are associated with the payroll information that you create with JD Edwards EnterpriseOne Payroll, you must complete the Vertex GeoCode to ADP Code table (F078504). This table converts Vertex GeoCodes that are used by JD Edwards EnterpriseOne into codes that are used by ADP Tax Filing Service Standalone.
You must enter every GeoCode that the company uses, as well as the associated ADP codes, into this table. If you process a payroll that includes employees who are associated with GeoCodes but who are not included in this table, ADP processes those employee records with invalid codes.
Note. Vertex and ADP might periodically change or add new GeoCodes or tax codes. You must ensure that the Vertex GeoCode to ADP Code table contains all of the current codes that you use to process payroll. For more information about Vertex GeoCodes, contact Vertex directly. For more information about ADP tax codes, refer to the documentation for ADP Tax Filing Service Standalone or contact ADP directly.
Converting PSFT Company Codes to ADP Company Codes
Before ADP can process payroll taxes using the payroll information that you create with JD Edwards EnterpriseOne Payroll, you must complete the PSFT Company Code to ADP Company Code table (F078506). This table converts company codes that are used by JD Edwards EnterpriseOne Payroll into company codes that are used by ADP Integration. You must enter every company code that the company uses, as well as the associated ADP codes, into this table. ADP provides the four-character alphanumeric codes for the ADP company codes.
Completing the ADP PDBA Quarterly Table Setup Table
Before ADP can process payroll taxes with the payroll information that you create using JD Edwards EnterpriseOne Payroll, you must complete the ADP PDBA Quarterly Table Setup table (F078505). This table indicates to ADP which pay types, deductions, benefits, and accruals (PDBAs) are included in the payroll processing.
This table includes all of the PDBA category codes that are tracked for the quarterly report:
Code |
Description |
ALL |
Allowances (Puerto Rico only) |
BER |
Business Expense Reimbursement |
COM |
Commission Amounts 499R-2 (Puerto Rico only) |
DEP |
Dependent Care |
ECT |
Employee Contributions (future use) |
FRB |
Fringe Benefit |
FRV |
Fringe - ER Vehicle |
GOV |
Government Pension 414(h) |
GRD |
Gross Distribution (future use) |
IMA |
Individual Medical Account |
ME3 |
Moving Expense 3rdParty |
MEC |
Meals ER Convenience |
MEX |
Moving Expense (New York only) |
MHC |
Medical and Health Care (future use) |
NEC |
Non-employee Compensation (future use) |
NQ4 |
Non Qualified Non 457 |
NQD |
Nonqualified Pens Dist Sec 457 |
NQN |
Nonqualified Pens Dist Non 457 |
NQP |
Nonqualified Plan Income |
PNS |
Pension Amount (Puerto Rico only) |
QTR |
Qualified Transportation |
REM |
Reimbursed Expense Amounts (Puerto Rico only) |
RET |
Retirement Fund Amounts (Puerto Rico only) |
RTD |
1099 Rent Amounts (Future use) |
RYT |
1099 Royalties (Future use) |
SON |
Stock Options Nonstatutory |
SPC |
Sick Pay Employer Contributed (New York only) |
SPY |
Substitute Payments (Future use) |
SVP |
Severance Pay (New York only) |
If the company does not use a particular PDBA category, you do not need to enter a value in the table for that category.
Completing the ADP Employee Additional Information Table
Missouri, Washington, Minnesota, and Michigan have special payroll reporting requirements. You supply this information to ADP by completing the ADP Employee Additional Information table (F078507).
Set up the processing options for the Payroll Cycle Workbench program.
See Setting Processing Options for Payroll Cycle Workbench (P07210).
Form Name |
FormID |
Navigation |
Usage |
Local ADP Code Table |
W078504A |
ADP Setup (G07ADP4), Local ADP Code Table |
Convert Vertex GeoCodes to ADP Codes. |
PSFT Company Code to ADP Company Code |
W078506A |
ADP Setup (G07ADP4), PSFT Company Code to ADP Company Code |
Converting PSFT Company Codes to ADP Company Codes. |
ADP PDBA Quarterly Table Setup |
W078505B |
ADP Setup (G07ADP4), ADP PDBA Quarterly Table Setup |
Complete the ADP PDBA Quarterly Table Setup table. |
ADP Employee Additional Info |
W078507A |
ADP Setup (G07ADP4), ADP Employee Additional Information |
Complete the ADP Employee Additional Information table. |
Access the Local ADP Code Table form.
Vertex GeoCode |
Enter a code that identifies a geographical location and the tax authorities for an employee work site, including employee and employer statutory requirements. In the Vertex payroll tax calculation software, the tax area code is synonymous with GeoCode. To determine the valid codes for the location, refer to the documentation for the tax calculation software that you are using. |
ADP Work & Live Code |
Enter a four-digit numeric code that indicates an employee both works and lives in the same location. This code is supplied by ADP. |
ADP Work In Code |
Enter a four-digit numeric location code that indicates an employee works in the location. This code is supplied by ADP. |
ADP Live In Code |
Enter a four-digit location code that indicates the employee lives in the location. This code is supplied by ADP. |
Access the PSFT Company Code to ADP Company Code form.
PSFT Company Code |
Enter the company to which the employee is assigned. This code is used to store historical payroll information and to determine accounts for some journal entries. |
ADP Company Code |
Enter a four-digit alphanumeric code that specifies the company to which the employee is assigned. This code is supplied by ADP. |
Access the ADP PDBA Quarterly Table Setup form.
PDBA Category |
Enter a user-defined code (07Y/IP) that designates W-2 and 1099 box numbers. |
PDBA Code |
Enter a code that defines the type of pay, deduction, benefit, or accrual. Pay types are numbered from 1 to 999. Deductions and benefits are numbered from 1000 to 9999. |
Access the ADP Employee Additional Info form.
End Probation Date MO Only (end probation date, Missouri only) |
Enter the calendar date (MM/DD/YYYY) on which an employee's probationary employment status ends. This field applies to the state of Missouri only. |
Corp Officer Y/N WA Only (corporate officer yes/no, Washington only) |
Enter a code that indicates whether an employee is an officer of the company. This field applies only to the state of Washington. Values are: Blank or N: No Y: Yes |
Worksite Loc Code MN Only (worksite location code, Minnesota only) |
Enter a code that specifies the location where the employee works a majority of the time. This field is required in the state of Minnesota only. Use this field when the company has multiple locations/worksites and when a State Unemployment Insurance agency needs to receive the Quarterly Wage Detail with a breakdown or subtotal by worksite/location. |
Worksite Loc Code MI Only (worksite location code, Michigan only) |
Enter a code that specifies the location where the employee works a majority of the time. This field is required in the state of Michigan only. Use this field when the company has multiple locations/worksites and when a State Unemployment Insurance agency needs to receive the Quarterly Wage Detail with a breakdown or subtotal by worksite/location. |
This section provides an overview of the periodic flat file, lists prerequisites, and discusses how to:
Create the periodic flat file.
Set processing options for the ADP TaxService Periodic Flat File TC program (R89078501).
The ADP Tax Filing Service Standalone is an automated system that enables you to outsource federal, state, and local payroll tax reporting. You can integrate the data that you create using JD Edwards EnterpriseOne Payroll with ADP Tax Filing Service Standalone. This combination enables you to process payroll with JD Edwards EnterpriseOne Payroll and have ADP report the associated payroll tax information to federal, state, and local tax authorities for you.
To process tax data that you generate using JD Edwards EnterpriseOne Payroll in ADP Tax Filing Service Standalone, you must create the Periodic flat file. Using information created during the payroll cycle, this flat file contains tax data in a format that ADP Tax Filing Service Standalone can read. This flat file contains data that the system extracts from these JD Edwards EnterpriseOne tables:
Tax Detail File (F07353).
Employee Master Information (F060116).
Payroll Transaction Constants (F069116).
Tax History (F06136).
To create this flat file, you must first set up a version of the ADP TaxService Periodic File TC program (R89078501). This version requires data selection that matches the data selection for the pre-payroll version. If you are using data selection over an item that does not exist in the data selection for the ADP TaxService Periodic File TC program (R89078501, you must set the data selection equal to the Payroll ID, because the fields selected on the pre-payroll version are not available in the table conversion.
After you create the version of the ADP TaxService Periodic File TC program that you want to process, you must create a version of the ADP TaxService Periodic File program (R078501). Both the ADP TaxService Periodic File TC program and the ADP TaxService Periodic File program can be accessed using the Batch Versions program (P98305).
Before you create the Periodic flat file, you must also create a folder called export. You create this folder so that it is subordinate to the folder that contains the JD Edwards EnterpriseOne version that you installed, in the same location as the res folder. These folders must exist before the system can produce the Periodic flat file.
After you set up versions of the ADP table conversion programs and create the export folder, you must run the pre-payroll step of the payroll cycle. Much of the data that you need to create the Periodic flat file is stored in workfiles that the system creates during pre-payroll. To ensure that the system uses the correct data to create the flat file, you must create the file after you successfully process pre-payroll and before you complete the final update step of the payroll cycle for which you want to process tax information. After you successfully create the Periodic flat file, a 1 appears in the ADP Tax Status field on the Work With Pay Cycle Workbench form (W07210A).
The flat file that you create is stored in the export folder and is named CCCCMMDD .prl, where CCCC is the ADP company code, MM is the month, and DD is the day of the payroll payment date. For example, if the ADP company number for Company A is 5555, the name of the Periodic flat file that the system creates for a payroll with a payment date of December 31, 2000 is 55551231.prl. See the system administrator for information about transferring this flat file to ADP Tax Filing Service Standalone.
Before you complete the tasks in this section:
Create the export folder.
Successfully complete pre-payroll processing.
Set up versions of the ADP TaxService Periodic File TC program (R89078501) and the ADP TaxService Periodic File program (R078501).
See Also
JD Edwards EnterpriseOne Tools 8.98 Development Tools: Data Access Tools Guide
JD Edwards EnterpriseOne Tools 8.98 Foundation Guide
Form Name |
FormID |
Navigation |
Usage |
Work With Pay Cycle Workbench |
W07210A |
Payroll Workbench (G07BUSP11), Pay Cycle Workbench |
Select a Payroll ID. |
Access the Work With Pay Cycle Workbench form.
To create the periodic flat file:
Select the payroll ID for which you want to create the Periodic flat file, and then select ADP Files, and then Periodic File from the Row menu.
Note. This menu option is disabled if you do not set the processing option for the Payroll Workbench to indicate that you are using ADP Integration. The option is enabled only after pre-payroll has been run. You must create the Periodic flat file before you run the final update step of the payroll cycle.
When you have successfully created the Periodic flat file, a 1 appears in the ADP Tax Status field. A 1 must appear in this field before you can run final update.
To bypass the process of creating the Periodic flat file, select Payroll Parameters from the Row menu, and enter a 1 in the ADP Tax Service Status field.
Processing options enable you to specify the default processing for programs and reports.
Default
These processing options specify the default information that is used in the ADP table conversion process.
1. Processing Office Name |
Use this processing option to specify the name of the office where the file will be created. The processing office name prints in the header record to help track the location where the file was generated. You can create an alphanumeric code up to 10 characters in length for this optional field. |
2. FUTA/SUI Periodic Impound |
Use this processing option to specify whether you have an agreement with ADP to send and process Federal Unemployment Tax Act (FUTA) and State Unemployment Insurance (SUI) information on the Periodic file. Values are: 0: Do not send FUTA/SUI information. 1: Do send FUTA/SUI information. |
3. ADP Branch Code |
Use this processing option to specify the two-character ADP Branch Code, which is supplied by ADP Tax/Financial Services. If you leave this option blank, the system uses the default value ST. |
This section provides an overview of the quarterly tax filing process, lists prerequisites, and discusses how to:
Run the ADP TaxService Quarterly File TC program (R89078502).
Set processing options for the ADP TaxService Quarterly File TC program (R89078502).
ADP Tax Filing Service Standalone is an automated system that enables you to outsource federal, state, and local payroll tax reporting. You can integrate the data that you create in JD Edwards EnterpriseOne Payroll with ADP Tax Filing Service Standalone. This combination enables you to process payroll using JD Edwards EnterpriseOne and have ADP report the associated payroll tax information to federal, state, and local taxing authorities for you.
To process tax data that you generate using JD Edwards EnterpriseOne Payroll in ADP Tax Filing Service Standalone, you must create the Quarterly flat file. This flat file contains tax information that the system creates after the final update step of the of the payroll cycle at the end of each quarter, and the information appears in a format that ADP Tax Filing Service Standalone can read.
To create this flat file, you must first set up a version of the ADP TaxService Quarterly File TC program (R89078502). This version requires data selection that includes all information that you need to process for the entire quarter.
The flat file that you create is stored in theexportfolder and is named CCCCMMDD .qtr, where CCCC is the ADP company code, MM is the month, and DD is the day of the quarter end date. For example, if the ADP company number for Company A is 5555, the name of the Quarterly flat file that the system creates for the quarter ending date of December 31, 2000 is 55551231.qtr.
After you create the version of the ADP TaxService Quarterly File TC program that you want to process, you must create a version of the ADP TaxService Quarterly File program (R078504). Both the ADP TaxService Quarterly File TC program and the ADP TaxService Quarterly File program can be accessed from the Batch Versions program (P98305).
You create the Quarterly flat file at the end of the quarter, after you run the final update for the last pay period of that quarter.
Note. To file the quarterly reports, ADP requires complete employee name information in Address Book. Complete the Alpha Name field for each employee in the payroll cycle using this format:
Last Name, comma, space, First Name, space, Middle Name.
For example: Smith, John James
If the employee has suffix information that you need to include (such as Jr. or II), use this format in the Alpha Name field:
Last Name, space, suffix, comma, First Name, space, Middle Name.
For example: Smith Jr., John James
See Entering Address Book Records.
Before you complete the tasks in this section:
Create the export directory.
Set the processing options for the Pay Cycle Workbench program (P07210) to specify that you are using ADP Integration.
Successfully complete pre-payroll processing.
Complete the ADP PDBA Quarterly Table Setup table (F078505).
Set up versions of the ADP TaxService Quarterly Filing TC program (R89078502) and the ADP TaxService Quarterly File program (R078504).
Verify that the address book information for each employee is complete.
Verify that the values for the W-2 IRS Defined Code field on the U.S. Legislative/Regulatory form (W059116UB) include all of the PDBAs in this table:
PDBA |
IRS-Defined Code |
Group Term Life |
C |
401(k) |
D |
403(b) |
E |
408(k)(6) |
F |
457 |
G |
501(c)(18)(D) |
H |
Excess "Golden Parachute" |
K |
Uncollected FICA (GTL) |
M |
Uncollected Medicare (GTL) |
N |
Qualified Moving Expense |
P |
Medical Savings Account |
R |
408P |
S |
Adoption Benefit |
T |
See Also
(USA) Setting Up Tax-Deferred Compensation Deductions for the U.S.
JD Edwards EnterpriseOne 8.98 Development Tools: Data Access Tools Guide
JD Edwards EnterpriseOne Tools 8.98 Foundation Guide
Select Payroll Workbench (G07BUSP11), ADP TaxService Quarterly File.
Processing options enable you to specify the default processing for programs and reports.
Default
These processing options specify the default information that is used in the ADP table conversion process.
1. Processing Office Name |
Use this processing option to specify the name of the office where the file will be created. The processing office name prints in the header record to help track the location where the file was generated. You can create an alphanumeric code up to 10 characters in length for this optional field. |
2. Payroll Reference Code |
Use this processing option to identify the internal payroll batch. This name can be a user-defined alphanumeric code that is up to six characters in length. This is an optional field that prints in the header record to help track the payroll batch used to generate the file. |
3. Control-Non Employee Disbursements |
Use this processing option to specify if the data selection for this version is for non-employee disbursements (1099/W-2G). A separate version needs to be made for employees. Values are: Blank or N: No Y: Yes |
4. Worksite Reporting |
Use this processing option to specify if the company reports a breakdown of wages by worksite or location to any SUI agencies. Values are: Blank or N: No Y: Yes |
5. Quarter to run over |
Use this processing option to specify the quarter for which you are running the report. Values are: 1: First quarter (01/01 - 03/31) 2: Second quarter (04/01 - 06/30) 3: Third quarter (07/01 - 09/30) 4: Fourth quarter (10/01 - 12/31) |
6. Year to run over |
Use this processing option to specify the year the user wants processed on this file run. Use two digits to represent the year. For example, to select year 2005, enter 05. |
7. Third-Party Sick Pay indicator |
Use this processing option to specify whether the company is a third-party payer of sick pay that is filing a Form W-2 for an insured employee. Values are: Blank or N: No Y: Yes |
8. ADP Branch Code |
Use this processing option to specify the two-character ADP Branch Code, which is supplied by ADP Tax/Financial Services. If you leave this option blank, the system uses the default value ST. |