Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

DAX 2009 Number sequence and number order logic

(0) ShareShare
ReportReport
Posted on by 10

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.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,492 Super User 2025 Season 1 on at
    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?".

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,492 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans