How_do_I_renumber_vendors_2023.08_

How do I renumber vendors? (2023.08)

Change vendor numbers assigned to vendors. Run Renumber Vendors will place the vendors in alphabetical order (A-Z) and then assign a new vendor number. The starting vendor number and increment number is left to your discretion. When a vendor number is updated to a new vendor number, the transactions that reference the old vendor number will be replaced with new vendor number. 

For example, Jane set up the following vendor records: 100 Ace Hardware & Lumber, 110 Acme Equipment Rental, 120 ACS Collections, and 130 AMCO Equipment & Steel. As time goes on, Jane adds 115 ACME Office Supplies and 116 ACME Window Washing. When Jane needs to add ACME Wax Works, she realizes that she has a problem because there are no more numbers left to assign to the new vendor between 115 ACME Office Supplies and 116 ACME Window Washington. 

 

 

To solve the problem, Jane adds ACME Wax Works and then she renumbers the vendors. When she's done, the list looks like this...

 

 

What's new?

  • Renumber vendors in alphabetical order (A-Z). (2023.08)

 

 

Renumbering vendors

 

Step 1: Back up the database

Running this routine will modify vendor records. You should make a backup just in case you need to restore the old vendor records. See the help topic titled How do I back up the database?



Step 2: Renumber vendors

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

2. Enter the Vendor Numbers.

Use ALL to renumber all vendor records. Replace ALL with a single vendor number or a vendor number range. Use a dash to separate a range (100-300). 

3. Enter the New Beginning Vendor Number.

The beginning vendor number is the first number that will be assigned to the first vendor that will be renumbered by this routine. This routine will sort the vendors in alphabetical order, and then it will assign a new number to the vendor. 

4. Enter the Increment By value.

This is the value to increase a value or number. For example, Jane wants to increase vendor numbers in increments of 10. She uses 10 as the New Beginning Vendor Number and enters 10 in the Increment By field. When the routine runs, the vendor numbers are assigned like this: 10, 20, 30, 40, 50...

5. Click GO (CTRL+G).

The vendor records are sorted in alphabetical order and assigned a new vendor number. 

 

202311, 2023Jun06

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • How do I add files? (Vendors)

      Add PDFs, Word docx, Excel spreadsheets, and images to a vendor record. Adding an attachment to a vendor 1. Open Connect Accounts Payable > Vendors > Setup New Vendor or Modify Existing Vendor. 2. Click to select the Attachments tab. 3. Click Add a ...

    • How do I pay vendors using an electronic funds transfer?

      A direct payment is a payment made to the account of the payee. For example, Jane rents a backhoe periodically from Acme Equipment Rental to complete general maintenance. She sets up a direct payment to withdraw funds from the organization's bank ...

    • Warning: Vendor number ### exceeds the maximum vendor number allowed

      Issue When you run the Renumber Vendors routine, the Cannot Run Process dialog box displays a warning message: Vendor number ######## exceeds the maximum vendor number allowed. The vendor number cannot exceed 999999999. No changes were made. Cannot ...

    • Warning: Vendor number ### already exists

      Issue When you run the Renumber Vendors routine, the Cannot Run Process dialog box displays a warning message: Vendor number ### already exists. No changes were made. Cannot Run Process dialog box Solution Check if there's a vendor number that you ...

    • Webinar: Setting up and modifying vendors (00h18m41s)

      In this webinar, learn how to: Set up a new vendor. Make changes to an existing vendor. 202502, 2025Jun16 Copyright © 2025 Caselle, Incorporated. All rights reserved.