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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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)
  • 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.

  • Martin Dráb Profile Picture
    Martin Dráb 239,684 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.

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 Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dserp Profile Picture

dserp 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans