How to reset Auto-Numbering and where it stores the number in database.

(0) Share

Report

Posted on by shaan

272

Hi,

I have requirement to Change Article Autonumber prefix and reset number. CRM Allows to chaneg Prefix but is there any (unsupported) way to reset the number?

I have updated the Prefix at Settings > Administration > Auto-Numbering

But Number field is grayed out. I have looked into database, can find where it stores the number.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Hayer 804 on at

Like (0)

Report
I am not sure about the consequences of updating KbNumber unsupported way, but CRM Store is in OrganizationBase table.

SELECT [KbPrefix],[CurrentKbNumber] FROM [dbo].[OrganizationBase]

I think if you update number in SQL it can cause issues by creating a number which already exists. But If you are changind Prefix as well that can reduce the risk.

Again, I have not tried in myself and I am not a big fan of Unsupported things. So Please be careful that you are not breaking anything.

**UPDATE**

Just tried it to see if it causes any issues, please check my experience here http://hayercrm.blogspot.com/2015/03/how-to-reset-auto-numbering.html

You can also update it using SDK: http://hayercrm.blogspot.com/2016/02/how-to-reset-auto-numbering-in-dynamics.html

Was this reply helpful? Yes No