I have deleted all records from a module, yet the auto-number field for a new record I create continues from the previous order rather than #1. How do I correct this?

I have deleted all records from a module, yet the auto-number field for a new record I create continues from the previous order rather than #1. How do I correct this?

Assume you have created 10 records in a module. These have been created in an order specified by your Auto-number field settings. You are now deleting all those records because you want to start afresh. When you create a new record, the auto-number reads #11 whereas ideally you want it to start with #1.

This happens because the records that you have deleted are still part of the CRM system in its Recycle Bin. Go to Setup > Data Administration > Recycle Bin and empty the trash. Now when you go back and create a new record in your module, you will see that the Auto-number settings have been corrected.

    • Related Articles

    • How can I create and send invoices?

      An invoice is a bill issued by a vendor to a customer with the goods or services they ordered. It usually contains the purchase order reference number, date, billing address, shipping address, terms of payment, and line items (products or services) ...
    • How do I create an auto number field?

      You can create an auto number field by following these steps: Log in to Zoho CRM with Administrator privileges. Click Setup > Customization > Modules and Fields. Select the Module from the Modules list view. Drag and drop the Auto Number field type ...
    • De-duplicate records (Auto-merge duplicates)

      In case you are not sure which records have been duplicated, you can let CRM run a check on modules using the De-duplicate tool. CRM will automatically find and merge exact matches. In case of conflicts in field values, you must manually resolve the ...
    • How do I create multiple sales pipelines?

      Pipelines can only be created for the Deals module. To create a pipeline, follow the steps below: To create a sales pipeline Go to Setup > Customization > Pipelines. Click New Pipeline. Enter a name and select the Layout to associate the pipeline ...
    • How can I create inventory templates?

      Zoho CRM has a gallery of predefined inventory templates, you can choose any sample and use it for your business purpose. Alternatively, you can build a template of your own and customize it as needed.  Follow the steps below to create a template: ...