How do I delete vendors?

Delete a vendor record completely from Accounts Payable.

Use Delete Vendors to delete the vendor record and associated records, which include:

  • Vendor summaries

  • Checks

  • Invoices

  • Purchase orders

  • Requisitions

Important! Vendors with open transactions cannot be deleted.

 

Step 1: Back up the database

See the help topic titled How do I back up the database?

 

Step 2: Delete vendors

1. Open Connect Accounts Payable > Vendors > Delete Vendors.

2. Set up the Selection Criteria.

Use the Selection Criteria to filter and select vendors.

What do you want to do?

  • Prompt me to enter the vendor numbers when I run the routine. Change the value assigned to the Vendor.Vendor number to {Prompt for value}.

  • Include all vendors. Change the value assigned to the Vendor.Vendor number to All.

  • Let me choose which vendors to include. Double-click the value assigned to the Vendor.Vendor number field. Then, use the Values Entry form to enter a vendor number, range, or series. Use a comma (,) to separate each entry. Use a dash (-) to separate a range.

  • Use a different field to filter data. Double-click the column labeled Column. Then, use the Selection form to move the fields that you will use to filter data to the Selected Criteria Fields list.  

3. Set up the checkbox titled Only Remove Vendors With Termination Dates On or Before.

Use this option to use the termination date stored in the vendor file as the basis for deleting vendors. Only vendors that have a termination date AND the termination date occurs on or before the date entered will be deleted.

Do you want to use the termination date to delete vendors?

  • Yes, delete vendors based on the termination date. Click to select Only Remove Vendors with Termination Dates On or Before. Use the default date or enter a date that occurs before the default date. This date calculates based on the value stored in Organization > Organization > Keep [ _ ] Years of History.

  • No, do not delete vendors based on the termination date. Click to deselect Only Remove Vendors with Termination Dates On or Before.  

4. Set up the checkbox titled Only Remove Vendors With No Activity Since.

Use this option to search for vendors that do not have activity recorded prior to the date entered.

Do you want to use an absence of vendor activity to delete vendors?

  • Yes, use an absence of vendor activity to delete vendors. Click to select Only Remove Vendors with No Activity Since. Use the default date or enter a date that occurs before the default date. This date calculates based on the value stored in Organization > Organization > Keep [ _ ] Years of History.

  • No, do not delete vendors based on vendor activity. Click to deselect Only Remove Vendors with No Activity Since.

5. Click GO (CTRL+G).

The vendor is deleted.

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.