Troubleshoot the T5018 report
The following topic explains common problems that you might encounter and their solutions.
After you enable T5018 in Configure Accounts Payable, assign T5018: Run permissions to the user who will run the report.
A user with permissions can run the report from Accounts Payable > All tab > Reports > T5018 > T5018 report.
If you are not seeing data that you expect to see in the report, verify the following:
- Suppliers that you want to include in the report are enabled for T5018.
- Payments made to these suppliers were completed within the report time period.
- Payments are over the Minimum amount defined on the report.
To remove a supplier, deactivate T5018 in the supplier information record.
- Go to Accounts Payable > All > Suppliers.
- Find the vendor that you want to deactivate in the list.
-
Select Edit at the end of the row.
- On the Additional information tab, deselect Enable T5018.
- Select Save.
- Go to Accounts Payable > All > Suppliers.
- Select Edit next to the supplier you want to deactivate.
- On the Additional information tab, deselect Enable T5018.
- Select Save.
The supplier will no longer be included when you generate the report.
Run the report in Accounts Payable > Reports >T5018 > T5018 report. You can run the report across different time periods to view different results.
Accounts Payable > T5018 > Export T5018 form generates an XML export file for that fiscal year that's formatted to meet the filing guidelines set forth by the Canadian Revenue Agency (CRA). Use this XML file to file with the CRA. You can also generate an amended or canceled XML file.