1. Canadian Payroll Year-End Processing Guide
  2. Generating XML Files

Generating XML Files

You must submit year-end information to the Canada Revenue Agency (CRA) and to the Ministere du Revenue du Québec in XML format. Due to several drawbacks in terms of usability and the deployment of web Methods, the process for generating XML files for government submission changed in 2008, and now does not require the use of additional integration technology services. These have been replaced by some internal business functions that automatically generate the XML files during the year-end process. Therefore, you do not require webMethods, Web Services Gateway, XPI, or other integration technologies, for XML file generation.

For the XML file generation process, you now require the JD Edwards EnterpriseOne tools release 8.96 or higher.

To generate XML files for year-end reporting, you must:

  • Build the year-end workfile.

  • Set up an export folder to hold the XML files.

  • Enter the path of the export folder in the processing options of the XML table conversion programs.

  • Submit magnetic media from the year-end workbench.

The magnetic media programs create files that contain the appropriate year-end data in XML format. You copy the XML files to electronic media and submit them to the CRA or Ministere du Revenue du Québec. The magnetic media programs also create audit reports that enable you to verify the magnetic media submission.

To select the magnetic media programs that you want to run, you use the Reports Setup. Each magnetic media program calls a related table conversion program. The table conversion program, creates the XML file, and stores the file in the location that you specify in the processing options. For example, to create the XML file for T4 forms, you must complete these steps:

  1. Create an export folder to store the XML files.

  2. In the processing options of the R89772001X table conversion program, you must specify the file path and name for the XML file.

    This is the location of the export folder.

  3. Verify that the version of the R89772001X that contains the correct file path-name is included in the processing options of the Create T4 Magnetic Media File and Audit Report (R77501).

  4. Select your version of R77501 by using the reports setup function for your year-end ID.

  5. Submit magnetic media.

After setting up magnetic media programs, you submit the magnetic media from the year-end workbench. When you submit the magnetic media, the system automatically generates XML files in the export folder that you set up. You then copy these files to electronic media and submit them to the appropriate government agency. If you reprocess magnetic media, the system overwrites any existing files in the export folder.

These magnetic media programs, and their associated table conversion programs, are available for XML file generation:

Magnetic Media Program

Table Conversion Program

R77501 (Create T4 Magnetic Media File and Audit Report)

R89772001X

R77502 (Create Relevé 1 Magnetic Media File and Audit Report)

R89772002X

R77503 (Create T4A Magnetic Media File and Audit Report)

R89772003X

R77504 (Create Relevé 2 Magnetic Media File and Audit Report)

R89772006X

R77505 (Create NR4 Magnetic Media File and Audit Report)

R89772005X