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

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) / Purpose of number sequ...
Microsoft Dynamics AX (Archived)

Purpose of number sequence cleanup?

(0) ShareShare
ReportReport
Posted on by lally 8

Hi All ,

There is process called number sequence clean up , Could I know the reason why we need to do that and business reason ?

How frequently we need to run the number sequence clean up ?

If we run this function , what will happen in the back end ?

What is the suggested time to run this cleanup process ?

*This post is locked for comments

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

    lally, please make sure you use descriptive titles for your threads. Let me rename this thread from "Number sequence" to "Purpose or number sequence cleanup".

  • Martin Dráb Profile Picture
    Martin Dráb 239,022 Most Valuable Professional on at

    Let me quote what AX documentation tells about it (in Number sequence overview, which was the first link my search engine gave me what I asked it about sequence cleanup):

    Automatic cleanup of number sequences
    In case of a power failure, an application error, or other unexpected failure, the system cannot recycle numbers automatically for continuous number sequences. You can run the cleanup process manually or automatically to recover the lost numbers.
    Carefully consider server usage when you plan the cleanup process. We recommend that you perform the cleanup as a batch job during non-peak hours.

  • lally Profile Picture
    lally 8 on at

    [quote user="Martin Dráb"]In case of a power failure, an application error, or other unexpected failure, the system cannot recycle numbers automatically for continuous number sequences. You can run the cleanup process manually or automatically to recover the lost numbers.
    [/quote]

    I already gone through the MS TechNet before I post the question , but the link does not help to understand my queries .

    Even the above context , what you have quoted makes bit confuse as need to run the clean up to recover lost numbers , what does it mean ?

    How does it lost ?

    How frequently we need to run the number sequence clean up ?

    If we run this function , what will happen in the back end ?

    What is the suggested time to run this cleanup process ?

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 239,022 Most Valuable Professional on at

    How does it lost?

    As the documentation says, it can happen because of "a power failure, an application error, or other unexpected failure". Anything that prevents the application to return a reserved number back to the pool.

    How frequently we need to run the number sequence clean up?

    It's up you how often you want it to happen.

    If we run this function , what will happen in the back end?

    As the documentation says, the system recycles numbers for continuous number sequences. It finds them and puts them back to the pool.

    My suggestion is avoiding the whole problem (and related performance problems) by not using continuous number sequences at all, if possible.

  • lally Profile Picture
    lally 8 on at

    Thanks for the reply ,

    [quote user="Martin Dráb"]Anything that prevents the application to return a reserved number back to the pool[/quote]

    [quote user="Martin Dráb"]the system recycles numbers for continuous number sequences. It finds them and puts them back to the pool.[/quote]

    Could in detail the above sentences and what do you mean by back to pool ?

    Where system reserve the number and can we see those numbers ?

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

    Each AX AOS instance caches a couple of number sequences to be used in advance from a pool, and also you could reserve numbers in X++. Now if it is being consumed by a record for which the transaction is not committed (error, power failure, crash, etc.), AX has to release the numbers to make it available again for filling the gaps for a continuous number sequence. The cleanup frees up the numbers which could be allocated again.

  • lally Profile Picture
    lally 8 on at

    Thanks for the reply ,

    [quote user="Vilmos Kintera"]AX has to release the numbers to make it available again for filling the gaps for a continuous number sequence. The cleanup frees up the numbers which could be allocated again.[/quote]

    Could you explain with an example above one and what do you mean by cleanup frees up the numbers ?

    In the number sequence form , there is tab called Free numbers ....what does it mean , when the records still store in this tab ?

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

    lmgtfy.com

    First hit provides explanation. Learn to google better!

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

    Can you please make sure you tick the checkboxes for helpful answers next to each post, so the topic gets resolved? Thank you.

  • K.G Profile Picture
    K.G 20 on at

    None of your responses were helpful and no, the results on Google don't provide the answer to the actual question. Either respond with something that adds value or don't respond at all.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans