This appendix contains the following topics:
Section A.1, "JD Edwards EnterpriseOne Canadian Payroll Reports: A to Z"
Section A.2, "JD Edwards EnterpriseOne Payroll for Canada Reports: Selected Reports"
The reports listed in each table are sorted alphanumerically by report ID.
| Report ID and Report Name | Description | Navigation |
|---|---|---|
| R00067 | 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 | 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 | 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 | 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 | 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 |
| Monika: R77870
Update Appropriate Tax Area To Employee Based On Time Entry |
Use this program to update Employee Master (F060116) with the applicable tax area based on the evaluation of timecards. | Canada Advanced and Technical Operations (G07BUSCAP3), Update Appropriate Tax Area To Employee Based On Time Entry |
| R770631B | 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 | 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 | 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 | Use this program to review workers compensation insurance amounts. | Canada History Reports (G77BCAP15), Workers Comp/Gen Liability |
| R773660 | 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 | 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 |
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.
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 check 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 enable you to specify the default processing for programs and reports.
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 check date. |
If the processing option value is zero, the current system year is assumed.
Specify the version for the report. If left blank, the system uses version XJDE0001.
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 enable you to specify the default processing for programs and reports.
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.
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.
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 enable you to specify the default processing for programs and reports.
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
Specify the ending date for the report. You must enter the date in the format MMYYDD. Values are:
Blank: Current Date
A valid date
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.
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.
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. |
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 check 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 check 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 enable you to specify the default processing for programs and reports.
Use these processing options to specify the month, year, and company for the report as well as which summary and detail tables to compare.
Specify the year for which the report should audit history information.
|
Note: Enter the year using four digits (for example: 2007). |
Specify the specific month for which the report should audit history information.
|
Note: Enter the month using two digits (for example: January equals 01). |
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.
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.
Specify the company for which to run the audit reports.
|
Note: If you leave this processing option blank, the system audits all companies. |
When an employee works with multiple provinces in a pay period, the system calculates taxes based on the employee master details. The Update Appropriate Tax Area To Employee Based On Time Entry report updates the Employee Master (F060116) with the applicable tax area based on the evaluation of timecards. You must enter the appropriate dates for time cards in the processing options.
You run this report prior to payroll processing to update F060116 with the Vertex GeoCode for the appropriate tax area or province.
The Update Appropriate Tax Area To Employee Based On Time Entry report updates the new tax area entered in the employee's timecard based on these rules:
If multiple time cards are entered for an employee in a pay period with different tax areas and different hours worked, the system updates F060116 with the tax area having the largest value for the sum of hours worked.
If multiple time cards are entered for an employee in a pay period with different tax areas and same hours worked, the system updates F060116 with the timecard having the latest work date.
Processing options enable you to specify the default processing for programs and reports.
Specify whether to update the work tax area of F060116 with the appropriate tax area. Values are:
0: Run the report in proof mode to just display the value for work tax area.
1: Run the report in final mode to update the employee master with work tax area.
Specify the date range for the time cards that the report should scan for obtaining the tax area for the report.
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. |
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.
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.
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.
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 enable you to specify the default processing for programs and reports.
Specify whether to print errors or print and update errors. Values are:
0: Print errors.
1: Print and update 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. |
Specify the four-digit year to be processed. If you leave this processing option blank, the system processes all years.
Specify the maximum amount of pensionable earnings from which to deduct CPP or QPP.
Specify the basic yearly exemption for CPP or QPP.
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.