One of the great things about helping newer members of the SugarCRM community is that they often help me remember some customization needs that are not frequently asked by others.
A good example of this came up just a few days ago on the SugarCRM Forums when a user asked if it was possible to change the starting point for the numbering sequence on Cases. By default, SugarCRM begins at the number 1 and automatically increments it by 1 whenever a new Case is added. However, many users would prefer it to start at a different number.
So, how does one change the start point?
It is actually rather simple and requires two things: access to a MySQL administrative tool such as SQLyog, phpMyAdmin, etc. and a single SQL command.
Assuming you already have access to the administrative tool, executing the following command would do the trick for you:
ALTER TABLE cases AUTO_INCREMENT = nnn;
Where nnn represents the starting number you wish to apply. For example, to set the starting point to 1000, use the following command:
ALTER TABLE cases AUTO_INCREMENT = 1000;
That is it! Quick and easy!