web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    Martin Dráb Profile Picture
    Martin Dráb 236,275 Most Valuable Professional on at
    RE: Numbers missing in number sequence

    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.

  • MnsMsdn Profile Picture
    MnsMsdn 75 on at
    RE: Numbers missing in number sequence

    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

  • Martin Dráb Profile Picture
    Martin Dráb 236,275 Most Valuable Professional on at
    RE: Numbers missing in number sequence

    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.

  • Suggested answer
    Dick Wenning Profile Picture
    Dick Wenning 8,705 Moderator on at
    RE: Numbers missing in number sequence

    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.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans