Understanding the Write T5018 Media Program

You print T5018 returns and distribute them to suppliers so that the suppliers have legal documents to support the information they provide to CRA on their tax returns. To print the T5018 returns, use the Write T5018 Media program (P04615).

The Write T5018 Media program summarizes data from the F046141 table and stores it in the F04614 table. The program then transfers the data from the F04614 table to the T5018 form and reporting medium that you will send to the supplier and the CRA, respectively.

The Write T5018 Media program consists of this program and report:

The Write T5018 Media program (P04615). You use the Write T5018 Media form to select the report type (proof report, preprinted forms, and XML) in which to generate T5018 information and the generation method.

The Write T5018 Media report (R04615). After you select the report type and click OK on the Write T5018 Media form, the system prints a report if run in final mode. This report when run in any other medium than proof, contains summary information for the type of return you select and is followed by one of these reports based on the medium you selected:

T5018 XML Generation (R046151)
T5018 Pre-Printed (R046152)
T5018 Proof (R046153)

Each of these reports generates and prints T5018 information. The Write T5018 Media report does not include processing options. It prints information based on the processing options in the Write T5018 Media program (P04615)

Note: Oracle recommends that you perform validation against the CRA Schema available at the link http://www.cra-arc.gc.ca/esrvc-srvce/rf/mgmd/dnwldschm-eng.html using a validating parser to ensure that the XML does not have any errors.

Form or Report	Description
T5018 XML Generation	Prints the T5018 information in XML format. You use this report to submit to CRA.
T5018 Pre-Printed	Prints information on preprinted T5018 forms. For each supplier that receives a T5018 form, the T5018 return information prints in the appropriate information. Each return includes the supplier's legal name, along with the mailing address and the Canadian account number for the supplier, as well as the company that is responsible for the payments to the supplier.
T5018 Proof	Prints a preliminary review of the information that you will send to the CRA. Oracle strongly recommends that you print this report and scrutinize its results. You can make adjustments to the F046141 and F04614 tables and rerun this program as many times as necessary to ensure that the returns are correct before you do the final T5018 processing.

Form or Report

Description

T5018 XML Generation

Prints the T5018 information in XML format. You use this report to submit to CRA.

T5018 Pre-Printed

Prints information on preprinted T5018 forms.

For each supplier that receives a T5018 form, the T5018 return information prints in the appropriate information. Each return includes the supplier's legal name, along with the mailing address and the Canadian account number for the supplier, as well as the company that is responsible for the payments to the supplier.

T5018 Proof

Prints a preliminary review of the information that you will send to the CRA.

Oracle strongly recommends that you print this report and scrutinize its results.

You can make adjustments to the F046141 and F04614 tables and rerun this program as many times as necessary to ensure that the returns are correct before you do the final T5018 processing.

To determine the company address to print on the T5018 returns, the Write T5018 Media program compares the company number in the F04614 workfile with the address in the Company Constants table (F0010). If the values are different, the program uses the mailing address from the address book number in the F0010 table on the T5018 forms and electronic media.