Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Number Sequence in Ax 2012

Posted on by Microsoft Employee

Please give the link generating number sequence for your own Table and form in AX2012  and also  explain why we use number sequence and what is the difference between RecID and NUmberSequence in AX 2012

*This post is locked for comments

  • Suggested answer
    Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at
    RE: Number Sequence in Ax 2012

    RecId vs NumberSequence.

    RecId is of type Int64, which is perfect as a record identifier / index at the DB Level. eg: 56827463, 56827464.... which doesn't convey much info to the user.

    NumberSequence can be of a combination of types. eg: Emp000009, WH1-204, Prod135987, SO-IC345433, SO-DOM123454 which could correspond to an Employee, Warehouse, Production order, Sales order (intercompany), Sales order (domestic). You see, there is some hint / useful info on the number sequence to the user. But this is not necessarily a strong index as much as a RecId.. Hence you make use of 2 different fields..

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Number Sequence in Ax 2012

    Hi Jamil,

    Please refer to the below link, you will able to create a number sequence.

    http://axsuresh.blogspot.com/2016/03/number-sequence-creation-in-2012.html

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Number Sequence in Ax 2012

    Hi Jamil,


    You can follow the method in this article:
    https://community.dynamics.com/ax/b/faheemahmeddynamicsax/archive/2016/09/29/how-to-use-your-custom-created-number-sequence-on-form-ax-7


    RecId is a unique identifier of a record (uniqueness is per table from AX 2009). There wont be any setup to modify the recId sequence, the kernel will handle the recId generation.
    Number sequences in Microsoft Dynamics AX are used to generate readable, unique identifiers for master data records and transaction records that require identifiers. A master data record or transaction record that requires an identifier is referred to as a reference.


    Number Sequence refer : https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/number-sequence-overview

    RecId refer : http://deepakdyanmicsax.blogspot.com/2014/03/record-ids-in-ax-2012_5.html

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Number Sequence in Ax 2012

    Hi,

    Can you elaborate your question?

    I do not fully understand what you are asking for.

    Would be great if you could provide some additional details.

    Thanks,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans