Creating the XML File
You can use the XML format of the following forms to report year-end information to the CRA and Revenu Québec:
T4
T4A
Relevé 1
Relevé 2
The system generates an integrity report during the XML build process. The integrity report validates the data the system enters in the XML file to ensure that the data conforms to the XML schema from the CRA. For example, the CRA requires that Canadian Postal Codes be in the XML file in the following format: A1A1A1 (alpha, numeric, alpha, numeric, alpha, numeric). If the postal code in the Address By Date table (F0116) is not in this format, the system prints an error on the integrity report.
After you build the XML file, you need to review the integrity report. If any errors exist, make all necessary corrections and run the XML & Audit File Build program again.
The XML file is successful if the integrity report contains the following message: ** XML File Contains No Errors **.
You can run these programs as a standalone audit report to validate the data the system creates in the workfile. You do not have to wait until you are ready to submit your XML file to run these.
What You Should Know About
Topic |
Description |
|---|---|
Creating the XML and Audit Files |
You create an XML file on the AS/400 and then transfer the file to your PC. The final step is to transmit the data to the CRA. The T4, T4A, Relevé 1, and Relevé 2 XML build programs create an XML file that uses the XML syntax and schema that the CRA requires. The system merges data from the workfile build with the XML tags in the schema. The system also creates an audit file using sequential file formatting so that you can print an audit report from the data in the XML file. |
Data Selection for Building the XML File |
For an original build, do not change the Data Selection for this program. All records in the T4, T4A, Relevé 1, and Relevé 2 workfile should be in the original files. For an amended build, select only those employees from the T4, T4A, Relevé 1, and Relevé 2 workfile that have changes. You only need to create and send an amended file if you sent an original file to the CRA and you need to change some of the information. For a canceled build, select only those employees from the T4, T4A, Relevé 1, and Relevé 2 workfile that you want to cancel. You only need to create and send a canceled file if you sent an original file to the CRA and you need to cancel some of the information. |
Data Sequence for Building the XML File |
Do not change the data sequence for this program. |
Technical Considerations for Building the XML File |
The CRA accepts XML file data in either of the following character sets. These character sets enable the XML file to capture international characters accurately (for example, the French character é).
You can find additional information about character sets by searching the World Wide Web. |
XML Integrity and Audit Reports |
This report contains three parts:
|
Creating the XML file includes the following tasks:
Working with the T4 XML Files
Working with the T4A XML Files
Working with the Relevé 1 XML Files
Working with the Relevé 2 XML Files
The CRA website for more information, including the XML specifications, schemas, Employer Guides, and General Filing information.
The Revenu Québec website for Relevé information, including XML specifications.
Reviewing the XML Integrity Reports for more information.
Specifications for the Relevé XML format (all RL Slips) are available from Revenu Québec only if you are a registered partner with Revenu Québec. See Transferring and Submitting the XML Workfile for more information.
Working with the T4 XML Files
Create a workfile for T4 XML so you can transfer this workfile to your PC and submit the data to the CRA.
Working with the T4 XML files includes the following tasks:
Creating the T4 XML and Audit Files
Verifying the T4 XML File
Creating the T4 XML and Audit Files
This program reads information from the T4 Workfile (T07730) and the T4 Adjustment Workfile (T07740). The system saves the information in the T4 XML Workfile (T07760X), using the XML syntax and schema that the CRA requires. The system also saves the records in the T4 XML Audit Workfile (T07761), so that you can print an audit report of the information you send to the government.
Navigation
From XML Processing (G772475), choose Build T4 Files
Processing Options
Verifying the T4 XML File
After you create the XML and audit files, verify that the information it contains is the information that you intend to submit to the government.
The T4 XML Integrity and Audit reports assist you in verifying this information. The integrity report lists any errors the system encounters when creating the T4 XML Workfile (T07760X) and the audit report lists the information from the T4 XML Audit Workfile (T07761).
The Other Information area at the bottom of the T4 form includes several Box- Case and Amount boxes for the various types of additional income. There are numerous codes for additional income defined by the Canadian government. When you generate T4's, the system prints one primary slip and can print up to five "overflow" slips with additional income amounts, depending on how many amounts need to be special handled for the additional income.
The T4 XML Audit Report (P07761X) reflects the total number of detail records in the XML file including the detail records for any overflow slips. The T4 Summary Report (P07746) reflects only the total number of T4's the employee receives for each company and tax ID. That is, one slip per employee regardless of how many overflow slips print. It does not include overflow slips in the slip count.
The slip count on the XML Audit Report never matches the T4 Summary Report if an employee has more additional information amounts than the primary slip can accommodate. The totals on these reports accommodate two different numbers: XML detail records vs. slip counts.
During the XML & Audit File build, the system saves the information in the T4 XML Workfile (T07760X), using the XML syntax the CRA requires. The system also saves the records in the T4 XML Audit Workfile (T07761), using sequential formatting.
Navigation
From XML Processing (G772475), choose T4 XML Audit Report
Processing Options
See T4 XML Audit Report (P07761X)
Data Selection
Do not change the data selection for this program. There is only one field in the T4 XML Audit Workfile (T07761) and the file contains all the records the system saves during the XML build.
Changing the data selection does not accurately reflect the data that you submit to the government.
Data Sequence
Do not change the data sequence for this program. There is only one field in the T4 XML Audit Workfile (T07761) and it is in the same order that the system saves the records during the XML build.
Changing the data sequence does not accurately reflect the data that you submit to the government.
Technical Considerations
Do not attempt to correct the data in the T4 XML Workfile (T07760X) or in the T4 XML Audit Workfile (T07761). The information in these two files is an exact match. The T07760X stores the information using XML syntax and the T07761 stores the information using sequential formatting.
Changing the information in either of these files causes the information to be out-of-sync.
Grand totals exist in this report; however, grand totals are not in the XML file as they are not part of the XML schema the CRA issues. The grand totals are only in the report to assist you in associating this data to other reports.
Working with the T4A XML Files
Create a workfile for T4A XML so you can transfer this workfile to your PC and submit the data to the CRA.
Working with the T4A XML files includes the following tasks:
Creating the T4A XML Files
Verifying the T4A XML File
Creating the T4A XML Files
The program reads information from the T4A Workfile (T07732) and the T4A Adjustment Workfile (T07742). The system saves the information in the T4A XML Workfile (T07765X), using the XML syntax and schema that the CRA requires. The system also saves the records in the T4A XML Audit File (T07766), so that you can print an audit report of the information you send to the government.
Navigation
From XML Processing (G772475), choose Build T4A Files
Processing Options
Verifying the T4A XML Files
After you create the XML and audit files, verify that the information it contains is the information that you intend to submit to the government.
The T4A XML Integrity and Audit reports assist you in verifying this information. The integrity report lists any errors the system encounters when creating the T4A XML Workfile (T07765X) and the audit report lists the information from the T4A XML Audit Workfile (T07766).
During the XML & Audit File build, the system saves the information in the T4A XML Workfile (T07765X), using the XML syntax the CRA requires. The system also saves the records in the T4A XML Audit Workfile (T07766), using sequential formatting.
This report contains three parts:
Transmission record
Supplementary (detail) records
Summary records
Navigation
From XML Processing (G772475), choose T4A XML Audit Report
Processing Options
See T4A XML Audit Report (P07766X)
Data Selection
Do not change the data selection for this program. There is only one field in the T4A XML Audit Workfile (T07766) and the file contains all the records the system saves during the XML build.
Changing the data selection does not accurately reflect the data that you submit to the government.
Data Sequence
Do not change the data sequence for this program. There is only one field in the T4A XML Audit Workfile (T07766) and it is in the same order that the system saves the records during the XML build.
Changing the data sequence does not accurately reflect the data that you submit to the government.
Technical Considerations
Do not attempt to correct the data in the T4A XML Workfile (T07765X) or in the T4A XML Audit Workfile (T07766). The information in these two files is an exact match. The T07765X stores the information using XML syntax and the T07766 stores the information using sequential formatting.
Changing the information in either of these files causes the information to be out-of-sync.
Grand totals exist in this report; however, grand totals are not in the XML file as they are not part of the XML schema the CRA issues. The grand totals are only in the report to assist you in associating this data to other reports.
JD Edwards World includes summary and grand totals for box 46. However, box 46 is not in the XML file as it is not part of the XML schema that the CRA issues. The totals are only in the report to assist you in associating the totals to the detail and other reports.
Working with the Relevé 1 XML Files
Create a workfile for Relevé 1 XML so you can transfer this workfile to your PC and submit the data to Revenu Québec.
Working with the Relevé 1 XML files includes the following tasks:
Creating the Relevé 1 XML Files
Verifying the Relevé 1 XML File
Creating the Relevé 1 XML Files
This program reads information from the RL-1Workfile (T07731) and the Relevé 1 Adjustment Workfile (T07741). The system saves the information in the Relevé 1 XML Workfile (T07770X), using the XML syntax and schema that Revenu Québec requires. The system also saves the records in the Relevé 1 XML Audit Workfile (T07771), so that you can print an audit report of the information you send to the government.
In addition to error messages, you might also receive a warning message. JD Edwards World recommends that you investigate the message to ensure the file's data accuracy. The warning message states: Warning-All Employees have both CPP/QPP.
The system successfully validates the XML file if the integrity report contains the following message: XML File Contains No Errors.
You only need to create and send an amended file, if you sent the original file to Revenu Québec and you need to change some of the information that you transmitted.
You only need to create and send a canceled file, if you sent an original file to Revenu Québec and you need to cancel some of the information that you transmitted.
-
If you run this program as a standalone audit report prior to printing the Relevé forms, the system displays errors for the Serial Number field because the Print Laser Form program assigns the serial numbers to the Relevé forms. You can disregard these errors until you print the forms, however, you must print the forms to assign serial numbers before you run this program to create the file you send to Québec. If records are missing serial numbers, Québec rejects your file.
-
If you set up a special handled DBA for L12 or L13 codes while building the Relevé 1 Workfile, then the rate of that DBA is moved to the L11 code. The L11 code is populated only when you set up a special handled DBA for L12 or L13 codes. The percentage rate for DBA must be less than or equal to 99.99; otherwise, the Relevé 1 XML will be rejected by the Revenu Québec. For example, you can set the percentage rate for DBA as 12.00 and not as 101.99. If multiple DBAs are attached to L12 or L13 in the Special Handling Code Table, the system uses the percentage rate of the first DBA occurrence for L11 code.
Navigation
From XML Processing (G772475), choose Build Relevé 1 Files
Processing Options
See Relevé 1 XML and Audit File Build (P07770X)
Data Selection
-
For the original build, do not change the data selection. All records in the RL-1 workfile should be from the original files.
-
For an amended build, select only those employees from the RL-1 workfile to which you made changes.
-
For a canceled build, select only those employees from the RL-1 workfile for which you want to cancel an RL-1.
Data Sequence
Do not change the data sequence.
Verifying the Relevé 1 XML File
After you create the XML and audit files, verify that the information it contains is the information that you intend to submit to the government.
The Relevé 1 Integrity and Audit reports assist you in verifying this information. The integrity report lists any errors the system encounters when creating the Relevé 1 XML Workfile (T07770X) and the audit report lists the information from the Relevé 1 XML Audit Workfile (T07771).
During the XML & Audit File build, the system saves the information in the Relevé 1 XML Workfile (T07770X), using the XML syntax Revenu Québec requires. The system also saves the records in the Relevé 1 XML Audit Workfile (T07771), using sequential formatting.
The report contains three parts:
Transmission record
Supplementary (detail) record
Summary record
Navigation
From XML Processing (G772475), choose Relevé 1 XML Audit Report
Processing Options
See Relevé 1 XML Audit Report (P07771X)
Data Selection
Do not change the data selection for this program. There is only one field in the Relevé 1 XML Audit Workfile (T07771) and the file contains all the records the system saves during the XML build.
Changing the data selection does not accurately reflect the data that you submit to the government.
Data Sequence
Do not change the data sequence for this program. There is only one field in the Relevé 1 XML Audit Workfile (T07771) and it is in the same order that the system saves the records during the XML build.
Changing the data sequence does not accurately reflect the data that you submit to the government.
Technical Considerations
Do not attempt to correct the data in the Relevé 1 XML Workfile (T07770X) or in the Relevé 1 XML Audit Workfile (T07771). The information in these two files is an exact match. The T07770X stores the information using XML syntax and the T07771 stores the information using sequential formatting.
Changing the information in either of these files causes the information to be out-of-sync.
Working with the Relevé 2 XML Files
Create a workfile for Relevé 2 XML so you can transfer this workfile to your PC and submit the data to Revenu Québec.
Working with the Relevé 2 XML files includes the following tasks:
Creating the Relevé 2 XML files
Verifying the Relevé 2 XML Files
Creating the Relevé 2 XML Files
This program reads information from the Relevé 2 Workfile (T07733) and the Relevé 2 Adjustment Workfile (T07743). The system saves the information in the Relevé 2 XML Workfile (T07775X), using the XML syntax and schema that Revenu Québec requires. The system also saves the records in the Relevé 2 XML Audit Workfile (T07776), so that you can print an audit report of the information you send to the government.
If you run this program as a standalone audit report prior to printing the Relevé forms, the system displays errors for the Serial Number field because the Print Laser Form program assigns the serial numbers to the Relevé forms. You can disregard these errors until you print the forms, however, you must print the forms to assign serial numbers before you run this program to create the file you send to Québec. If records are missing serial numbers, Québec rejects your file.
Navigation
From XML Processing (G772475), choose Build Relevé 2 Files
Processing Options
Verifying the Relevé 2 XML File
After you run the XML & Audit File build, verify that the information it contains is the information that you intend to submit to the government.
The Relevé 2 XML Integrity and Audit reports allow you to verify this information. The integrity report lists any errors the system encounters when it creates the Relevé 2 XML Workfile (T07775X) and the audit report lists the information from the Relevé 2 XML Audit Workfile (T07776).
During the XML & Audit File Build, the system saves the information in the Relevé 2 XML Workfile (T07775X), using the XML syntax Revenu Québec requires. The system also save the same information in the Relevé 2 XML Audit Workfile (T07776), using sequential formatting.
The report contains three parts:
Transmission record
Supplementary (detail) record
Summary record
Navigation
From XML Processing (G772475), choose Relevé 2 XML Audit Report
Processing Options
See Relevé 2 XML Audit Report (P07776X)
Data Selection
Do not change the data selection for this program. There is only one field in the Relevé 2 XML Audit Workfile (T07776) and the file contains all the records the system saves during the XML build.
Changing the data selection does not accurately reflect the data that you submit to the government.
Data Sequence
Do not change the data sequence for this program. There is only one field in the Relevé 2 XML Audit Workfile (T07776) and it is in the same order that the system saves the records during the XML build.
Changing the data sequence does not accurately reflect the data that you submit to the government.
Technical Considerations
Do not attempt to correct the data in the Relevé 2 XML Workfile (T07775X) or in the Relevé 2 XML Audit Workfile (T07776). The information in these two files is an exact match. The T07775X stores the information using XML syntax and the T07776 stores the information using sequential formatting.
Changing the information in either of these files causes the information to be out-of-sync.