This chapter contains these topics:
Section 36.4, "Setting Up the Time and Pay Exception Report"
Section 36.6, "Setting Up the Workers Compensation Insurance Register"
Section 36.10, "Setting Up the Interim Cheque Integrity Report"
Setting up payroll cycle reports allows you to set up your own versions of the reports generated during a payroll cycle. If you do not set up your own versions, the system uses the DEMO version that JD Edwards World provides. Setting up your own version allows you to customize the title of the report, change the sequence, and meet your company's reporting needs.
When you select one of these reports as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.
Setting up payroll cycle reports consists of the following tasks:
Setting Up the Payroll Register
Setting Up the Summary Payroll Register
Setting Up the Time and Pay Exception Report
Setting Up the Transaction Audit Report
Setting Up the Workers Compensation Insurance Register
Setting Up the DBA Register
Setting Up the Time and Pay Register
Setting Up the Terminated Employees Report
Setting Up the Interim Cheque Integrity Report
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay Cycle Report Setup
From Pay Cycle Report Setup (G7746), choose Payroll Register
Use the Payroll Register to verify that the employees' gross-to-net amounts are correct. You can review employee earnings for this payroll cycle. The report lists the following information and can be sequenced and totaled to meet your company's needs:
Pay types, deductions, benefits, and accruals for each employee
Totals by pay types, deductions, benefits, and accruals for each business unit
Totals by pay types, deductions, benefits, and accruals for each company
Grand totals by pay types, deductions, benefits, and accruals for all companies in the payroll version
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay Cycle Report Setup
From Pay Cycle Report Setup (G7746), choose Summary Payroll Register
The Summary Payroll Register lists one line per cheque, and shows which employees' gross-to-net calculations are incorrect. If you are processing payroll for a large number of employees, you might find it easier to use the Summary Payroll Register to review employees' gross-to-net earnings instead of the Payroll Register.
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay Cycle Report Setup
From Pay Cycle Report Setup (G7746), choose Time & Pay Exception
When you request the Time and Pay Entry Journal during pre-payroll processing, the system prints the Time and Pay Exception report only if exceptions occur. Use this report to identify employees whose timecards might contain errors. For example, this report lists employees whose hour or rate amounts are more than the maximum or less than the minimum amounts you specified in the processing options for this report.
If you set up Enhanced Subledger Accounting, you can view these values on the report. See Work with Enhanced Subledger Accounting in the JD Edwards World General Accounting I Guide for more information.
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay Cycle Report Setup
From Pay Cycle Report Setup (G7746), choose Transaction Audit Report
You use the Transaction Audit report to review deduction, benefit, and accrual information for all employees in your payroll cycle.
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay Cycle Report Setup
From Pay Cycle Report Setup (G7746), choose Workers Comp Insurance register
The Workers Compensation Insurance Register lists detailed workers compensation information for all employees included in the pre-payroll processing. This report provides subtotals along with each employee's workers compensation code, work state, company, and grand totals. You must process journal entries prior to running this report, because the system calculates this information during the journal entry step of the payroll cycle.
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay Cycle Report Setup
From Pay Cycle Report Setup (G7746), choose DBA Register
The DBA Register includes the same information as the Transaction Audit report (Deduction/Benefit/Accrual report), but it lists all employees in the pre-payroll processing by deduction, benefit, and accrual.
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay Cycle Report Setup
From Pay Cycle Report Setup (G7746), choose Time and Pay Register
The Time and Pay Register lists the time and pay totals for the current payroll. You can choose to include employee totals on the report. Processing options determine what data is printed on the report. When you request this report in pre-payroll, the system prints the Time and Pay Exception report.
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay Cycle Report Setup
From Pay Cycle Report Setup (G7746), choose Terminated Employees Report
The Terminated Employees report lists those employees whose employment with the company has ended during the pay period.
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay Cycle Report Setup
From Pay Cycle Report Setup (G7746), choose Cheque Integrity Report
The Interim Cheque Integrity report lists the gross and tax amounts for all tax types for each interim cheque. The report also compares the totals between the Interim Vertex Workfile (F0712I) and the Tax History Summary table (F0713). You use this report to spot any discrepancies and correct them.