D365FO - Error - Number sequence inve_4 has been exceeded and FORMULA TO FIND OUT WHICH EXCEEDS

Hi,

D365FO - Error - Number sequence inve_4 has been exceeded

Error - While releasing sales order user is getting below error

Solution:

1. Go to Organization administration -> Number Sequence, and then find and adjust the number sequence.

2. Increased Alphanumeric to 6 to 9 (i.e. ###### to #########)

3. Changed largest number from 999999 to 999999999

After saving above settings user tried releasing same order

FORMULA TO FIND OUT WHICH EXCEEDS

Download the Sequences in excel sheet- 

WITH THE FORMULA TO FIND THE WHICH IS EXCEEDS DOWNLOAD THE SHEET IN EXCEL AND PUT A FORMULA TO FIND OUT WHICH EXCEEDS

https://organicax.com/2017/04/28/number-sequence-has-been-exceeded/ 

https://cloudblogs.microsoft.com/dynamics365/no-audience/2014/04/29/number-sequence-xxxx-has-been-exceeded/

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/158276/error-message-number-sequence-5637145302-has-been-exceeded

http://rrabbani.blogspot.com/2017/12/number-sequence-xxxxxxx-has-been.html

http://www.axsolution.com/?p=237

https://docs.microsoft.com/en-us/dynamicsax-2012//number-sequences-form