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.