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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Numbers missing in num...
Microsoft Dynamics AX (Archived)

Numbers missing in number sequence

(0) ShareShare
ReportReport
Posted on by MnsMsdn 75

Hi,

We have created a number sequence for invoice numbers as part of our project , the number sequence mode is Non continuous with range from 1 to 99999. There was a strange issue we ran into... The numbers got generated from 1 to 120 fine and later the next numbers started from 140 onwards. We have no invoices generated at our source that we could trace back. [Unless we have a source initiation , AX would not generate the next number, is our understanding. We had similar setting since 3 years and we never had an issue with next number being out of sequence.

We checked Number sequence history if someone accidentally set the next number as 140 but there were no records found.

Any help is very much appreciated

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Dick Wenning Profile Picture
    Dick Wenning 8,705 Moderator on at

    did you turn on caching

    If you use a non-continuous number sequence, you can enable Preallocation on the Performance FastTab of the Number sequences form. When you specify a quantity of numbers to preallocate, the system selects those numbers and stores them in memory. New numbers are requested from the database only after the preallocated quantity has been used.

  • Martin Dráb Profile Picture
    Martin Dráb 237,801 Most Valuable Professional on at

    Non-continuous number sequences obviously don't guarantee continuity. If a number is allocated and not used (the record doesn't get saved by any reason), or if numbers are pre-fetched by AOS, you can get such gaps. That's normal and expected behavior.

  • MnsMsdn Profile Picture
    MnsMsdn 75 on at

    Number sequences can be continuous or non-continuous. A continuous number sequence does not skip any numbers, but numbers may not be used sequentially. Numbers from a non-continuous number sequence are used sequentially, but the number sequence may skip numbers.

     

    Above is the excerpt from AX product documentation . Given that a non continuous sequence may skip numbers, is there No way I can check why and when , if an event of missing numbers pops up? Because we have never faced this issue throughout our experience wih AX 2012

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 237,801 Most Valuable Professional on at

    No, such things are not logged anywhere.

    If you really need a continuous number sequence, use one. If you don't need a continuous sequence, just don't care about gaps.

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

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 November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans