Summary

There may be times when you want to reset the numbering sequence being used by the Incident module to either continue from a specific number (e.g. if you want the number to continue from an old paper-based system) or to reset the numbering sequence to begin again (e.g. when entering a new calendar year). The steps outlined in this article cover how to change the prefix created in the Administration module and also how to update the number sequenced used by this prefix.

Solution

1. To reset the number for a new calendar year
2. Updating the sequence to begin from a specific number

1. Update the prefix for the year
2. Reset the number sequence

1. Launch the Administration module
2. Go to the Incident Numbering Sequences section
3. Highlight the sequence you would like to change and click [Edit]

4. Change the prefix to match the current year (e.g. change 'INC-2019-' to 'INC-2020-').
5. Click [OK]

1. On the database server, launch Microsoft SQL Management Studio and connect to the database
2. Take a full backup of your database
3. Click the [New Query] button
4. Copy the following query into the query window:

5. Review the query to confirm:

• The correct database has been specified (in this example, it is listed as QPulse5)
• The desired number has been specified (in this example, it is set to '0' so the next number assigned in Ideagen Quality Management will be 1)
• The correct prefix has been specified (in this example, the prefix chosen is INC-2020-)

6. Right-click on the query and select [Execute].