This chapter contains the following topics:
After you process a payroll, you should verify the integrity of the payroll history. You use this history for:
Government reports
Year-end forms
Internal reporting purposes
To verify the integrity of the payroll history, you run integrity reports to identify these types of information:
Discrepancies within the summary history tables.
Discrepancies between the summary history tables and their corresponding detail tables.
Information in the summary tables that is missing, inaccurate, or incomplete.
You should run payroll history integrity reports monthly, quarterly, and before you begin year-end processing. You should review each error that appears on the integrity reports to determine what action, if any, you must take to correct it. Depending on the error, you must correct payroll history either by revising the appropriate payroll information or by making changes to the payroll history tables. The system can correct other errors automatically when you run integrity reports in update mode. The JD Edwards EnterpriseOne Payroll system includes error code tables that can help you research integrity errors.
Each time that you run the final update for a payroll cycle, the system creates payroll history records and stores them in history tables. This table describes the two types of history records:
Record | Description |
---|---|
Detail records | Detail history records contain each tax type, pay type, deduction, benefit, and accrual that the system calculated for each payment. The system stores these records in detail history tables. |
Summary records | After the system stores records in the detail history tables, it totals and summarizes the information in these tables, and creates summary history records. The system then writes the summary history records to the corresponding summary history tables. The system uses the summary history tables to retrieve tax and earnings information for government reports and year-end forms. The use of summary history tables to report tax and earnings information reduces processing time. |
Review this four-digit number that is assigned to all errors. When this number is used in the error message facility (F7 from any form), you can enter a specific error message number and press F13 to automatically access the revisions program that is referenced within the text of the error message. This function applies only to error messages that refer to items such as user-defined codes (UDCs).
Review the UDC (07/TH) that specifies the type of information that is being tracked for the employee in the F06136 table or the F0713 table. The value in this field determines what type of year-end form the system generates.
Enter the two-digit number that identifies the applicable year. If you leave this field blank, the program uses the system date.
This section provides an overview of working with tax history integrity, lists prerequisites, and discusses how to:
Identify tax history integrity errors.
Set data selection and sequence for the Tax History Integrity report.
Set processing options for the Tax History Integrity report (R077011).
To verify tax history integrity, run the Tax History Integrity report (R077011). This report identifies errors such as missing, inaccurate, or incomplete information in the F06136 table. You should regularly verify the integrity of the taxation history to ensure that the correct information appears on the quarterly tax reports and employees' year-end forms.
To identify taxation integrity errors, you first run the Tax History Integrity report in proof mode so that you can research errors and enter any corrections manually before you update the table. When you run the integrity report in proof mode, the system identifies possible errors, but does not change any information in the history table. Running the integrity report in update mode automatically corrects some errors.
To correct taxation integrity errors, use history revision forms to enter corrections manually, and then run the Tax History Integrity report in update mode. When you run an integrity report in update mode, the system corrects information in the F06136 table and generates a report that indicates the errors that could not be corrected. Review all of the errors, correct them as instructed, and rerun the integrity report until all of the errors are corrected. (Some entries on the report might reflect valid conditions for the data.)
To simplify the process of regularly verifying the payroll history integrity, you can set up the integrity reports to run during the final update step of each payroll cycle. The versions of these reports that you run during final update should be set up to run in proof mode. You should also run these reports monthly, quarterly, and before you begin year-end processing.
To complete the tax history integrity tasks, you must run the integrity report at least three times to:
Identify the errors.
Correct the errors.
Verify that all updates were performed.
Note that when you review employee tax history, each tax history record is assigned a tax history type. The tax history type that is assigned to tax history records is determined by the tax method that you assign to the employee during the employee setup process. The system uses the tax history type to determine the year-end form on which the employee's earnings are reported. For example, if an employee has a blank tax method (regular), the tax history type is also blank. All tax history records with a blank history type are reported on the W-2 form. This table indicates the year-end form on which each type of tax history is reported:
Tax Method | Description | Tax History Type | Year-End Form |
---|---|---|---|
Blank | Regular | Blank | W-2 |
N/A | Third-Party Sick Pay | 1 | W-2 (separate) |
C | Contract | C | 1099-MISC |
P | Pension | 2 | 1099-R |
4 | Medicare Qualified | 3 | W-2 |
5 | FICA/Medicare Exempt | 4 | W-2 |
R | Regular - Puerto Rico with Tax Area = 72 | R | 499R-2 |
The system uses the information in the F06136 table to produce government year-end forms for employees. Keeping this table error-free simplifies the year-end processing tasks. The Tax History Integrity report identifies three types of information:
Errors that you must correct manually.
Errors that the program corrects when you run the report in update mode.
Irregularities that are not necessarily errors.
For example, a situation in which no federal tax was withheld might be a valid condition for a low-wage earner.
The system also creates a backup table of the summary history table (F077011) when you delete records (for example, invalid records that contain negative amounts). You should call customer support for help in restoring the backup table.
You run integrity reports in proof mode to identify possible errors without changing any of the information in the history tables. You also run integrity reports in proof mode so that you can research errors before correcting and updating the appropriate tables. You use processing options to specify that the Tax History Integrity report run in proof mode.
After you run the Tax History Integrity report (R077011) in proof mode, you must research each error that appears on the report. You must correct these errors so that the quarterly reports and year-end forms are accurate.
Any of these error codes might appear on the report. These codes are defined in UDC table 06/IX. To help determine the action that you must take to correct integrity errors, review the explanation of the error code from this error code list:
Before you complete the tasks in this section:
Create a backup table of the F077011 table.
The system does not create a backup of this table when you run the integrity report.
Set the processing mode to Proof in the processing options to ensure that the system runs the report without updating data.
Enter the appropriate tax earnings limitations and rates in the processing options.
Without this information, the system cannot identify certain types of errors.
On the Corporate Tax ID Revisions form, ensure that no dashes or spaces exist in the tax ID for the Federal A tax area.
Select Advanced and Technical Operations (G07BUSP3), Tax History Integrity.
Enter the last two digits of the current year. If all of the companies in the organization have the same paymaster, do not include the home company in the selection criteria.
These processing options specify the mode in which to run the Tax History Integrity report, whether the system deletes certain information, and which error types the system displays on the report. You can also enter information that might vary from year to year, such as the tax rate and limit for Social Security.
Specify the mode in which the report runs. If you select proof mode, then the system prints a report without updating the history tables. If you select update mode, then the system prints a report and updates the summary history table with the corrected information. Values are:
0: Proof mode.
1: Update mode.
Specify whether to delete the records in the Tax History table for which the company, tax area, and tax type have no corresponding records in the Corporate Tax ID table. In some situations, these records are valid and should not be deleted. For example, if you are waiting to receive a corporate tax ID from the government, you might have entered applied for in the Corporate Tax ID table. In this case, you would not want to delete the tax history records, even though they do not correspond to the records in the Corporate Tax ID table. Values are:
0: Do not delete.
1: Delete.
Specify a numeric value that represents the amount of wages on which employees must pay Social Security tax.
Specify a numeric value that represents the percentage of wages that employees must pay in Social Security tax for the current year. For example, if the Social Security tax rate is 4.2 percent, enter 4.2 in this processing option.
Specify a numeric value that represents the percentage of wages that employers must pay in Social Security tax for the current year. For example, if the Social Security tax rate is 6.2 percent, enter 6.2 in this processing option.
Specify a numeric value that represents the percentage of wages that employees must pay in Medicare tax for the current year. For example, if the Medicare tax rate is 1.45 percent, enter 1.45 in this processing option.
Specify a numeric value that represents the percentage of wages that employers must pay in Medicare tax for the current year. For example, if the Medicare tax rate is 1.45 percent, enter 1.45 in this processing option.
Specify a numeric value that represents the increased percentage of wages that employees must pay in Medicare tax for the current year. This is only applicable if the employee's wage earned is over the specified limit. For example, if the Additional Medicare Tax rate is 2.35 percent, enter 2.35 in this processing option.
Specify the four-digit error codes that you do not want to print on the report. If you leave this processing option blank, all error codes will print on the report.
This section provides an overview of how to correct tax history integrity errors, lists a prerequisite, and discusses how to:
Correct tax history integrity errors manually.
Correct tax history integrity errors automatically.
After you run the Tax History Integrity report (R067011) in proof mode and review the errors, you must correct these errors so that the quarterly reports and year-end forms are accurate.
Running the integrity report in update mode automatically corrects certain errors, such as an invalid statutory code or a missing tax ID code. To correct other errors, such as an incorrect tax ID or an invalid number of periods, you must manually revise the payroll data before you run the report in update mode. Some entries that appear on the report might not be errors for the data. For example, taxation error 0250 - No Federal Tax Taken might appear for a low-wage earner for whom no federal tax should be withheld.
After you run the Tax History Integrity report in update mode, you should run it again to produce an error-free report. When the system finds no errors, it generates only the cover page.
Note: If running the Tax History Integrity report does not generate errors, the review form does not allow you to review information. This form is used only to review and revise errors that are generated by the report. |
The payroll error code list helps you determine the actions that you must perform to correct each payroll history error that appears on the Tax History Integrity report. You might need to manually revise history records, tax area information, or corporate tax IDs before running another integrity report in update mode. For example, you might need to make these corrections:
Delete a record that contains zero dollars.
Change a tax ID number.
Correcting tax history ensures that the correct information appears on the quarterly tax reports and year-end forms.
Important: This program must have the highest possible level of system security. Be aware of this information when you revise payroll history manually:The system does not update the JD Edwards EnterpriseOne General Accounting system. You must manually enter the appropriate journal entries. The system does not create an audit trail of the changes that you enter when you revise payroll history manually. |
After reviewing the Tax History Integrity report (R077011) and making any corrections manually, you run the report in update mode to update the Summary History table with the corrected information. Errors that can be corrected automatically are corrected when you run an integrity report in update mode. For example, you might have entered a new tax ID or corrected an existing one. When you run the report in update mode, the system updates all history records with the new tax ID.
Consult the payroll error code list for information that you might need to correct before running the integrity report in update mode.
You can correct these errors by running the Tax History Integrity report in update mode after you have made any necessary corrections as instructed for each error on the error code list:
0109 - Invalid tax ID number.
0112 - Tax ID does not exist.
0113 - Tax ID does not match.
0251 - Work state, county, city mismatch tax area.
0252 - Invalid statutory code.
0253 - Invalid century field.
Error codes 0251, 0252, and 0253 are for fields in the table only. The information is not visible from any review forms.
Set the processing mode to Update in the processing options for the Tax History Integrity report to print the report and update the table.
Access the Work With Taxation History Review form.
To correct tax history integrity errors manually:
Complete one or more of these fields, and click Find:
Company
Year
Error Code
History Type
Skip to Employee
Review the errors that appear in the detail area, and complete the following steps, as necessary.
Complete steps 4 through 6 to enter or correct a corporate tax ID number.
Select a record in the detail area on Work With Taxation History Review.
Select Corp Tax ID (Corporate Tax ID) from the Row menu on Work With Taxation History Review.
Enter the necessary changes on Corporate tax ID Revisions.
Complete steps 8 and 9 to void a payment.
Select Paycheck Review from the Form menu on Work With Taxation History Review.
Complete the steps for voiding a payment on Work With Payment History.
Complete steps 11 and 12 to enter or correct a tax area.
Select Tax Area Cnsts (tax area constants) from the Form menu on Work With Taxation History Review.
Enter the necessary changes on Work With Tax Area Information.
Complete steps 14 through 16 to review or revise an employee's tax history.
Select a record in the detail area on Work With Taxation History Review.
Select Tax History from the Row menu on Work With Taxation History Review.
Enter any necessary changes on Work with Tax History, and then click OK.
See Also: |
This section provides an overview of how to work with PDBA history integrity, lists prerequisites, and discusses how to:
Identify PDBA history integrity errors.
Set data selection and sequence for the PDBA History Integrity report.
Set processing options for Payroll Month PDBA Integrity report (R077021).
To ensure that the correct information appears on the quarterly tax reports and employees year-end forms, you should regularly verify the integrity of the PDBA history. To verify PDBA history integrity, run the PDBA Integrity report (R077021). This report identifies missing, inaccurate, or incomplete information in the F06146 table.
To identify PDBA history integrity errors, run the PDBA History Integrity report in proof mode so that you can review errors and enter any manual corrections before updating the table. When you run the integrity report in proof mode, the system identifies possible errors without changing any information in the history table.
To correct PDBA history integrity errors, run the PDBA History Integrity report in update mode or use history revision forms to enter corrections manually. When you run an integrity report in update mode, the system corrects information in the Employee Transaction History Summary table and generates a report that lists the errors that it could not correct. Review all errors, correct them as instructed, and rerun the integrity report until all of the errors are corrected.
You should run integrity reports monthly, quarterly, and before you begin year-end processing.
To complete these tasks, you must run the integrity report at least twice:
The first time, to identify the errors.
The second time, to correct the errors.
You use the Payroll Month PDBA Integrity report to identify errors in the F06146 table. This table contains the adjustment amounts that you might need to add to taxable wages or to report in other detail boxes on the year-end forms. These amounts might include retirement account contributions, moving expenses, group term life insurance premiums, and so on. Ensuring that this table remains error-free simplifies the year-end processing tasks.
You typically generate the integrity report first in proof mode to identify possible errors without changing any information in the history tables. After you have reviewed and corrected any errors that appear on the report, you generate the report in final mode, during which time the system updates the appropriate tables.
The Payroll Month PDBA Integrity report identifies these types of information:
Errors that you must correct manually.
Errors that the program corrects when you run the report in update mode.
These errors usually apply to multiple records.
To generate the Payroll Month PDBA Integrity report in proof mode, set the processing mode to Proof in the processing options.
After you run the PDBA Integrity report (R077021) in proof mode, you must research each error that appears on the report. You must correct the errors to ensure accurate quarterly reports and year-end forms.
Any of these error codes might appear on the report. These codes are defined in UDC table 06/IT. To help determine the action that you must take to correct integrity errors, review the explanation of the error code from this error code list:
Before you complete the tasks in this section:
Create a backup table of the F06146 table.
The Payroll Month PDBA Integrity report does not automatically create a backup of the information in this table when you run the report in update mode.
Set the processing mode to Proof in the processing options for the Payroll Month PDBA Integrity report to print the report without updating the table.
Select Advanced and Technical Operations (G07BUSP3), Payroll Month PDBA Integrity Report.
Enter the last two digits of the current year in the data selection. Do not change the data sequence of the report.
Set these processing options before you run the Payroll Month PDBA Integrity report.
Use these processing options to specify the mode in which to run the Payroll Month PDBA Integrity report. You can also specify any error types that you do not want the system to print on the report.
Specify whether to process the report in proof mode or update mode. In proof mode, the system prints a report without updating the history tables. Use the report to review errors and determine the information that you need to correct manually before you run the report in update mode. In update mode, the system prints a report and updates the summary history table with the corrected information. Use this mode after you have reviewed and corrected all errors that you can correct manually. Values are:
0: Proof mode
1: Update mode.
Specify the error codes that you do not want the system to print on the report. To print all error codes, leave all fields for this processing option blank. Enter four digits for each error code that you want to omit. Use leading zeros for codes that are less than four digits (for example, 0101). For a list of valid error codes, see UDC list 06/IT.
This section provides an overview of how to correct PDBA history integrity errors, lists prerequisites, and discusses how to:
Correct PDBA history integrity errors manually.
Correct PDBA history integrity errors automatically.
After you run the PDBA History Integrity report in proof mode and review the errors, you must correct the errors so that the quarterly reports and year-end forms are accurate.
Running the integrity report in update mode automatically corrects certain errors, such as a missing tax ID code. To correct other errors, such as an invalid number of periods, you must manually revise the payroll data before you run the report in update mode.
After you run an integrity report in update mode, you should run it again in proof mode to produce an error-free report. When the system finds no errors, it generates only the cover page.
If the PDBA History Integrity report does not generate errors, the review form does not enable you to review information. This form is used only to review and revise errors that are generated by the report.
After you run the Payroll Month version of the PDBA Integrity report (R077021), you might need to enter some manual corrections before you run the report again. The payroll error code list helps you determine the actions that you must perform to correct each payroll history error that prints on the report. You might need to manually correct the history before running another integrity report in update mode. Correcting the history ensures that the correct calculated totals print on the quarterly tax reports and year-end forms. For example, you might need to modify the gross pay amount for one month for a particular pay type.
You can correct certain payroll history errors by revising the monthly history for a pay type, deduction, benefit, or accrual. To revise monthly PDBA history, use the PDBAs Integrity Report Review program (P077002). This program updates the F06146 table.
Important: This program must have the highest possible level of system security because when you revise payroll history manually:The system does not update the JD Edwards EnterpriseOne General Accounting system. You must manually enter the appropriate journal entries. The system does not create an audit trail of the changes that you enter when you revise payroll history manually. |
After reviewing the Payroll Month PDBA Integrity report and making any manual corrections, you generate the report in update mode to update the F06146 table with the corrected information. Errors that are corrected automatically are corrected when you generate an integrity report in update mode.
Consult the payroll error code list for information that you need to correct before you generate the integrity report in update mode.
You can correct these errors by running the Payroll Month PDBA Integrity report in update mode after you have made the necessary corrections as instructed for each error on the error code list:
0103 - Tax ID does not exist.
0104 - Tax ID does not match.
Before you correct PDBA history integrity errors:
Review the error codes that appear on the report.
Set the processing mode to Update in the processing options for the Payroll Month PDBA Integrity report, if you are correcting errors automatically, to generate the report and update the table.
Access the Work With PDBAs Review form.
To correct PDBA history integrity errors manually:
Complete one or more of these fields, and click Find:
Company
Error Code
Year
History Type
Skip to Employee
Review the errors that appear in the detail area, and complete the following steps, as necessary.
Complete steps 4 and 5 to enter or correct a corporate tax ID number.
Select Corp Tax ID (corporate tax IDs) from the Form menu on Work With PDBAs Review.
Enter the necessary changes on Work With Corporate Tax ID's.
Complete steps 7 through 9 to void a payment.
Select a record in the detail area on Work With PDBAs Review.
Select Payment History from the Form menu.
Complete the steps for voiding a payment on Work With Payment History.
Complete steps 11 through 13 to enter or correct PDBA history.
Select a record in the detail area on Work With PDBAs Review.
Select History Rev (history review) from the Row menu.
Make any necessary corrections to any of the information in these fields on PDBAs by Payroll Month, and then click OK:
Amount
Pay Basis
Pieces
This section provides an overview of how to repost payroll history, lists prerequisites, and discusses how to:
Repost the tax ledger to the tax summary.
Set processing options for Repost Tax Ledger to Tax Summary (R07136).
Repost pay types to the payroll month.
Set processing options for the Payroll Repost - F0618 to F06146 program (R07146A).
Repost DBAs to the payroll month.
Set processing options for Repost DBAs to Payroll Month (R07146B).
Repost DBAs to the calendar month.
Repost DBAs to the tax area summary.
Set processing options for Repost DBA's to Tax Area Summary (R07148).
Repost the workers compensation summary.
In rare instances, you might encounter a history integrity problem that you cannot correct by running an integrity report in update mode or by revising payroll history manually. For example:
During the final update, a machine failure or power outage might prevent the system from updating the summary history tables.
While revising pay and tax amounts by month, you might have entered an incorrect gross pay amount.
In these instances, you can usually repost to correct the problem. A repost program retrieves the information in a detail history table by payment date and recalculates the totals in the corresponding summary history table. If you revised or corrected the summary history table and want to keep the changes, you should not run a repost. Except for maximum amount taxes such as FICA and Medicare, the repost will not include the revisions that you made to the history summary table.
Repost the tax ledger to the tax summary if the F06136 table contains corrupt data. This repost totals the tax transactions in the F06166 table by year, home company, tax type, tax area, tax ID, and employee number. It then posts these totals as one summary transaction to the F06136 table. The summary transaction includes these totals by month for each year that is processed:
Gross pay.
Excludable gross.
Pay in excess of annual limit for tax calculation.
Taxes withheld.
The repost program summarizes information by check date. In addition, it overwrites existing totals in the summary table.
Repost pay types to the payroll month if the F06146 table contains corrupt data. This repost process totals the pay type transactions in the F0618 table and posts monthly totals for gross pay and hours to the F06146 table. The repost summarizes by check date and overwrites existing totals in the F06146 table.
Repost DBAs to the payroll month if the information in the F06146 table does not correspond to the detail information in the F0719 table. For each employee, this repost calculates monthly totals for each DBA type. It then posts these totals to the F06146 table. The repost summarizes by check date and overwrites existing totals in the F06146 table.
Repost DBAs to the calendar month if the information in the F06145 table does not correspond to the detail information in the F0719 table. For each employee, this repost calculates monthly totals for each DBA type. It then posts these totals to the Calendar Month DBA Summary History File table. The repost program summarizes by work date. It overwrites existing totals in the F06145 table.
Repost DBAs to the tax area summary if the information in the F06148 table does not correspond to the detail information in the F0719 table. For each employee, this repost totals the amounts for all transactions that have the same tax area, DBA type, year, tax ID, and company number. It then posts the total, as one summary transaction, to the F06148 table. The repost overwrites existing totals in the F06148 table.
Repost the workers compensation summary when the information in the F0627 table does not correspond to the detail information in the F0618 table. This repost summarizes, by payment month and year, the workers compensation and general liability amounts in the F0618 table. It then posts this summary to the F0627 table. This repost adds information to the history summary table. It does not overwrite any existing information.
If you have not set up a corporate tax ID for the workers compensation and general liabilities tax types, the system enters the Federal A tax ID for U.S. Payroll and the Federal Tax ID for Canadian Payroll.
Before you complete the tasks in this section:
Back up all summary tables that you need to repost.
Contact JD Edwards Technical Support for customer support.
Select Advanced and Technical Operations (G07BUSP3), Repost Tax Ledger to Tax Summary.
Set these processing options before you repost Tax Ledger to Tax Summary.
Specify the tax area to repost. This code 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.
Specify the tax type to repost. This code identifies the type of payroll tax that is being processed. This is a UDC (07/TX). To set up state minimum wage amounts, you must enter MW in this field. To do so, you must first add MW to UDC 07/TX. However, you should not change the codes and definitions that are provided with the software.
Specify the year to repost. Enter this as a two-digit number. If you leave this processing option blank, the program uses the system date.
Specify the month to repost. If you leave this processing option blank, the system will repost all months for the specified year.
Specify an employee to repost. If you leave this processing option blank, the system will repost all employees.
Select Advanced and Technical Operations (G07BUSP3), Repost Pay Type to Payroll Month.
Set this processing option before you run the Payroll Repost - F0618 to F06146 program.
Specify the year to repost. Enter this as a two-digit number. If you leave this processing option blank, the program uses the system date.
Select Advanced and Technical Operations (G07BUSP3), Repost DBAs to Payroll Month.
Set this processing option before you repost DBAs to Payroll Month.
Specify the year to repost. Enter this as a two-digit number. If you leave this processing option blank, the program uses the system date.
Select Advanced and Technical Operations (G07BUSP3), Repost DBAs to Payroll Month.
Select Advanced and Technical Operations (G07BUSP3), Repost DBAs to Tax Area Summary.
Set this processing option before you repost DBAs to Tax Area Summary.
Specify the year to repost, including the century. If you leave this processing option blank, the system will repost all years.