This chapter contains these topics:
Section 27.1, "Verifying the Integrity of Payroll Summary History,"
Section 27.7, "Verifying That Integrity Errors Have Been Corrected."
You should regularly verify the integrity of your payroll summary history to ensure that the correct information prints on your quarterly tax reports and employees' year-end forms. To verify payroll summary history integrity, run reports that locate missing, inaccurate, or incomplete information in the summary history tables.
Verifying the integrity of payroll summary history includes:
Reviewing the Tax History Integrity Report
Reviewing the PDBA Integrity Report
Reviewing the DBA Integrity Report
Correcting Integrity Errors Manually
Correcting Integrity Errors Automatically
Verifying That Integrity Errors Have Been Corrected
To complete these tasks, you must run each integrity report at least three times:
Identify the errors
Correct the errors
Produce clean reports
The following table lists the payroll summary history integrity reports and their corresponding summary history tables.
To identify integrity errors, run the integrity reports in proof mode. When you run an integrity report in proof mode, it identifies possible errors without changing any information in your history tables. You should run integrity reports in proof mode so that you can research errors and enter any manual corrections before you begin updating the table.
Integrity reports identify three types of information:
Errors that are not really errors. For example, zero Federal tax withheld might be a valid condition for a low-wage earner or a tax exempt employee.
Errors that you must correct manually.
Errors that the program corrects when you run the report in update mode.
To help you determine the action you must take to correct integrity errors, you can review an explanation of each error code that prints on the integrity reports.
To correct integrity errors, run the integrity reports in update mode or use history revision forms to enter manual corrections. When you run an integrity report in update mode, the system corrects information in the summary history table and prints a report listing the errors that it could not correct. You should investigate all errors and rerun the integrity reports until all valid errors are corrected.
You should run payroll history integrity reports 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.
On the Corporate Tax IDs form, remove any dashes or spaces from the tax ID for the Federal A (U.S.) tax area. If this tax area contains punctuation or spaces, you will not be able to print year-end forms for employees. See Section 54.4, "Setting Up Corporate Tax IDs."
See Also:
Section 28.3, "Reviewing the Final Update Integrity Reports" for information about printing integrity reports during final update.
From Payroll Master (G07), enter 27
From Payroll Advanced/Technical Operations (G073), choose Data Integrity/Global Updates
From Data Integrity/Global Updates (G0731), choose Taxation History
Use the Tax History Integrity Report to identify errors in your Taxation Summary History (F06136) table. You use the information in this table to produce governmental, year-end forms for employees. When you keep this table free of errors, you simplify the year-end processing tasks.
Enter the appropriate tax earnings limitations and rates in the processing options. Without these figures, the system cannot identify certain errors.
Figure 27-1 Tax History Integrity Report
Specify the last two digits of the current year in the data selection.
If all companies within your organization have the same paymaster, do not include home company in your selection criteria.
Do not change the data sequence of the report.
The following list briefly explains the error codes (07/IX) that might show on the Tax History Integrity report.
From Payroll Master (G07), enter 27
From Payroll Advanced/Technical Operations (G073), choose Data Integrity/Global Updates
From Data Integrity/Global Updates (G0731), choose Payroll Month PDBAs
Use the PDBA Integrity Report to identify errors in your Payroll Month PDBAs Summary History table (F06146). This table contains the adjustment amounts that you might need to add to taxable wages or report in other detail boxes on the year-end forms. These amounts might include 401(k) contributions, moving expenses, group term life insurance premiums, and so on. When you keep this table free of errors, you simplify the year-end processing tasks.
Specify the last two digits of the current year in the data selection.
Do not change the data sequence of the report.
The following list briefly explains the error codes (07/IT) that might show on the PDBA Integrity report.
From Payroll Master (G07), enter 27
From Payroll Advanced/Technical Operations (G073), choose Data Integrity/Global Updates
From Data Integrity/Global Updates (G0731), choose Calendar Month PDBAs
Use the DBA Integrity Report to identify errors in your Calendar Month DBA Summary History table (F06145). When you keep this table free of errors, you simplify the year-end processing tasks.
Figure 27-3 Transaction History Integrity report
Specify the last two digits of the current year in the data selection.
Do not change the data sequence of the report.
The following list briefly explains the error codes that might print on the DBA Integrity report. These codes are defined in user defined codes table 07/ID.
From Payroll Master (G07), enter 27
From Payroll Advanced/Technical Operations (G073), choose Data Integrity/Global Updates
From Data Integrity/Global Updates (G0731), choose an option under the Revise History Files heading
You can use the following programs to correct integrity errors manually:
Pay and Taxes by Month
Pay and Taxes by Check
PDBAs by Payroll Month
DBAs by Calendar Month
After you run an integrity report in proof mode, you must research each error on the report. The Payroll system provides error code tables that describe each type of payroll history integrity error. Use these error code tables to determine the action, if any, that you must perform to correct each error. You must correct these errors so that your quarterly reports (U.S. only) and year-end forms will be accurate.
Some integrity errors require that you make manual corrections to the appropriate history or constants tables before you run the report in update mode. You might need to manually revise history records, tax area constants, or corporate tax IDs. For example, you might need to:
Delete a record that contains zero dollars
Enter a tax ID number
For each error that prints on the report, determine the action, if any, that you must perform to correct it. Some entries on the report might not be errors for your setup. For example, taxation error 0250 - No Federal Tax Taken might print for an employee who is a low wage earner and does not need to have any Federal tax withheld. Review the user defined code lists 07/IX, 07/IT, and 07/ID to determine the action you need to take for each error.
After you revise payroll history manually, the summary totals do not equal the detail totals.
Caution:
The system does not create an audit trail of the changes you make when you revise payroll history manually. Therefore, you should assign these programs the highest possible level of system security.See Also:
Chapter 29, "Revise Payroll History Manually" for information about correcting errors manually.
From Payroll Master (G07), enter 27
From Payroll Advanced/Technical Operations (G073), choose Data Integrity/Global Updates
From Data Integrity/Global Updates (G0731), choose the report you want to correct
After you review an integrity report and make any manual corrections, run the report in update mode to update the summary history table with the corrected information. 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.
When you run the report in update mode, the system also corrects the errors it can correct and prints a report listing the errors it cannot correct.
The following list shows the errors you can correct by running each integrity report in update mode. These errors require manual corrections to your system setup before you run the report in update mode.
Report | Errors |
---|---|
Tax History Integrity Report |
|
PDBA Integrity Report |
|
DBA Integrity Report |
|
Each time you run an integrity report in update mode, the system creates a backup table of the summary history table as of the previous run. Therefore, if you run a report in update mode and receive unexpected results, you can restore your data to the way it was before the update. The system re-creates this table each time you run the integrity procedure. JD Edwards World recommends that you call customer support for help in restoring the backup.
After you run the report in update mode, run it a third time, in proof mode, to ensure that all errors have been corrected. You should investigate all errors and rerun the integrity report until all valid errors are corrected. When the system finds no errors, it prints only the cover page.