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) / Number sequences: Numb...
Microsoft Dynamics AX (Archived)

Number sequences: Numbers with status Free not used

(0) ShareShare
ReportReport
Posted on by Community Member

We have a number sequence for purchase invoice vouchers, continuous=Yes. There are several numbers in the action list with status Free. But if I create a new purchase invoice these numbers are not used, but it is taking the "next number" which is higher.

I have read several topics about number sequences, but not found a solution... Who can help?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    By the way, we are running AX 2012, R3

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    The number sequence has a status list form that lists numbers that have not been used for example because a PO is deleted after it was setup, etc.

    If you regularly delete this list for example by specifying the automatic cleanup for this number sequence, all numbers will eventuall by used.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi,

    I have run the cleanup and there are several numbers with status Active. I do not understand why these numbers are not used.

    kind regards

    Ina

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    ... and your status list does not include any record?

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi,

    It does. Even today new records. But they are not picked up, if I create a new purchase invoice voucher it is taking "next number".

    regards

    Ina

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ina,

    Delete all of the records that you see in this list with Alt+F9.

    Then those numbers will be picked up again.

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi,

    But should AX not pick up these number from the action list? If I delete all records from the action list (NumberSequenceList) then these numbers are gone..

    regards

    Ina

  • Mariano Gracia Profile Picture
    Mariano Gracia on at

    Although its out of place, Microsoft recommends to use non continuous number sequences unless it is necessary:

    Number sequences:

    Recommendation:
    -For each number sequence, unless there is a regulatory requirement that you use continuous, we recommend that you use non-continuous for better performance*
    -Where number sequences absolutely must be continuous, 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.*
    -Use pre-allocation for non continuous number sequences**

    *Further details: Number sequence overview [AX 2012]
    **Explanation: http://blogs.msdn.com/b/axinthefield/archive/2011/05/02/how-preallocated-number-sequences-are-cached-in-ax.aspx

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ina,

    No, those numbers won't be gone but become available again for usage.

    If you are not sure, test this in demo Environment for example by Setting up a new PO/SO, saving it and deleting it immediately.

    Ludwig

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ina,

    Just wondering if you have been able to get this tested.

    Would be great if you could keep us updated here and inform aus about any other help that might be required.

    Many thanks,

    LUdwig

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
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans