Understanding the Build T5018 Workfile - A/P Program
The Build T5018 Workfile - A/P program (R04614) builds the F046141 table, which you use to generate T5018 returns. This program selects all paid vouchers that have the code 7 as CT for the current reporting year for the suppliers who have a value of 1, 2, 6, C, P, T, or blank in the Person/Corporation code in the Address Book system. The system uses these tables to build the T5018 Tax Workfile:
Accounts Payable Ledger table (F0411).
Accounts Payable-Matching Document table (F0413).
Accounts Payable Matching Document Detail table (F0414).
The Build T5018 Workfile - A/P program also uses processing options to define the ending date for the one year period for which to create records in the T5018 Tax Workfile.
The Build T5018 Workfile - A/P program does not generate a report. You must view Work Center messages to ensure that the program finished successfully.
After you build the F046141 workfile, you can use the Enter T5018 Workfile Adjustments program (P04610) to view the records generated and adjust them as needed. When you adjust records in the F046141 workfile, the system does not change any data in the accounts payable tables. The workfile is used only to gather information to be reported to the CRA on T5018 forms, and is not used for any other purpose.
Each time that you run the Build T5018 Workfile - A/P program, the system adds records to the existing records in the workfile.
Back up the F046141 table nightly and keep a record of the adjustments that you enter daily using the Enter T5018 Workfile Adjustments program. If you must clear the F046141 table because you erroneously updated existing records, you can restore the F046141 table, rerun the Build T5018 Workfile - A/P program using different data selection, and then re-enter only those adjustment records that were entered since the last backup.