This may be caused by one of the following:

• No vendors are marked to receive form T5018
• Vendors have no payment in the current transaction file for the period you are running the T5018
• Record Level Security is turned on and the user attempting to generate the T5018s has restricted access to CM Bank Account records and/or GL Prefix records

If Record Security is being used:

Determine if you need to change the user's record security access or if the task should be performed by a different user who has access.

• For information about modifying record security access, refer to article ID 34639 DocLink: How to set up Record Level Security.
• For information about turning off record security all together, refer to article ID 40471 DocLink: How do I turn off the Record Level Security feature?

To verify vendors are selected to Receive form T5018:

See article How do I set up a vendor to receive a form T5018 in Accounts Payable?

To verify vendors have payments during the period, use the Paid Invoice Register:

Note: If Record Security is activated, it will affect this report. Have an application administrator run the report to ensure that vendors and data are not being omitted.

1. In Accounts Payable select Reports, Cash Management, Paid Invoice Register.
2. Select the AP Master file and click OK.
3. Enter the appropriate date range for the T5018 amounts.
4. Click Conditions.
5. Click Add.
6. Click Index.
7. Select AP - Vendor then click OK.
8. Under the Field, select Receives form T5018.
9. Under Operator, select Equal to.
10. Under Value, mark the check box.
11. Click OK.
12. Click OK.
13. Print or preview the results as desired.
14. Repeat steps above on the AP Invoice (history) instead of AP Master.
    • If the Vendor is listed when ran on AP Master but not when ran on AP Invoice (History), the payments have been moved to history. The vendor can be manually added to the T5018 on the Canadian Preparer window from the Edit menu select Rows, and Insert.
    • If the Vendor was not listed on reports they have not received payment during the time specified. The vendor can be manually added to the T5018 on the Canadian Preparer window from the Edit menu select Rows, and Insert. You must correct the data within Accounts Payable for the changes to be permanent, record missing invoices and payment or correct the effective/check dates.