Find Vendor Activity

This option allows you to find all activity on a vendor since a specified date. Information on this report can be used to help you determine if a vendor needs to be inactivated. When you key an Activity Since Date, the system checks A/P, G/L and A/R for any activity on all vendors. If a vendor has not been used in any of these applications, you can then decide whether or not to inactivate the vendor. You may also use this report to audit vendors who are inactive by checking the Include Inactive Vendor checkbox. Other features include a selection to print addresses on the report. The vendor's address will help you distinguish between vendors having similar names.

1. Select Admin|Find Vendor Activity.

Find Vendor Activity Prompt

2. Key a full date in the "Enter Activity SINCE date" field. Only activity from this date to present will be checked.

3. Key a full date in the "Enter Creation Date limit" field. Vendors created after this date will be ignored. This allows you to enter a more recent date so that newly created vendors can be excluded from the collection, as they may not have had time to acquire activity.

4. Click in the Include Inactive Vendors checkbox to include active as well as inactive vendors.

5. Click in the Include Address on Report to help you distinguish between vendors having similar names.

6. Click the Next icon to display the Printing Selections Window.

7. When the system checks for activity in A/P, G/L and A/R, the following information is listed on the report:

• If there is activity found in A/P, then the last entry and voucher number is shown along with the last check date and check number.

• If there is activity found in G/L, the last entry date is shown along with the G/L Document Number.

• If there is activity in A/R, the last invoice date and invoice number is shown.

• If there is no activity, the vendor is shown with the comment that there was no activity at all found.