Number sequences in AX 2012

I’ve just spent a week with a new client thinking about the setup of a brand new AX2012 implementation and I was going to write a post about Number sequence setup, but Amir Khoshniyati just beat me to it, so I recommend you take a look at his post here.

So I’ll just re-iterate his very sound advice:

  • Keep your number sequence formats to 10 characters
  • Make your number sequence formats unique in a company with a two or three character prefix
  • Make your number sequence formats unique across all companies by embedding a one or two character reference to the company

And finally, my own 2-cent’s worth; keep an eye on your number sequence ‘next’ numbers during testing and after go-live. I often think that letting a number sequence run out of numbers is a bit like letting your car run out of the petrol on a motorway – something I confess I’ve done twice. There’s no simple report or alert that you can setup, but in AX 2012 you can see all of your number sequences in a single form. Go to Organisation administration > Common > Number sequences > Number sequences:

As you can see from the screenshot you can sort that form by ‘Next’ number, but really you’ll want to filter it by ‘Largest’ as well.

What do you do when a number sequence is running out of room? Well the simplest solution (if you’re using a unique prefix) is simply to change the prefix (by incrementing one of the characters) and re-set the ‘Next’ number to 1.

If you do review your number sequence formats during testing you’ll notice that some number sequences are used much more frequently than others. The ones I always setup with extra large numbers are the Inventory management Lot-Id and Master planning Planned order numbers.