Setting Up Pension Records
The Pension Information Maintenance programs are designed to provide a mechanism to accumulate a user's pension information for use in preparing T4A's. This is also the method to enter pension numbers and pension adjustment amounts to the T4's and Relevé 1.
JDE does not provide a method to calculate the pension information. This is only a vehicle to collect the necessary data to print and complete the year end reports.
A pension information record should be setup for each employee who will receive a T4A or will need a pension adjustment amount displayed on their T4(s). Multiple records must be setup for an employee who has different tax areas and/or different tax id's.
To print a pension number or pension adjustment on an employee's T4 or T4A form, you set up pension records. You can create pension records for groups of employees based on payroll history information. You can also enter pension information and pension adjustment amounts for individual employees.
When you build the year-end workfile, the system generates T4A records for employees for whom records exist in the Tax History File table (F0713) with a tax history type of P, J, K, or L (UDC 07/TH).
You can manually create a T4 or T4A after you run the workfile build for an employee who does not have a pension record but requires a T4 or T4A year-end form. You cannot manually create Relevé 1, Relevé 2, or NR4 records.
See Creating a T4A Year-End Form Manually or Creating a T4 Year-End Form Manually for more information.
Setting up pension records includes the following:
Creating multiple pension records
Creating individual pension records
Creating T4A forms for non-pensioners
Creating Multiple Pension Records
Navigation
From T4/Relevé Setup (G772472), choose Pension Batch Update
Users can create pension records for groups of employees based on payroll history information.
The Pension Batch Update program creates pension records in the Canadian Pension Information File table (F07727) for groups of employees by using information in the Payroll Month PDBA Summary (F06146) and Employee Master (F060116) tables. You can select groups of employees for whom you want to create pension records.
The program creates one record for each employee whose Payroll Month PDBA Summary and Employee Master information matches the selection criteria. You might create multiple records for any employee who worked in more than one tax area or under more than one tax ID.
You can use special handling codes to create T4A records automatically for employees who do not have any qualifying pension history records. See Working with Special Handling for more information.
Processing Options
Data Selection
You can use data selection to select groups of employees for whom you want to create pension information.
For example, you might set up a category code to designate certain employees and then use that category code as your data selection. Alternatively, you might select all employees who have history for a specific PDBA code.
You must specify the year you are processing in the data selection as well as in the processing options.
Creating Individual Pension Records
You can enter a pension plan number and the pension adjustment amounts that you need to report for individual employees.
You might need to enter a pension adjustment for an individual employee if the employee made voluntary contributions that exceeded the payroll deduction amount and you did not withhold tax on that amount.
When you enter a pension adjustment, you might create multiple records for any employee who worked in more than one tax area or under more than one tax ID.
The Pension Information Maintenance program creates or updates records in the Canadian Pension Information File table (F07727).
To create individual pension records
Navigation
From T4/Relevé Setup (G772472), choose Pension Info. Maintenance
On Pension Info. Maintenance, complete the following fields and click Add:
Year
Employee/SIN
Home Company
Tax Area
Tax ID
Pension Plan Number
Pension Adjustment
T4A (Y/N)

Field |
Explanation |
---|---|
Pension Plan Number |
The seven-digit registration number that is issued for the employees' pension plan or deferred compensation profit-sharing plan. Screen-specific information The pension plan numbers that you enter on this screen must exist in user defined code table 77/PN. |
Pension Adjustment |
The amount of the pension adjustment that you want to print on the T4 or T4A. |
T4A (Y/N) |
A code that specifies where the system prints the pension plan number and pension adjustment. Valid values are: Y – Print the pension plan number and pension adjustment on a T4A form N – Print the pension plan number and pension adjustment on a T4 form (default) |
Creating T4A Forms for Non-Pensioners
There are three ways to create T4A records for Non-Pensioner:
Automatically during the workfile build by creating Pension records.
Automatically during the workfile build by special handling amounts into T4A boxes.
Manually after the workfile build.
To create T4A forms automatically for non-pensioners by creating pension records
Prior to running the Build T4/Relevé Workfiles program, ensure that you create individual pension records with the T4A (Y/N) field set to Y using either the Pension Info. Maintenance program or the Pension Batch Update. See Creating Individual Pension Records or Creating Multiple Pension Records
To create T4A forms automatically for non-pensioners by special handling
Prior to running the Build T4/Relevé Workfiles program, ensure that you add amounts to specific boxes on the T4A form using special handling codes.
Navigation
From Canadian Year End Processing (G77247), choose Build T4/Relevé Workfiles
On the first Build T4/Relevé Workfiles screen, complete the following field and click Enter twice:
T4/Relevé ID
On the second Build T4/Relevé Workfiles screen, choose Special Handling Code Review (F15) to access special handling codes.
On Special Handling Code Review, choose T4A (F5) to access special handling codes for the T4A form.
Enter the appropriate PDBAs for the severance pay for either or both of the following boxes on the T4A form:
016 - Pension or Superannuation
028 - Other Income
For more information about entering special handling codes, see Working with Special Handling.
To generate T4A forms by attaching a pay type to a special handling code, you must repost pay types as well as DBAs to the Tax Area Transaction table (F06148). See Reposting Tax Area Information for more information.
To create T4A forms manually after the workfile build
You can manually create individual T4A forms after the workfile build. This might be necessary if a terminated employee contributes severance pay to a retirement plan or a retired employee receives pension income but no employment income. You cannot manually create Relevé 1, Relevé 2, or NR4 records. See Revising Year-End Information for information creating a T4A year-end form manually.
Before You Begin
Prior to running the Build T4/Relevé Workfiles program, ensure you create an individual pension record with the T4A field set to Y.
To generate T4A forms by attaching a pay type to a special handling code, you must repost pay types as well as DBAs to the Tax Area Transaction table (F06148). See Reposting Tax Area Information for more information.
To create T4A forms manually for non-pensioners
Navigation
From Canadian Year End Processing (G77247), choose Build T4/Relevé Workfiles
On the first Build T4/Relevé Workfiles screen, complete the following field and click Enter twice:
T4/Relevé ID
On the second Build T4/Relevé Workfiles screen, choose Special Handling Code Review (F15) to access special handling codes.
On Special Handling Code Review, enter the appropriate PDBAs for the severance pay for any or all of the following boxes on the T4A form:
016 - Pension or Superannuation
028 - Other Income