How_do_I_change_owner_numbers_

How do I change owner numbers?

Changing owner numbers updates the unique identifier tied to an owner record—ensuring accounts are correctly organized and referenced across the system.


What it does
The owner number links licenses, animals, billing, and payments to a specific account. Changing it reassigns that connection.


Why you would change it
You’d typically update an owner number to resolve data integrity or organizational issues:

  • Fix duplicate or incorrect records
    Merge or align accounts when an owner was created more than once.
  • Correct assignment errors
    Ensure licenses and transactions are tied to the right owner.
  • Standardize numbering
    Bring records in line with established naming or numbering conventions.
  • Support data migration or cleanup
    Adjust identifiers during imports or system-wide corrections.

 


In practice
Owner numbers are the foundation to how records connect. Changing them should be done carefully, but it’s essential when you need to ensure that all related data points to the correct, single source of truth.


Before you get started

  • Back up the database. This routine modifies or deletes transactions. Modified or deleted transactions can only be restored from a backup. (Send Databases)


Change owner numbers

Run Change Owner Numbers to perform the following tasks:

  • Renumber the owner records.

  • Start the renumbered records with the New Beginning Owner Number.

  • Assign the next owner number based on the Increment By value.

  • Update reference transactions with the owner's new number.

 

Do this...

1. Open Connect Human Resources > Organization > Change Owner Numbers.

2. Enter the Owner Numbers.

Select the owner numbers to include in the routine.

Which owner numbers do you want to renumber?

  • I want to renumber all of the owner records in the database. The preferred value is ALL, which will assign a new owner number to every record in the Animal License database.

  • I want to renumber a range of owner records. Click Values, it's located next to the Owner Numbers field. Then in the Enter Value field enter the beginning owner number, followed by a hyphen (-), followed by the ending owner number. Click OK. The new range will display in the Owner Numbers field.

  • I only want to renumber a single owner record. Click Values, it's located next to the Owner Numbers field. Then in the Enter Value field enter the owner number. Click OK. The owner number will display in the Owner Numbers field.  


3. Enter the New Beginning Owner Number.

The routine will use the New Beginning Owner Number to start renumbering owner records.

What is the number to assign to the first owner record?

  • I want to start numbering with the number 1. Leave the New Beginning Owner Number set to 1.

  • I want to start numbering with a different number. Click on the New Beginning Owner Number field, then type in the new beginning number.


4. Enter the Increment By.

This is the number of numbers that will not be assigned between the numbers that are assigned to owners.

Do you want to assign the next whole number to the next owner record?

  • Yes, I want to assign the next whole number. Enter 1 in the Increment By field.

  • No, I want to skip a few numbers before the next assigned number. Enter a whole number in the Increment By field. The system will calculate the next owner number for you. It will use this calculation: New Beginning Owner Number + Increment By = Next Owner Number. Then, it will use the Next Owner Number + Increment By to continue.


5. Click GO (CTRL+G).

The owner numbers have been reassigned.

 


    • Related Articles

    • How do I change a payment entry?

      Changing a payment entry updates the details of a recorded payment—so the transaction accurately reflects what was received and how it should be handled. What it does It allows you to correct or refine key information, such as the amount, payment ...

    • How do I add an owner?

      Adding an owner creates the primary account that everything else connects to—animals, licenses, billing, and payments. What it’s for An owner record stores contact details and serves as the central point for managing all related activity. Why you ...

    • How do I add "available owner" to unowned plots?

      Run Recalculate to add the available owner record to plots missing an owner. Purchased plots are linked to an owner, but what happens to plots that don't have an owner yet? The unowned plots should be assigned to the available owner record. The ...

    • How do I set up a new owner?

      An owner is the individual or family that owns the plot. Use Setup New Owners to add new owners to the Cemetery Management database, then use Modify Existing Owners to update or delete owner records. Setting up new owners 1. Open Connect Cemetery ...

    • How do I suppress repeated employee names and numbers?

      The default setting prints the employee number and name for each pay code and rate. Leave report showing repeated employee names and numbers Change the report option to suppress instances when the same employee number and name is displayed two or ...