ADP_TAXATION_INTERFACE
Back to current versionRestore this version

ADP TAXATION INTERFACE#

Setting up the Tax Information#

IPPR#

Each Payroll is linked to a specific “ADP Tax Company” and this information must be entered on IPPR. This is used in quarterly reporting.

IMLN#

There are two lexicons on IMLN that must be defined to link pay components to the correct tax type for reporting to ADP.

When setting up the tax codes, use the following code pattern:

IPPC#

The ADP interface requires four components for each tax code including: Gross, Deduction, Subject and Taxable wages. The Gross amount is retrieved from an element in the payroll called “GROSS” but the remaining three components are setup as separate pay components in IPPC.

There are three new “External Interface Items” found on the IPPC Information tab. These fields need to be filled in order to set up a code to be transferred to ADP for this taxation interface.

ADP Tax Code
This field holds the tax code that this pay component represents. These tax codes are decided between ADP and the client and must be mapped in the ADP system to ensure that the amounts collected are applied to the correct tax accounts.
ADP Tax Type
Tax type indicates whether the amount is considered a deduction, contribution, subject amount or a taxable amount. These will be sent as a set to ADP for processing so it is important to set up three different pay components for each tax code sent to ADP.
ADP Tax Resident
If this toggle is checked, the tax is a resident (not work) tax. If it is listed as a resident tax then the system will use the “home” jurisdiction on the IPPH header to determine how to apply the tax otherwise it will use the “work” jurisdiction.

IPPE#

In order to transfer the correct amounts to ADP, a number of elements are required by the tax interface. These are defined in IPPE.
  1. ADP_TAX_GROSS_WAGES
    This is the amount of Gross wages for inclusion in this interface. It may be a compound element.
  2. ADP_TAX_HOURS_WORKED
    This element will contain an amount equal to the eligible taxable hours worked for the employee during the pay period.
  3. ADP_TAX_RETIRE_AMOUNT
    This element holds the retirement earnings for the employee during the pay period.
  4. ADP_TAX_SICK_AMOUNT
  5. ADP_TAX_MOVING_AMOUNT
  6. ADP_TAX_ALLOWANCES_AMOUNT

IDGV#

On IDGV, you must ensure that you have defined tax jurisdiction information and registration IDs for each type of tax that you are sending to ADP.

You must fill in the ADP Tax Code on this screen to reflect the tax code associated to this particular registration

IPVP#

IPVP shows the pay runs that have been processed by the UPADPTXP update process. If you are beginning to use this functionality after you have a large number of pays already closed in the application, you may want to use SQL to set the value of this toggle so that these past pays are not processed. There are two interface programs for executing, one for the Periodic Interface and one for the Quarterly Interface.

UPADPTXP – Periodic Interface#

This program processes all pay headers (IPPH) in each pay run for the selected payroll where the Pay Run stage is “Closed” or “Journalized” and the ADP SUBMITTED toggle is not checked, in IPVP.

There is no mechanism for selecting individual pay runs within a payroll – all pay run s that are not yet processed will be picked up.

If you run this program in “Trial Run = No” mode, then the Pay Run toggle will be checked at the end of the processing. Running it with “Trial Mode = Yes” or not specified will not check the toggle, and you may reprocess the payruns over and over again.

The directory specified is a database server-centric directory, that must be accessible by the data base server processes.

This process will also update the table P2K_PR_ADP_TAX_INTERFACES with the summarized data. This is used for subsequent reporting by the UPADPTXQ (Quarterly Interface) process, and can be viewed with the VPADPI screen. UPADPTXQ – Quarterly Interface

This program will process and produce a quarterly taxation file for ADP, for the ADP Tax Company (defined in IPPR) as selected.

The List Of Values (LOV) lookup may show multiple values for the same ADP Tax Company, if the same value is used on multiple payrolls. This is a known issue and has no impact on the processing.

Note that this process will report and summarize the data as previously run on UPADPTXP interface runs. If you do not have a complete quarter’s worth of data processed by UPADPTXP, then this file will not reflect the correct values.

VADPI - Viewing ADP Interface Data This screen is a view-only screen that presents the data created by the UPADPTXP process. The data is extensive and this screen is non performant.


Notes#

Click to create a new notes page