Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : MA2h+u60Vqr1lEhu9AWiuX
Microsoft Dynamics AX (Archived)

Alphanumeric number sequence

Like (0) ShareShare
ReportReport
Posted on 2 Nov 2017 05:11:59 by 346

Hi All ,

AX 2012 R3 

The requirement is regarding the Alphanumeric number sequence .

Client wants have the number sequence format such as 

Company - Constant - Alphanumaric

GE  - SO  - AAAAA111111

Assume that if the number reaches to GE  - SO  - AAAAA999999 ,then system should generate the next number sequence such as GE  - SO  - AAAAB100000....again when it reaches to AAAAB999999, then next number should be AAAAC100000....

I heard the above requirement is possible in AX ..Could any one guide me the how to setup ?

Thanks in advance

*This post is locked for comments

  • Suggested answer
    Khushhal Garg Profile Picture
    Khushhal Garg 1,514 on 28 Oct 2019 at 20:35:49
    RE: Alphanumeric number sequence

    You can setup such number sequence configuration except changing A to B when it reaches 9999999. In this case it will require to update from A to B manually in number sequence configuration or code can be written to update it

  • real_ashwin Profile Picture
    real_ashwin 1,221 on 28 Oct 2019 at 09:04:58
    RE: Alphanumeric number sequence

    I dont believe this kind of number sequence can be setup in AX.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard on 26 Oct 2019 at 11:14:33
    RE: Alphanumeric number sequence

    Hi sri17,

    What is this number sequence used for?

    Sales orders?

    Trying to increase the number sequences by letters 'AAAAA', then 'AAAAB' etc. seems a bit odd because as a user I usually start searching for the sales order number first and not for constants.

    Why don't you simply increase the length of the numbers rather than using a dynamic letter based sequence in front.

    Who asks for this and why?

    Best regards,

    Ludwig

  • Martin Dráb Profile Picture
    Martin Dráb 231,178 on 25 Oct 2019 at 15:31:56
    RE: Alphanumeric number sequence

    Don't you have too low value in the field called "Largest"?

  • sri17 Profile Picture
    sri17 346 on 25 Oct 2019 at 15:09:47
    RE: Alphanumeric number sequence

    Thanks Martin

    I tried this option only ,but not meeting expected results .

    Assume that number sequence code is GE  - SO  - AAAAA111111 and reached last number GE  - SO  - AAAAA999999 then automatically it should update next number as GE  - SO  - AAAAB100000.

    But application throws an error that number sequence is excedded when it reaches AAAAA999999.

    Could i know the reason ?

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 231,178 on 02 Nov 2017 at 07:00:28
    RE: Alphanumeric number sequence

    It is. Use a scope for company and format &&&&&###### for the alphanumeric ID.

    You can find details in documentation: Set up number sequences [AX 2012].

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,358 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,178

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading started