Is it possible to have quotes, cases, and bugs to start at a particular number instead of starting at 1?

Precondition

You are an administrator, or have access to the database that Sugar points to.

Solution

Starting with Sugar 6.0, you can set the starting number for quotes, cases, and bugs in Studio. In Studio, navigate to the quote_number, case_number, or bug_number field, set the number in the “Auto Increment Next Value” field, and click Save. You can also set the number for custom modules that you create using the Issues template in Module Builder.

In versions prior to 6.0, you will have to use a SQL command to set the number.

The following example describes how to change the numbering for quotes:

Run the followiong SQL command:

ALTER TABLE quotes AUTO_INCREMENT =1600;

The example SQL command above is telling Sugar to start the Quotes at 1600.

To have cases start at 2000, then use the following SQL command:

ALTER TABLE cases AUTO_INCREMENT =2000;