AX Number Sequence Consumption Follow Up

Submitted by Nathan Clouse on 02/07/16.

Last modified: 

01/30/17

Tags: 

As a follow up to this article, a quick and easy way to find number sequences that have been exhausted is to do the following:

  • Go to Organization Administration > Common > Number Sequences > Number Sequences
  • Export the entire page to Excel using the button or CTRL + T
  • In the column farther to the right, do "=[]-[]"
  • sort the farthest right column A to Z
  • Any value that is -1 is a number sequence that is completely consumed. All others are approaching complete consumption