DAX 2009 Number sequence and number order logic

(0) Share

Report

Posted on by ChrisTackleberry

We have been running DAX 2009 since 2012.
Currently, our upgrade to D365 is on hold and we are being asked to optimize the current system and set it up to work for another 2-3 years.

The current issue is the number sequence for grouping production orders.

Number sequence PROD_06 was PREVIOUSLY set up as follows:
Smallest : 1
Largest: 999999
Format: ABC######

We hit ABC999999 and got stuck. Our DAX support team changed the number sequence as follows:
Smallest : 1
Largest: 9999999
Format: ABC#######

This allowed us to group again. However, when we try to search for the sequence, the numbers show out of order.
EXAMPLE: ABC1000000, ABC100000, ABC1000001, ABC1000002

The side effect of this is that we can no longer filter for a sequence of "ABC100000.." without very old orders being selected as well.

Is there any way to make AX look at these sequences differently?
Did our DAX team set the number up incorrectly?
Or is this just built0in logic that can't be defeated?

Thanks.

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 292,869 Super User 2025 Season 1 on at

Like (0)

Report

RE: DAX 2009 Number sequence and number order logic

Hi Chris,

When the number sequence used the largest number, there is an option to add a digit, like done in your example or change the prefix. I don't know the meaning of the prefix, so I can't suggest if that would be the better choice here.

Unfortunately, the sorting and filtering will have indeed an impact with the current change. You can consider adding an additional filter on e.g. a date field, or change the value of the filter on the production order like "ABC100000?".