6

I have created an Auto Number with the following format: {YYYY}/{000}.

Is it possible for the number increments {000} to reset to 1 for each new year?

1 Answer 1

7

It is possible to reset the number but it needs to be done manually for each auto-number field. This help article explains it.

This can be accomplished with the following steps:

1: Click on:

Setup | App Setup | Customize | Object name | Fields | Edit Field Name | Click the Change Type of this Field button.

2: Change the field type to Text, click Next, click Save.

3: Repeat the steps noted above and change the field type back to Auto Number , this allows you to set the starting auto-number.

You will receive a caution warning that if the next number you enter is not higher than existing numbers, it may be possible to create records with duplicate numbers when changing the auto-number format multiple times using similar formats.

Note: This does not work for objects installed by managed released packages, as components below are locked: - "data type" on custom field - "record name data type" on custom object - "record name display format" on custom object

  • If you want to restart auto number fields on objects from a managed released package, you can uninstall the package and reinstall it.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .