15 Processing Options

This chapter includes the following processing options:

15.1 Repost DBAs to Fiscal and Anniversary (P06147A)

Processing Option Processing Options Requiring Further Description
1. Enter the YEAR to be reposted.  

15.2 Employment Insurance History Rev. (P06176)

Processing Option Processing Options Requiring Further Description
1. Select on Tax ID's (Y/N):

(blank defaults to 'N')

  
2. Enter the current EI Rate for calculating Premiums.

NOTE: If this option is left blank, premiums will NOT be recalculated

 To recalculate premium amounts, you must include the percentage amount as a seven-digit number in the processing options. For example, enter 2.10% as 0021000.

15.3 Calendar Month Rollover (P063913)

Processing Option Processing Options Requiring Further Description
1. Enter the YEAR being closed.  
2. Enter a '1' to print the report without update.  
3. Enter a '1' next to the history which should be rolled over. a. Calendar Month history b. Payroll Month history  
4. Enter a '1' to rollover balances for terminated employees. (Terminated Employees are determined by a pay status of 'T').  
5. Select the employee number to print:

A = Address Book

B = Social Security

C = Third Employee Number

  
6. Enter a '1' to rollover vacation and sick accruals ONLY. (Not applicable for Calendar Month rollover).  
7. Enter a '1' to have vacation and sick dollar amounts printed on the report and added to the file. (Not applicable to Calendar Month Rollover).

NOTE: Dollars will not be rolled over for accruals that use certain Table Methods, regardless of whether there is a '1' in this processing option. See program helps for a list of these methods.

  
8. Enter the PDBA codes to roll over or leave blank for all.

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12.

  
9. Enter a '1' to roll only the accrued balance.

NOTE: This option should only be used on paired DBAs.

  
10. Enter the Data Item of the date to be used for calculating months of service (Default: DST-Date Started).

Date options:

DSI - Date of Original Employment PADT - Participation Date PSDT - Date Pay Starts ED01-ED03 - User Defined Dates

  

15.4 Special Handling Code Table (P067204)

Processing Option Processing Options Requiring Further Description
Enter a '1' to setup Special Handling for a Canadian Employee (Only)

(Default = 0)

 You must set the processing option to 1 if you want to associate Box O explanatory codes with PDBAs on the Special Handling Code Table screen. The system does not allow data entry in the Cd (Box O Code) field if this processing option is not set to 1.

If you do not set the processing option to 1, you can enter 1 (PDBA Setup) in the Option field to access the DBA Setup screen. From there, choose the Year-End option to access the Year-End Parameters window. You can associate the Box O code with the PDBA on the Year-End Parameters window.

Box O (Other taxable income) appears on the Relevé 1 form.

15.5 Assign Special Handling Code Tables (P067203)

Processing Option Processing Options Requiring Further Description
Enter default form to display uponentry. Valid values are: T4, T4A, RL1,RL2 or NR4. (Default = T4)  

15.6 Repost DBAs to Calendar Month F06145 (P07145)

Processing Option Processing Options Requiring Further Description
Enter the YEAR to be reposted (YY) . . . IMPORTANT NOTES  
1. History records for the year selected will be initialized for all employees processed. THEREFORE, if you select a year make sure that you also select records in F0619 for the same year when setting up your Dream-Writer specification.  
2. If you wish to process all years for which data exists in the F0619 file leave the "YEAR" field blank.  

15.7 Repost DBAs to Payroll Month F06146 (P07146)

Processing Option Processing Options Requiring Further Description
Enter the YEAR to be reposted (YY) . . .

NOTE: If you are reporting everything, leave this BLANK. If you do not have all the detail for all your history in this file, records in F06146 could be cleared and not be reposted.

  

15.8 Repost Pay Types to Payroll Month F06146 (P071461)

Processing Option Processing Options Requiring Further Description
Enter the YEAR to be reposted (YY) . . .

NOTE: If you are reporting everything, leave this BLANK. If you do not have all the detail for all your history in this file, records in

F06146 could be cleared and not be reposted.

  

15.9 Repost DBAs to Tax Area Summary F06148 (P07148)

Processing Option Processing Options Requiring Further Description
Enter the Year to be reposted . . .

(Year is a 2 digit field, Example 2000 will be entered 00)

  

15.10 EI Integrity Validation (P077015)

Processing Option Processing Options Requiring Further Description
1. Enter the year you want the EI Integrity to generate (Ex. 1997).

Note: Your data selection MUST only include records for the year entered in the processing option.

All data selection should be by check date. If the above processing option is left blank, the current system year is assumed.

 The year that you enter must match the calendar year that you use for data selection. If it does not, the program produces a blank report.

15.11 EI Hour Integrity Report (P077020)

Processing Option Processing Options Requiring Further Description
Enter a '1' to run this report in update mode. A value of ' ' will create a verification report only.

Note: The report must be run in verification mode BEFORE you can run it in update mode

  

15.12 Payroll Month PDBAs Integrity (F06146) (P077021)

Processing Option Processing Options Requiring Further Description
1. Select report processing mode.

N = Print errors on report only.

Y = Print errors on report and correct by UPDATING the PDBA History File.

  
2. Enter Error Codes you DO NOT wish to print or leave these fields blank to print ALL errors. Error codes must be entered as 0101, 0102, 0103, etc. DO NOT print the following errors:

"

"

"

"

  
SKIP OPTION 3 IF YOU DO NOT WANT ANY TAX ID UPDATES/CONSOLIDATION TO OCCUR.  
3. Enter the NEW tax ID number to update and consolidate the selected F06146 records.

DEFAULT OF BLANK WILL NOT UPDATE OR CONSOLIDATE ANY RECORDS.

  

15.13 T4/Relevé Workfiles Version Review (P07725)

Processing Option Processing Options Requiring Further Description
1. Display Mode for Adjusted T4/Relevés:

Y = Include adjustments in amounts.

N = Only display the adjustments.

(N = default)

  

15.14 Assign Special Handling Code Tables (P077206)

Processing Option Processing Options Requiring Further Description
Enter default form to display upon entry. Valid values are: T4, T4A, RL1, RL2 or NR4. (Default = T4).  

15.15 Pension Batch Update (P077271)

Processing Option Processing Options Requiring Further Description
Enter Year to be processed (YY) . . . .

** This date MUST be entered in the DATA SELECTION as well.

Enter Pension Plan Number . . . . . . .

This is a 7 digit numeric field

Update T4A Flag (Y/N) . . . . . . . . .

 You must enter the year you are processing in this processing option as well as in the data selection.

The pension plan number that you enter must exist in UDC 77/PN and must be seven characters.

To print the pension plan number and pension adjustment on a T4A form, enter Y (Yes). To print the pension plan number and pension adjustment on a T4 form, enter N (No) or leave this processing option blank.

15.16 Calendar Month DBAs Integrity (F06145) (P077031)

Processing Option Processing Options Requiring Further Description
1. Select report processing mode.

N = Print errors on report only.

Y = Print errors on report and correct by UPDATING the PDBA History File.

  
2. Enter Error Codes you DO NOT wish to print or leave these fields blank to print ALL errors. Error codes must be entered as 0101, 0102, 0103, etc. DO NOT print the following errors:

"

"

"

"

  
SKIP OPTION 3 IF YOU DO NOT WANT ANY TAX ID UPDATES/CONSOLIDATION TO OCCUR.  
3. Enter the NEW tax ID number to update and consolidate the selected F06146 records.

DEFAULT OF BLANK WILL NOT UPDATE OR CONSOLIDATE ANY RECORDS.

  

15.17 T4 Summary Report (P07746)

Processing Option Processing Options Requiring Further Description
1. Enter the T4 Version ID for which to run the Report.  
2. Enter a '1' to print Summary Information only. A blank is the default and will print Detail and

Summary Information.

  
3. Enter '1' if you want to subtotal on 200 records. If left blanks the report will break per company.  

15.18 T4A Summary Report (P07747)

Processing Option Processing Options Requiring Further Description
1. Enter the T4A Version ID for which to run the Report.  
2. Enter a '1' to print Summary Information only. A blank is the default and will print Detail and

Summary Information.

  

15.19 Relevé 1 Summary Report (P07748)

Processing Option Processing Options Requiring Further Description
1. Enter the Relevé 1 Version ID for which to run the Report.  
2. Enter a '1' to print Summary Information only. A blank is the default and will print Detail and

Summary Information.

  

15.20 Relevé 2 Summary Report (P07749)

Processing Option Processing Options Requiring Further Description
1. Enter the Relevé 2 Version ID for which to run the Report.  
2. Enter a '1' to print Summary Information only. A blank is the default and will print Detail and

Summary Information.

  

15.21 NR4 Summary Report (P07750)

Processing Option Processing Options Requiring Further Description
1. Enter the NR4 Version ID for which to run the report.  
2. Enter a '1' to print Summary Information only. A blank is the default and will print Detail and

Summary Information.

  

15.22 T4 XML and Audit File Build (P07760X)

Processing Option Processing Options Requiring Further Description
1. Enter the Workfile Id for the T4 Processing cycle. Enter the workfile ID you use to create the T4 workfile on Canadian Year End Processing (G77247).
2. Enter the Transmitter Number Pos 1-2 = MM Pos 3-8 = 999999 (6-digit number) Your number is assigned by the CRA. This processing option relates to the XML Transmitter Record.

This value identifies the company that prepares and sends the data files. The first two characters are always MM; followed by six digits. The CRA assigns this number.

  • Pos 1-2 = MM

  • Pos 3-8 = 999999 (6-digit number)
3. Transmitter Company Address Number This processing option relates to the XML Transmitter Record. You must identify the transmitter company sending the XML file.

The company Address Book number is the transmitter's company number in the Address Book tables and the system uses it to retrieve the name and address information for the Transmitter Record.

The system uses the company number to retrieve the company name from the Address Book Who's Who file (F0111).

The system also uses the company number to retrieve the most current address from the Address by Date file (F0116).

The value you enter must be a valid record in the Address Book.
4. Transmitter Language Preference

E = English

F = French

 This processing option relates to the XML Transmitter Record.

The primary language the transmitter uses for communication purposes.

The values are either English (E) or French (F).
5. Enter the Social Insurance Number for Proprietor #1. (9 digits) This processing option relates to the XML Employer Summary Record. In the summary records, you must provide information about the employer name and address as well as some total amounts and the SIN numbers of the proprietors/owners, if applicable.

NOTE: If you are creating a submission that contains multiple employers, they all use these values. If you need to specify different values for each employer, you must run separate builds to create a separate submission for each.

If the Employer is a Canadian-controlled private corporation or an unincorporated employer, then you must provide the Social Insurance Number (SIN) of any proprietors or principal owners.

This is the SIN for the primary proprietor/owner.

Use this SIN on all summary records for all employers in the XML build.
6. Enter the Social Insurance Number for Proprietor #2. (9 digits) This processing option relates to the XML Employer Summary Record. In the summary records, you must provide information about the employer name and address as well as some total amounts and the SIN numbers of the proprietors/owners, if applicable.

NOTE: If you are creating a submission that contains multiple employers, they all use these values. If you need to specify different values for each employer, you must run separate builds to create a separate submission for each.

If the Employer is a Canadian-controlled private corporation or an unincorporated employer, then you must provide the Social Insurance Number (SIN) of any proprietors or principal owners.

This is the SIN for the secondary proprietor/owner.

Use this SIN on all summary records for all employers in the XML build.
7. Enter the T4 Report Type Code

O = Original (Default)

A = Amended

 This processing option relates to the XML Transmitter Record. You must provide this information.

The type of submission that you send to CRA.

  • O = Original (Default)

  • A = Amended
8. Submission Reference ID (unique 8 alphanumeric field created by transmitter for each submission) This processing option relates to the XML Transmitter Record. You must provide this information.

This is a unique value that the transmitter creates to identify each submission filed.

Enter 8 alphanumeric characters.
9. Enter the Transmitter Type Indicator

1 = Filing for yourself

2 = Filing on behalf of other filers

3 = Filing for yourself using a purchased software package (Default)

4 = You are a software vendor

 This processing option relates to the XML Transmitter Record. You must identify the type of package being sent.

The type of transmitter that is preparing and sending the submission.

The valid values are set by CRA.

1 – Filing for yourself.

2 – Filing on behalf of other filers.

3 – Filing for yourself using purchased software package (Default).

4 – You are a software vendor.
10. What country does the blank value stand for in UDC 00/CN?

1 = Canada (Default)

2 = United States

3 = Other

 In the Address Book Revisions program, you can leave the Country field blank and the system retrieves the value based on a blank value in UDC 00/CN.

If a company is based in Canada, most likely the blank default value represents Canada.

If a company is based in the United States, most likely the blank default value represents the U.S.

JD Edwards World examines the province, state, and country values according to CRA's schema information, therefore, it is necessary to determine what the blank value represents in UDC 00/CN for the Address Book records.

1 = Canada (Default)

2 = United States

3 = Other
CONTACT INFORMATION:

NOTE: This information is used for the Transmitter and all Summary records.

 The contact information for the transmitter. The CRA uses this information to contact the transmitter concerning any issues or information regarding the submission.

The Transmitter and all Summary records use this information.
11. Name (First followed by surname and omit titles Example: John Smith) This processing option relates to the XML Transmitter Record. You must provide the name of the contact person for the transmitter.

Name (First followed by surname and omit titles Example: John Smith)
12. Area Code (3 digit number - 999) This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter.

Area code (3 digit number - 999)
13. Telephone Number Example: 334-4000 This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter.

Telephone Number Example 334-4000
14. Extension (5 digit number - 99999) This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter.

Extension (5 digit number - 99999)
15. E-mail Address

Example: jsmith@oracle.com

 This processing option relates to the XML Transmitter Record.

E-mail Address Example: jsmith@oracle.com
16. Enter the Detail Record Type

A = Amended

O = Original (Default)

C = Canceled

 This processing option relates to information that you report at the employee level.

In most cases, this value will be the same as the value you enter in the Report Type Code processing option.

CRA only allows for Report Type Codes of O (Original) and A (Amended). The Report Type Code is at the Employer level.

If you want to cancel employee slips, you must use a Report Type Code of A but a Detail Record Type of C.

An Amended return cannot contain an original slip.

The allowed values are set by CRA as follows:

  • Originals = O

  • Amendments = A

  • Cancel = C
17. Enter the type of character set to use to save your XML file:

1 = Windows-1252 (Default)

2 = ISO-8859-1

 This processing option relates to the very first line in the XML file known as the Declaration. Example: <?xml version="1.0" encoding="ISO-8859-1" ?>

The XML Declaration indicates the version of XML that you use in the XML document as well as the character set you use.

The system inserts the value you enter here in the XML Declaration of the XML document you create.

The only two values that you should use are: Windows-1252 and ISO-8859-1
XML FILE INFORMATION  
18. Enter the IFS path to where the XML file to be extracted. If blank, the user will need to use FTP to extract the file. Example: /HOME/T4XML/ Enter the Integrated File System (IFS) path where the system places the T4 XML Workfile (T07760X). This is the file the system extracts into the true XML document which you transmit to the CRA. For example: /home/userid/OR /home/rl2xml/

Using IFS requires additional setup. See Work with Import/Export in the Technical Foundation Guide.

If you leave this processing option blank, you use the File Transfer Protocol (FTP) method for extracting the file. Access the XML Processing menu (G772475), choose Transfer XML Files(s) to PC, and review the instructions.
19. Enter the file name for the XML file to be extracted. Do not use spaces or special characters, except an underscore. Example: yy999999sss where yy = Tax Year, 999999 = Transmitter Number, and sss = a unique sequence number. IFS File Name:

Enter the file name for the XML file you want to extract. Do not use spaces or special characters, except an underscore.

For example: 10NP999999001 where: 10 stands for the taxation year NP999999 stands for your transmitter number 001 stands for a unique sequence number.

If you leave this processing option blank and enter a value in the IFS Path processing option, the system derives the XML file name as follows:

10NP9999001 where:

10 is the taxation year NP999999 is the transmitter number you enter in the Transmitter Number processing option 001 is the sequence number. For example: 10NP123456001

15.23 T4 XML Audit Report (P07761X)

Processing Option Processing Options Requiring Further Description
1. Enter the Workfile Id for the T4 Processing cycle.  

15.24 T4A XML and Audit File Build (P07765X)

Processing Option Processing Options Requiring Further Description
1. Enter the Workfile Id for the T4A Processing cycle. Enter the workfile ID you use to create the T4A workfile on Canadian Year End Processing (G77247).
2. Enter the Transmitter Number.

Pos 1-2 = MM Pos 3-8 = 999999 (6-digit number) Your number is assigned by the CRA.

 This processing option relates to the XML Transmitter Record.

This value identifies the company that prepares and sends the data files. The first two characters are always MM; followed by six digits. The CRA assigns number.

  • Pos 1-2 = MM

  • Pos 3-8 = 999999 (6-digit number)
3. Transmitter Company Address Number This processing option relates to the XML Transmitter Record. You must identify the company sending the XML file.

The company Address Book number is the transmitter's company number in the Address Book tables and the system uses it to retrieve the name and address information for the Transmitter Record.

The system uses the company number to retrieve the company name from the Address Book Who's Who file (F0111).

The system also uses the company number to retrieve the most current address from the Address by Date file (F0116).

The value you enter must be a valid record in the Address Book.
4. Transmitter Language Preference

E = English

F = French

 This processing option relates to the XML Transmitter Record.

The primary language the transmitter uses for communication purposes.

The values are either English (E) or French (F)
5. Enter the Social Insurance Number for Proprietor #1. (9 digits) This processing option relates to the XML Employer Summary Record. In the summary records, you must provide information about the employer name and address as well as some total amounts and the SIN numbers of the proprietors/owners, if applicable.

NOTE: If you are creating a submission that contains multiple employers, they all use these values. If you need to specify different values for each employer, you must run separate builds to create a separate submission for each.

If the Employer is a Canadian-controlled private corporation or an unincorporated employer, they must provide the Social Insurance Number (SIN) of any proprietors or principal owners.

This is the SIN for the primary proprietor/owner.

Use this SIN on all summary records for all employers in the XML build.
6. Enter the Social Insurance Number for Proprietor #2. (9 digits) This processing option relates to the XML Employer Summary Record. In the summary records, you must provide information about the employer name and address as well as some total amounts and the SIN numbers of the proprietors/owners, if applicable.

NOTE: If you are creating a submission that contains multiple employers, they all use these values. If you need to specify different values for each employer, you must run separate builds to create a separate submission for each.

If the Employer is a Canadian-controlled private corporation or an unincorporated employer, they must provide the Social Insurance Number (SIN) of any proprietors or principal owners.

If the Employer is a Canadian-controlled private corporation or an unincorporated employer, they must provide the Social Insurance Number (SIN) of any proprietors or principal owners.

This is the SIN for the secondary proprietor/owner.

Use this SIN on all summary records for all employers in the XML build.
7. Enter the T4A Report Type Code

O = Original (Default)

A = Amended

 The type of submission that you send to CRA.

O = Original (Default)

A = Amended
8. Submission Reference ID (unique 8 alphanumeric field created by transmitter for each submission) This is a unique value that the transmitter creates to identify each submission you file.

It is 8 alphanumeric characters.
9. Enter the type of character set to use to save your XML file:

1 = Windows-1252 (Default)

2 = ISO-8859-1

 This processing option relates to the very first line in the XML file known as the Declaration. Example: <?xml version="1.0" encoding="ISO-8859-1" ?>

The XML Declaration indicates the version of XML that you use in the XML document as well as the character set you use.

The system inserts the value you enter here in the XML Declaration of the XML document you create.

The only two values that you should use are: Windows-1252 and ISO-8859-1
10. Enter the Registered Pension Plan #

Registered Pension Plan #1

Registered Pension Plan #2

Registered Pension Plan #3

 Information goes on the Employer Summary Record.

The CRA issues these pension plan registration numbers.

The system validates the values you enter against UDC 77/PN.

These are optional fields. If you enter values, the program only validates the values against UDC 77/PN as JD Edwards World does not have a database of the valid values to verify.

You must ensure that you enter this information correctly so that the CRA does not reject the data file for containing an invalid value.

Registered Pension Plan #1

Registered Pension Plan #2

Registered Pension Plan #3
11. Enter the Transmitter Type Indicator

1 = Filing for yourself

2 = Filing on behalf of other filers

3 = Filing for yourself using a purchased software package (Default)

4 = You are a software vendor

 This processing option relates to the XML Transmitter Record. You must identify the type of package being you are sending.

The type of transmitter that is preparing and sending the submission.

The valid values are set by CRA.

1 - Filing for yourself

2 - Filing on behalf of other filers

3 - Filing for yourself using purchased software package (Default)

4 - You are a software vendor
12. What country does the blank value stand for in UDC 00/CN?

1 = Canada (Default)

2 = United States

3 = Other

 In the Address Book Revisions program, you can leave the Country field blank and the system determines the value based on a blank value in UDC 00/CN.

If a company is based in Canada, most likely the blank default value represents Canada.

If a company is based in the United States, most likely the blank default value represents the U.S.

JD Edwards World examines the province, state, and country values according to CRA's schema information, therefore, it is necessary to determine what the blank value represents in UDC 00/CN for the Address Book records.

1 = Canada (Default)

2 = United States

3 = Other
CONTACT INFORMATION:

NOTE: This information is used for the Transmitter and all Summary records.

 These processing options relate to the XML Transmitter Record.

The CRA uses this information to contact the transmitter concerning any issues or information regarding the submission.

The Transmitter and all Summary records use this information.
13. Name (First followed by surname and omit titles Example: John Smith) This processing option relates to the XML Transmitter Record. You must provide the name of the contact person for the transmitter.

Name (First followed by surname and omit titles Example: John Smith)
14. Area Code (3 digit number - 999) This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter.

Area code (3 digit number - 999)
15. Telephone Number Example: 334-4000 This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter.

Telephone Number Example 334-4000
16. Extension (5 digit number - 99999) This processing option relates to the XML Transmitter Record. You must provide the telephone number of the contact person for the transmitter.

Extension (5 digit number - 99999)
17. E-mail Address

Example: jsmith@oracle.com

 This processing option relates to the XML Transmitter Record.

E-mail Address Example: jsmith@oracle.com
18. Enter the Detail Record Type

A = Amended

O = Original (Default)

C = Canceled

 This processing option relates to information you report at the employee level.

In most cases, this value is the same as the value you enter in the Report Type Code processing option.

The CRA only allows for Report Type Codes of O (Original) and A (Amended). The Report Type Code is at the Employer level.

If you want to cancel employee slips, you must use a Report Type Code of A but a Detail Record Type of C.

An Amended return cannot contain an original slip.

The valid values are set by CRA as follows:

Originals = O

Amendments = A

Cancel = C
XML FILE INFORMATION  
19. Enter the IFS path to where the XML file to be extracted. If blank, the user will need to use FTP to extract the file. Example: /HOME/T4XML/ Enter the Integrated File System (IFS) path where the system places the T4A XML Workfile (T07765X). This is the file the system extracts into the true XML document which you transmit to the CRA. For example: /home/userid/OR /home/rl2xml/

Using IFS requires additional setup. See Work with Import/Export in the Technical Foundation Guide.

Note: If you leave this processing option blank, you use the File Transfer Protocol (FTP) method for extracting the file. Access the XML Processing menu (G772475), choose Transfer XML Files(s) to PC, and review the instructions.
20. Enter the file name for the XML file to be extracted. Do not use spaces or special characters, except an underscore. Example: yy999999sss where yy = Tax Year, 999999 = Transmitter Number, and sss = a unique sequence number. IFS File Name:

Enter the file name for the XML file you want to extract. Do not use spaces or special characters, except an underscore.

For example: 10NP999999001 where: 10 stands for the taxation year NP999999 stands for your transmitter number 001 stands for a unique sequence number.

If you leave this processing option blank and enter a value in the IFS Path processing option, the system derives the XML file name as follows:

10NP9999001 where: 10 is the taxation year NP999999 is the transmitter number you enter in the Transmitter Number processing option 001 is the sequence number. For example: 10NP123456001

15.25 T4A XML Audit Report (P07766X)

Processing Option Processing Options Requiring Further Description
1. Enter the Workfile Id for the T4 Processing cycle.  

15.26 Canada Laser Forms - Employee Copies (P07770A)

Processing Option Processing Options Requiring Further Description
1. Specify the form to align by

entering a '1' beside the form.

T4 2 part (S077321) OR

T4A 3 part (S077421) OR

Relevé 1 3 part (S077521) OR

Relevé 2 3 part (S077621) OR

NR4 3 part (S077721) OR

NOTE: Listed are the number of lines up, down, left, right per form.

If values entered are greater than maximum lines displayed, the program will not process.

  
2. Adj printing if Too High/Low on form:

Maximum number of lines to move UP:

T4, T4A = 1 Rel1, Rel2 = 0 NR4 = 3 OR

Maximum number of lines to move DOWN:

T4 & T4A = 2 Rel1, Rel2 = 3 NR4 = 4

  
3. Adj printing if Too Far Left/Right:

Maximum number of spaces to move LEFT:

T4,T4A = 0 Rel1, Rel2, NR4 = 3 OR Maximum number of spaces to move RIGHT:

T4, T4A, NR4 = 4 Rel1, Rel2 = 3 More

  
4. Enter the source library you are copying from:  
5. New source member (S077321, S077421

S077521, S077621, S077721) will reside in Source Library:

Object Library: Notes:

If using custom library, it must contain source physical file JDESRC.

User must have authority to compile in chosen libraries.

The object library must be added to top of user's library list.

  

15.27 Canada Forms Alignment - Employer copy (P07770C)

Processing Option Processing Options Requiring Further Description
1. Select the FORM to align by entering a '1' beside the form:

T4 2 part (S077329) OR

T4A 3 part (S077429) OR

Relevé 1 3 part (S077529) OR

Relevé 2 3 part (S077629) OR

NR4 3 part (S077729) OR

NOTE: Listed are the number of lines up, down, left, right per form.

If values entered are greater than maximum lines displayed, the program will not process.

  
2. Adj printing if Too High/Low on form:

Maximum number of lines to move UP:

T4, T4A = 1 Rel1, Rel2 = 0 NR4 = 3 OR

Maximum number of lines to move DOWN:

T4 & T4A = 2 Rel1, Rel2 = 3 NR4 = 4

  
3. Adj printing if Too Far Left/Right:

Maximum number of spaces to move LEFT:

T4,T4A = 0 Rel1, Rel2, NR4 = 3 OR Maximum number of spaces to move RIGHT:

T4, T4A, NR4 = 4 Rel1, Rel2 = 3

  
4. Enter the source library you are copying from:  
5. New source member (S077329, S077429

S077529, S077629, S077729) will reside in Source Library:

Object Library: Notes:

If using custom library, it must contain source physical file JDESRC.

User must have authority to compile in chosen libraries.

The object library must be added to top of user's library list.

  

15.28 Relevé 1 XML and Audit File Build (P07770X)

Processing Option Processing Options Requiring Further Description
1. Enter the Workfile ID for the Relevé Processing cycle (Mandatory) Enter the workfile ID you use to create the Relevé workfile on Canadian Year End Processing (G77247).
2. Enter the Type of Package (Mandatory)

1-Original file

4-Amended file

6-Cancelled file

 This processing option relates to the XML Transmitter Record and the type of package that you send to Revenu Québec. The valid values are set by Revenu Québec.

1 - Original Data

4 - Amended file

6 - Cancelled file
3. Enter the Source of Relevé Slips used (Mandatory) A - Revenu Québec B - Facsimiles from a third party C - Facsimiles produced by the transmitter D - Any combination of the above This processing option relates to the XML Transmitter Record.

Indicate the source from which you obtained the slips to print the physical Relevé slips.

A - Revenu Québec

B - Facsimiles from a third party

C - Facsimiles produced by the transmitter

D - Any combination of the above
4. Enter the Transmitter Number (Mandatory) Pos 1-2 = NP Pos 3-8 = 999999 (6-digit number) You must ask Revenu Québec to assign you this number. This processing option relates to the XML Transmitter Record.

This number identifies the person who prepares and sends the data files. The first two characters are always NP; followed by six digits. Revenu Québec assigns this number.

Pos 1-2 = NP

Pos 3-8 = 999999 (6-digit number)
5. Enter the Type of Transmitter (Optional)

1 - Filing for yourself

2 - Filing on behalf of other filers

3 - Filing for yourself and on behalf of other filers

 This processing option relates to the XML Transmitter Record.

Enter the type of transmitter that is preparing and submitting the data files. The valid values are set by Revenu Québec.

1 - Filing for yourself

2 - Filing on behalf of other filers

3 - Filing for yourself and on behalf of other filers
6. Enter the Transmitter Company Number (Mandatory) This processing option relates to the XML Transmitter Record. You must identify the transmitter company submitting the XML file.

The company Address Book number is the transmitter's company number in the Address Book tables and the system uses it to retrieve the name and address information for the Transmitter Record.

The system uses the company number to retrieve the company name from the Address Book Who's Who file (F0111).

The system also uses the company number to retrieve the most current address from the Address by Date file (F0116).

The value you enter must be a valid record in the Address Book.
7. Enter the Québec Enterprise Number (NEQ) as assigned by the Registraire des enterprises (REQ) or clerk of the Superior Court (10 Numeric- Optional) This number relates to the XML Total Record for the Employer for each group of Relevé slips.

You must provide information concerning the employer along with the totals for the various boxes of the Relevé slips.

This is the number the Registraire des entreprises (REQ) or the clerk of the Superior Court assigns each employer.

This is 10 character numeric field.

This is an optional field and the program only validates that you enter 10 numbers as JD Edwards World does not have a database of the valid values to verify.

You must ensure that the data in this file is correct or Revenu Québec can reject it because it contains an invalid value.
COMPUTER CONTACT (All Optional) The contact information for the transmitter's Computer resource person.

Revenu Québec uses this information to contact the transmitter concerning any issues or information regarding the data in the XML file.
8. Name (Last followed by first and omitting title-Example: Smith, Jon) You must provide the name of the contact person for the transmitter.

Name (Last followed by first and omitting title - Example: Smith Jon)
9. Area Code You must provide the telephone numbers of the contact person for the transmitter.

Area Code
10. Telephone Number - Example: 334-4000 Telephone Number - Example: 334-4000
11. 7 digit extension - Example: 41234 7 digit extension - Example: 41234
12. Preferred Language

A = English

F = French

 Preferred Language

A = English

F = French
ACCOUNTING CONTACT (All Optional) The contact information for the transmitter's Accounting resource person. Revenu Québec uses this information to contact the transmitter concerning any issues or information regarding the data in the XML file, for example, the amounts in the file.
13. Name (Last followed by first and omitting title-Example: Smith, Jon) Name (Last followed by first and omitting title - Example: Smith Jon)
14. Area Code Area Code
15. Telephone Number - Example: 334-4000 Telephone Number - Example: 334-4000
16. 7 digit extension - Example: 41234 7 digit extension - Example: 41234
17. Preferred Language

A = English

F = French

 Preferred Language

A = English

F = French
18. Software company certification number. Assigned by Revenu Québec.

12 alphanumeric and formatted as follows: RQ-00-99-999 where

RQ = Revenu Québec

00 = Taxation year for which software was certified

99 = Relevé form ('01' or '02')

999 = Software Developer identification number. Oracle is assigned a new # each year so check Oracle World Support Website or contact GSC for the value to enter.

 You must enter this number as RQ-00-99-999 (12 alphanumeric).

RQ = Revenu Québec

00 = Taxation year for which software was approved

99 = Type of Relevé slip

999 = Software Developer identification number

This is the number Revenu Québec issues to the developer of the XML file, for example Oracle, when they certify the software.

Oracle receives a new number every year in late December or January, after the release of the year-end update and you must check the My Oracle Support website or contact GCS for the value you must enter.
19. What country does the blank value stand for in UDC 00/CN?

1 = Canada (Default)

2 = United States

3 = Other

 In the Address Book Revisions program, you can leave the Country field blank and the system determines the value based a blank value in UDC 00/CN.

If a company is based in Canada, most likely the default value of blank represents Canada.

If a company is based in the United States, most likely the default value of blank represents the US.

JD Edwards World examines the province, state, and country values according to Revenu Québec's schema information, therefore, it is necessary to determine what the blank value represents in UDC 00/CN for the Address Book records.
20. Enter the type of character set to use to save your XML file:

1 = Windows-1252 (Default)

2 = ISO-8859-1

 This processing option relates to the very first line in the XML file known as the Declaration. Example: <?xml version="1.0" encoding="ISO-8859-1" ?>

The XML Declaration indicates the version of XML you use in the XML document as well as the character set.

The value system inserts the value you enter in the XML Declaration of the XML document you create.

The only two values that you should use are: Windows-1252 and ISO-8859-1.
XML FILE INFORMATION  
21. Enter the IFS path to where the XML file to be extracted. If blank, the user will need to use FTP to extract the file. Example: /HOME/RL1XML/ Enter the Integrated File System (IFS) path where the system places the Relevé 1 XML Workfile (T07770X). This is the file the system extracts into the true XML document which you transmit to the CRA. For example: /home/userid/OR /home/rl2xml/

Using IFS requires additional setup. See Work with Import/Export in the Technical Foundation Guide.

If you leave this processing option blank, you use the File Transfer Protocol (FTP) method for extracting the file. Access the XML Processing menu (G772475), choose Transfer XML Files(s) to PC, and review the instructions.
22. Enter the file name for the XML file to be extracted. Do not use spaces or special characters, except an underscore. Example: yy999999sss where yy = Tax Year, 999999 = Transmitter Number, and sss = a unique sequence number. IFS File Name:

  • Enter the file name for the XML file you want to extract. Do not use spaces or special characters, except an underscore.

    For example: 10NP999999001 where:

    10 stands for the taxation year

    NP999999 stands for your transmitter number

    001 stands for a unique sequence number.

  • If you leave this processing option blank and enter a value in the IFS Path processing option, the system derives the XML file name as follows:

    10NP9999001 where:

    10 is the taxation year

    NP999999 is the transmitter number you enter in the Transmitter Number processing option.

    001 is the sequence number.

    For example: 10NP123456001
23. Enter the email address of the person responsible for the XML file. The email is limited to 60 characters. Anything after 60 will be truncated. (Optional) Email address of the person responsible for the XML file

  • Enter the email address of the person who is responsible for creating the XML file. This allows Revenu Québec to expedite the processing of your file.

  • In the majority of cases, this is the email address for the name of person you enter in the Name processing options under Computer/Accounting Resource. This information allows Revenu Québec to contact the person by email.
24. Enter the desired language of communication by email. (Optional)

A = English

F = French

 Enter the language preference of the person in the email address that is responsible for creating the XML file.

The allowed values are:

A = English

F = French
25. Enter the PPIP Employee Contribution (Premium) rate for the current year. The PPIP Employee Premium rate for the current year.

The amount in Box H should be equal to the calculated results of the PPIP Insurable Earnings reported in Box I multiplied by the PPIP Employee Contribution (Premium) rate for the current year. A variance of plus or minus $1.00 between the amount from payroll history and the amount calculated allows for rounding issues.

This rate changes every year and should match the rate assigned to the DBA used to calculate the Employee portion of PPIP throughout the year.

15.29 Taxation History Integrity (F0713) (P077011)

Processing Option Processing Options Requiring Further Description
1. Select report processing mode.

N = Print errors on report only.

Y = Print errors on report and correct by UPDATING the PDBA History File.

  
2. Enter Error Codes you DO NOT wish to print or leave these fields blank to print ALL errors. Error codes must be entered as 0101, 0102, 0103, etc. DO NOT print the following errors:

"

"

"

"

  
SKIP OPTION 3 IF YOU DO NOT WANT ANY TAX ID UPDATES/CONSOLIDATION TO OCCUR.  
3. Enter the NEW tax ID number to update and consolidate the selected F06146 records.

DEFAULT OF BLANK WILL NOT UPDATE OR CONSOLIDATE ANY RECORDS.

  

15.30 Relevé 1 XML Audit Report (P07771X)

Processing Option Processing Options Requiring Further Description
1. Enter the Workfile Id for the Relevé 1 Processing cycle.  

15.31 Relevé 2 XML and Audit File Build (P07775X)

Processing Option Processing Options Requiring Further Description
1. Enter the Workfile ID for the Relevé Processing cycle (Mandatory) Enter the workfile ID you use to create the Relevé workfile on Canadian Year End Processing (G77247).
2. Enter the Type of Package (Mandatory)

1-Original file

4-Amended file

6-Cancelled file

 This processing option relates to the XML Transmitter Record.

The type of package that you send to Revenu Québec. The valid values are set by Revenu Québec.

1 - Original Data

4 - Amended file

6 - Cancelled file
3. Enter the Source of Relevé Slips used (Mandatory)

A - Revenu Québec

B - Facsimiles from a third party

C - Facsimiles produced by the transmitter

D - Any combination of the above

 This processing option relates to the XML Transmitter Record.

Indicate the source from which you obtained the slips to print the physical Relevé slips.

A - Revenu Québec

B - Facsimiles from a third party

C - Facsimiles produced by the transmitter

D - Any combination of the above
4. Enter the Transmitter Number (Mandatory) Pos 1-2 = NP Pos 3-8 = 999999 (6-digit number) You must ask Revenu Québec to assign you this number. This processing option relates to the XML Transmitter Record.

This number identifies the person who prepares and sends the data files. The first two characters are always NP followed by six digits. Revenu Québec assigns this number.

Pos 1-2 = NP

Pos 3-8 = 999999 (6-digit number)
5. Enter the Type of Transmitter (Optional)

1 - Filing for yourself

2 - Filing on behalf of other filers

3 - Filing for yourself and on and on behalf of other filers

 This processing option relates to the XML Transmitter Record.

The type of transmitter that is preparing and submitting the data files. The valid values are set by Revenu Québec.

1 - Filing for yourself

2 - Filing on behalf of other filers

3 - Filing for yourself and on behalf of other filers
6. Enter the Transmitter Company Number (Mandatory) This processing option relates to the XML Transmitter Record.

The company Address Book number is the transmitter's company number in the Address Book tables and the system uses it to retrieve the name and address information for the Transmitter Record.

The system uses the company number to retrieve the company name from the Address Book Who's Who file (F0111).

The system also uses the company number to retrieve the most current address from the Address by Date file (F0116).

The value you enter must be a valid record in the Address Book.
7. Enter the Québec Enterprise Number (NEQ) as assigned by the Registraire des enterprises (REQ) or clerk of the Superior Court (10 Numeric-Optional) This number relates to the XML Total Record for the Employer for each group of Relevé slips.
COMPUTER CONTACT (All Optional) The contact information for the transmitter's Computer resource person.

Revenu Québec uses this information to contact the transmitter concerning any issues or information regarding the data in the XML file.
8. Name (Last followed by first and omitting title-Example: Smith, John) This processing option relates to the XML Transmitter Record.

Name (Last followed by first and omitting title - Example: Smith Jon)
9. Area Code This processing option relates to the XML Transmitter Record.

Area Code
10. Telephone Number - Example: 334-4000 This processing option relates to the XML Transmitter Record.

Telephone Number - Example: 334-4000
11. 7 digit extension - Example: 41234 This processing option relates to the XML Transmitter Record.

7 digit extension - Example: 41234
12. Preferred Language

A = English

F = French

 This processing option relates to the XML Transmitter Record.

Preferred Language

A = English

F = French
ACCOUNTING CONTACT (All Optional) The contact information for the transmitter's Accounting resource person.

Revenu Québec uses this information to contact the transmitter concerning any issues or information regarding the data in the XML file, for example, the amounts in the file.
13. Name (Last followed by first and omitting title-Example: Smith, John) This processing option relates to the XML Transmitter Record.

Name (Last followed by first and omitting title - Example: Smith Jon)
14. Area Code This processing option relates to the XML Transmitter Record.

Area Code
15. Telephone Number - Example: 334-4000 This processing option relates to the XML Transmitter Record.

Telephone Number - Example: 334-4000
16. 7 digit extension - Example: 41234 This processing option relates to the XML Transmitter Record.

7 digit extension - Example: 41234
17. Preferred Language

A = English

F = French

 This processing option relates to the XML Transmitter Record.

Preferred Language

A = English

F = French
18. Software company certification number. Assigned by Revenu Québec.

12 alphanumeric and formatted as follows: RQ-00-99-999 where

RQ = Revenu Québec

00 = Taxation year for which software was certified

99 = Relevé form ('01' or '02')

999 = Software Developer identification number. Oracle is assigned a new # each year so check Oracle World Support Website or contact GSC for the value to enter.

 You must enter this number as RQ-00-99-999 (12 alphanumeric).

RQ = Revenu Québec

00 = Taxation year for which software was approved

99 = Type of Relevé slip

999 = Software Developer identification number

This is the number Revenu Québec issues to the developer of the XML file, for example Oracle, when they certify the software.

Oracle receives a new number every year in late December or January, after the release of the year-end update and you must check the My Oracle Support website or contact GCS for the value you must enter.
19. What country does the blank value stand for in UDC 00/CN?

1 = Canada (Default)

2 = United States

3 = Other

 In the Address Book Revisions program, you can leave the Country field blank and the system determines the value based a blank value in UDC 00/CN.

If a company is based in Canada, most likely the default value of blank represents Canada.

If a company is based in the United States, most likely the default value of blank represents the US.

JD Edwards World examines the province, state, and country values according to Revenu Québec's schema information, therefore, it is necessary to determine what the blank value represents in UDC 00/CN for the Address Book records.
20. Enter the type of character set to use to save your XML file:

1 = Windows-1252 (Default)

2 = ISO-8859-1

 This processing option relates to the very first line in the XML file known as the Declaration. Example: <?xml version="1.0" encoding="ISO-8859-1" ?>

The XML Declaration indicates the version of XML you use in the XML document and the character set.

The value system inserts the value you enter in the XML Declaration of the XML document you create.

The only two values that you should use are: Windows-1252 and ISO-8859-1.
XML FILE INFORMATION  
21. Enter the IFS path to where the XML file to be extracted. If blank, the user will need to use FTP to extract the file. Example: /HOME/RL2XML/ Enter the Integrated File System (IFS) path where the system places the Relevé 2 XML Workfile (T07775X). This is the file the system extracts into the true XML document which you transmit to the CRA. For example: /home/userid/OR /home/rl2xml/

Using IFS requires additional setup. See Work with Import/Export in the Technical Foundation Guide.

If you leave this processing option blank, you use the File Transfer Protocol (FTP) method for extracting the file. Access the XML Processing menu (G772475), choose Transfer XML Files(s) to PC, and review the instructions.
22. Enter the file name for the XML file to be extracted. Do not use spaces or special characters, except an underscore. Example: yy999999sss where yy = Tax Year, 999999 = Transmitter Number, and sss = a unique sequence number. IFS File Name:

Enter the file name for the XML file you want to extract. Do not use spaces or special characters, except an underscore.

For example: 10NP999999001 where: 10 stands for the taxation year NP999999 stands for your transmitter number 001 stands for a unique sequence number.

If you leave this processing option blank and enter a value in the IFS Path processing option, the system derives the XML file name as follows:

10NP9999001 where: 10 is the taxation year NP999999 is the transmitter number you enter in the Transmitter Number processing option 001 is the sequence number. For example: 10NP123456001
23. Enter the email address of the person responsible for the XML file. The email is limited to 60 characters. Anything after 60 will be truncated. (Optional) Enter the email address of the person who is responsible for creating the XML file. This allows Revenu Québec to expedite the processing of your file.

In the majority of cases, this is the email address for the name of person you enter in the Name processing options under Computer/Accounting Resource. This information allows Revenu Québec to contact the person by email.
24. Enter the desired language of communication by email. (Optional)

A = English

F = French

 Enter the language preference of the person in the email address that is responsible for creating the XML file.

Valid values are:

A = English

F = French

15.32 Relevé 2 XML Audit Report (P07776X)

Processing Option Processing Options Requiring Further Description
1. Enter the Workfile Id for the Relevé 2 Processing cycle.  

15.33 Repost Tax ID to Tax Ledger F0716 (P07990)

Processing Option Processing Options Requiring Further Description
1. Enter the NEW Tax ID number you want to update the selected F0716 records with. PLEASE BE CAREFUL! Only select, via data selection on the Dream Writer, records you want the Tax Id field updated on.  

15.34 T4 Print Special Forms (P077321)

Processing Option Processing Options Requiring Further Description
1. Do you want the employer address to print on the T4 forms?

0 = No

1 = Yes (Default)

  
2. Do you want the cheque route code to print on the T4 forms along with the other employee address fields?

0 = No (Default)

1 = Yes