web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Is there a way to get ...
Microsoft Dynamics AX (Archived)

Is there a way to get a list of the tables and fields for each item in number sequences?

(0) ShareShare
ReportReport
Posted on by Community Member

Have a bit of an issue. Due to some changes performed on our AX system we had one of our Nubersequences get decremented below the original starting number we used. We have corrected that, but I would like to be able to compare the actual values in the tables with the Next number stored in number sequences. Is there an easy way to get a list of all the fields and tables that are fed by each of the Numbersequences?

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 238,286 Most Valuable Professional on at

    On the other hand, one number sequence generally shouldn't be used for assigning numbers in multiple tables. Things like references in parameter tables are indeed mere references to the actual table where numbers are assigned. Unless the relation is broken in addition to the problem with number sequences (no such problem with relation integrity was mentioned, therefore I assume it's not the case), checking the main table is sufficient.

    It's not 100% reliable, but I think that checking the related table of the EDT associated with a given number sequence would work in many cases. And often the logical relation is immediately obvious, e.g. that SalesId EDT is used as the primary key of SalesTable.

  • Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    I am afraid there is no easy way. The reason is you could consume from a specific number sequence using X++ code defined in setups, or stored as a reference on a parameter table. The sequences are also defined on Extended Data Types, which could be used in a set of tables. Because of those reasons nothing can guarantee a 1:1 relationship between an entry in the Number sequences, and where it is actually being used. Thus retrieving such information would be quite complicated.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans