## Appendix: JD Edwards EnterpriseOne Canadian Payroll Reports

This appendix provides an overview of JD Edwards EnterpriseOne Canadian Payroll reports and enables you to view a summary table of all reports.

### JD Edwards EnterpriseOne Canadian Payroll Reports: A to Z

The reports listed in each table are sorted alphanumerically by report ID.

Report ID and Report Name | Description | Navigation
R00067 Business Unit Translation Report | Use this program to review the business unit description translations in the base language, and one or all of the additional languages that the business uses. | Organization & Account Setup (G09411), Business Unit Translation Report
R77015 EI Integrity | Use this program to find discrepancies between the F06176 table and the F0713 table. This program ensures that the gross earnings and EI contribution amounts are the same in the two tables. | Canada Advanced and Technical Operations (G07BUSCAP3), EI Integrity Report
R77020 F06176 Hour Validation | Use this program to find and correct discrepancies between the F06176 table and the F0618 table. This program ensures that no discrepancies exist in insurable hours worked for employment insurance. | Canada Advanced and Technical Operations (G07BUSCAP3), F06176 Hour Validation
R77323 Employee Earnings and Tax Register | Use this program to review an individual employee's taxes and the pay amounts on which those taxes are based. At year-end, use the Employee Pay and Tax Register report to verify the information that you print on employees' year-end forms. | Canada History Reports (G77BCAP15), Employee Earnings and Tax Register
R77703 Canadian Payroll History Audit | Use this program to ensure that the system records the correct amounts on the tax and year-end reports. Run the Canadian Payroll History Audit Report (R77703) each month and before you process year-end reports. You should correct any variances that appear on this report before you print tax or year-end reports. | Canada History Reports (G77BCAP15), Canadian Payroll History Audit Report
R770631B Print ROEs/Update History | Use this program to print Record of Employment (ROE) forms, and update ROE history. You create ROEs when an employee has a separation from work. | ROE Processing (G77BCAP16), ROE Workbench On the Work With ROEs form, select the ROEs that you want to print, and then select Print Multi ROEs from the From menu. Complete the fields on the form and click OK to process the report.
R773162 Provincial Tax Distribution Summary | Use this program to provide current, month-to-date, quarter-to-date, and year-to-date totals for taxable wages and tax amounts that are withheld for Quebec provincial taxes and pension deductions. | You run this report when you process a payroll cycle. Coordinate with the payroll department to ensure that the report is set up to run as part of the payroll cycle.
R773170C Federal Tax Distribution Summary | Use this program to determine the federal tax burden for a payroll cycle. Printing this report during pre-payroll enables you to promptly submit federal taxes. | You run this report when you process a payroll cycle. Coordinate with the payroll department to ensure that the report is set up to run as part of the payroll cycle.
R773601 Workers Compensation Register | Use this program to review workers compensation insurance amounts. | Canada History Reports (G77BCAP15), Workers Comp/Gen Liability
R773660 Employment Insurance Register | Use this program to list the Employment Insurance (EI) rates. The report also includes information for each employee on the payroll. | You run this report when you process a payroll cycle. Coordinate with the payroll department to ensure that the report is set up to run as part of the payroll cycle.
R777011 F0713 Integrity | Use this program to identify errors in the F0713 table. You use the information in this table to produce governmental, year-end forms for employees and people such as former employees or contractors to whom you pay pensions, retiring allowances, or other payments for income. | Canada Advanced and Technical Operations (G07BUSCAP3), F0713 Integrity Report

### JD Edwards EnterpriseOne Payroll for Canada Reports: Selected Reports

Some reports include a more detailed description, as well as information about processing options. These reports are listed alphanumerically by report ID in this appendix.

#### R77015 - EI Integrity

You run the EI Integrity Report (R77015) to find discrepancies between the F06176 table and the F0713 table. This program ensures that the gross earnings and EI contribution amounts are the same in the two tables.

This program summarizes all records for each employee in the F06176 table by tax type CC and compares the results with the amounts in the F0713 table.

If the yearly totals for EI insurable earnings in the F06176 table do not match the gross earnings minus excludables minus in-excess in the F0713 table, the program marks the records. The program then compares the records in the F06176 table with the records in the F0716 table by cheque control number to locate specific records that do not match. The program then produces the EI Integrity F0716/F06176 Exceptions report (R77015).

The EI Integrity Report produces a second exception report, the EI Integrity Validation report (R77016). This report contains errors if any of these conditions exist:

- The amount of insurable earnings is greater than the maximum EI earnings.

- The tax ID in the F06176 table does not match any of the corporate tax IDs that are set up for the company in the F069086 table.

- The employee number does not exist in the F060116 table.

- The company number does not exist in the F069086 table.

- The maximum EI earnings do not exist for the company.

- The employee record does not exist in the F0716 table.

- The amount of insurable earnings or tax does not match the amount in the F0716 table.

In the processing options of the EI Integrity Report program (R77015), you must specify the version of the EI Integrity Validation report (R77016) that you want to run. You use the data selection on the EI Integrity Validation report to select the employees for that report.

The EI Integrity Report reads information from the F06176, F0713, and F0716 tables. It does not update these tables.

#### Processing Options for EI Integrity (R77015)

Processing options enable you to specify the default processing for programs and reports.

EI Integrity

1. Enter the Year you want the EI Integrity to generate: (Enter a 4 Digit Year) | Specify the year for which the system generates a report. Note. Data selection must only include records for the year entered. Data selection should be by cheque date. If the processing option value is zero, the current system year is assumed.

Versions

1. Version for EI Integrity Validation (R77016). | Specify the version for the report. If left blank, the system uses version XJDE0001.

#### R77020 - F06176 Hour Validation

You run the F06176 Hour Validation report (R77020) to find and correct discrepancies between the F06176 table and the F0618 table. This program ensures that no discrepancies exist in insurable hours worked for employment insurance.

You can run this program in either verification or update mode. However, you must run the program in verification mode before you can run it in update mode. Running the program in verification mode sets a flag that the program uses when you run it in update mode.

When you run the F06176 Hour Validation program in verification mode, the system compares the number of hours for each employee in table F06176 with those in table F0618. If the totals do not match, the system performs one of the these actions:

- If no corresponding records exist in the F0618 table, the system prints an error message on the report (No time card control record).

- If the totals differ, the program updates the YSYST2 field in table F06176 with an H for records whose hours do not match the hours in table F0618. The H indicates that the program will correct the problem when you run it in update mode.

The system also produces an exception report. You can use this report to determine the cause of the discrepancy. Before you run the program in update mode, you can manually reset the flag for certain records to prevent the program from updating them. You can reset the flag using the EI Update field in the EI History program (P776176).

When you run the program in update mode, the system locates the discrepancies that it identified in verification mode. For these records, the system adds the accumulated hours from the F0618 table to the F06176 table. This resolves the discrepancy between the tables.

The system also prints the EI Hour Integrity Update Report (R77020U), which displays the changes made to the F06176 table.

Note. The F06176 Hour Validation program (R77020) excludes PDBAs that have a tax type of * (Non-Taxable), CI (Exempt Hours - EI Exempt Hours), or CC (Canada Employ Ins. - employee). PDBAs that are set up with these exemptions are not compared between the Unemployment Insurance History File table and the Employee Transaction History table.

#### Processing Options for F06176 Hour Validation (R77020)

Processing options enable you to specify the default processing for programs and reports.

EI Hour

1. Enter a 1 to run this report in update mode. | Specify the mode for the report. A value of blank will create a verification report only. Note. Run the report in verification mode before you run it in update mode. When you enter 1 in this processing option, the system generates the R77020U report.
2. Enter the year you want the EI Hour Integrity to generate: (Enter a 4 Digit Year) | Specify the applicable year for the report, including century. Note. Limit data selection to include records for only the year entered. Data selection should be by check date. If the processing option value is zero, the current system year is assumed.

#### R77323 - Employee Earnings and Tax Register

Use the Employee Earnings and Tax Register (Canadian) report (R77323) to review an individual employee's taxes and the pay amounts on which those taxes are based. You can review gross pay, excludable wages, taxable wages, excess pay, and actual taxes for each tax type. You can review month-to-date, quarter-to-date, year-to-date, and grand totals.

At year-end, you can use the Employee Pay and Tax Register report to verify the information that you print on employees' year-end forms.

The system retrieves information for the earnings and tax history reports from the F0713 table. In addition, the system retrieves information from the F0716 table when you print the Employee Pay and Tax Register report.

#### Processing Options for Employee Earnings and Tax Register (R77323)

Processing options enable you to specify the default processing for programs and reports.

Report Options

1. Employee Number Format | Specify the type of employee number you want to print on the report. Values are: 1: Address Book Number (default) 2: Social Insurance Number 3: Third Employee Number
2. Date: Ending Period (MMDDYY) | Specify the ending date for the report. You must enter the date in the format MMYYDD. Values are: Blank: Current Date A valid date
3. Type Of History | Specify the type of history detail that is required on the report. Values are: 1: Quarter-to-date with monthly balances. 2: Quarter-to-date totals only. 3: Year-to-date with monthly balances. 4: Year-to-date with quarterly balances. 5: Year-to-date totals only.
4. Print Detail Transaction | Specify whether to include detailed transactions when printing monthly totals. Values are: 0: Suppress 1: Print This option applies only if you are printing the report with MONTHLY totals.
5. Page Breaks | Specify the type of report page breaks that are required. Values are: 0: Print one employee per page (default) 1: Print multiple employees per page Note. This option only applies when requesting monthly totals.

#### Canadian Payroll History Audit (R77703)

To ensure that the system records the correct amounts on the tax and year-end reports, you should run the Canadian Payroll History Audit Report (R77703) each month and before you process year-end reports. You should correct any variances that appear on this report before you print tax or year-end reports.

The Canadian Payroll History Audit Report compares detail history information with summary history information and produces an exception report listing any inconsistencies between the summary and detail history information. This report does not make any corrections to the summary or detail tables.

Note. The Canadian Payroll History Audit Report verifies that tax type CA exists for every employee that has a record for any of the following tax types in the F0713 table: CB, CC, CD, CE, CF, CG, or CH.
If an employee does not have tax type CA, the year-end workfile will be invalid. Therefore, it is very important that you run the Canadian Payroll History Audit Report and correct any errors before you generate the year-end workfile.

You use the processing options to specify whether this report compares basic history information, pay cheque history information, or both.

If you choose to compare basic history information, the report compares the information in these tables:

Summary Tables | Detail Tables
F0713 | F0716
F06145 | F0719
F06146 | F0618 and F0719
F06176 | F0716

If you choose to compare pay cheque history information, the report compares the information in these tables:

Summary Tables | Detail Tables
F06156 | F0716
F06156 | F0618
F06156 | F0719

Refer to UDC 77/ER for a list of error codes that might appear on the report.

#### Processing Options for the Canadian Payroll History Audit Report (R77703)

Processing options enable you to specify the default processing for programs and reports.

Process

Use these processing options to specify the month, year, and company for the report as well as which summary and detail tables to compare.

1. Enter Year for Audit Report. | Specify the year for which the report should audit history information. Note. Enter the year using four digits (for example: 2007).
2. Enter Month for Audit Report | Specify the specific month for which the report should audit history information. Note. Enter the month using two digits (for example: January equals 01).
3. Perform Basic History Audit. | Specify whether you would like to perform a basic history audit. The Basic Audit report compares these tables: F0713 to F0716 F06145 to F0719 F06146 to F0618/F0719 F06176 to F0716 Values are: 1: Perform. Blank: Do not run the Basic History Audit. 0: Do not run.
4. Perform Paycheque History Audit. | Specify whether you would like to perform a paycheck history audit. The paycheck history audit compares these tables: F06156 to F0716 F06156 to F0618 F06156 to F0719 Values are: 1: Perform. Blank: Do not run the Paycheque History Audit. 0: Do not run.
5. Company. | Specify the company for which to run the audit reports. Note. If you leave this processing option blank, the system audits all companies.

#### Reviewing the Provincial Tax Distribution Summary Report (R773162)

The Provincial Tax Distribution Summary report (R773162) provides current, month-to-date, quarter-to-date, and year-to-date totals for taxable wages and tax amounts that are withheld for Quebec provincial taxes and pension deductions. The Quebec provincial government requires this information.

You can print the Provincial Tax Distribution Summary report only during a payroll cycle. You cannot print reports from the Report Setup form.

Note. Quebec is currently the only province that collects a provincial tax.

#### Reviewing the Federal Tax Distribution Summary Report (R773170C)

You use the information on the Federal Tax Distribution Summary report (R773170C) to determine the federal tax burden for a payroll cycle. Printing this report during pre-payroll enables you to promptly submit federal taxes. The report displays totals of taxable wages and federal tax amounts for the current period, and also month-to-date. It also displays tax amounts by company for quarter-to-date and year-to-date periods.

You can print the Tax Distribution Summary report only during a payroll cycle. You cannot print reports from the Report Setup form.

#### Reviewing the Workers Compensation Register Report (R773601)

You can print the Workers Compensation Register report (R773601) to review workers compensation insurance amounts. Information listed in the report includes:

- Employee listing by company.

- Employee hours and gross wages.

- Employee job type and job step.

- Excludable and overtime wages.

- Premium amounts for each employee.

- Totals for each province and company.

- Grand totals for the report.

You can print the report in either of these formats:

- Detailed report that displays each line of time entry.

- Summary report that consolidates the information by employee, company, tax area, workers compensation code, job type, and job step.

The information that is provided in the Workers Compensation Register report is based on the F0618 table.

#### Reviewing the Employment Insurance Register Report (R773660)

The Employment Insurance Register report (R773660) lists the EI rates. The report also includes information for each employee on the payroll, including:

- Social Insurance Number.

- Current wages.

- Any excludable wages or amounts paid in excess.

- Taxable wages.

- EI rate (employment insurance).

- Current tax amounts.

#### R777011 - F0713 Integrity

You use the F0713 Integrity Report (R777011) to identify errors in the F0713. You use the information in this table to produce governmental, year-end forms for employees and people such as former employees or contractors to whom you pay pensions, retiring allowances, or other payments for income. Keeping this table error free simplifies year-end processing tasks.

#### Processing Options for F0713 Integrity (R777011)

Processing options enable you to specify the default processing for programs and reports.

Process

1. Processing Mode | Specify whether to print errors or print and update errors. Values are: 0: Print errors. 1: Print and update errors.
2. Error codes to omit from printing - leave blank to print all errors. | Specify the error that you do not want to print on the report. To print all errors, leave all fields for this processing option blank. Enter the four-digit code for each error 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 77Y/EC. Note. You cannot omit error code 0112.
3. Year to Process | Specify the four-digit year to be processed. If you leave this processing option blank, the system processes all years.
4. CPP/QPP Annual Wage Limit: | Specify the maximum amount of pensionable earnings from which to deduct CPP or QPP.
CPP/QPP Annual Exemption: | Specify the basic yearly exemption for CPP or QPP.
CPP/QPP Employee Contribution Rate: | Specify the rate that is used to calculate the CPP/QPP employee deduction amount. Enter the rate as a percentage. For example, if the CPP/QPP employee contribution rate is 4.7 percent, enter 4.7 in this processing option.