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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Number Sequence Number used but still remains on status list (CU13 Feb'2019)

(0) ShareShare
ReportReport
Posted on by

Hi All,

On my customer, after the an upgrade performed during last December from Dynamics Ax 2012 R3 CU13 to Dynamics Ax 2012 R3 CU3 Feb'2019 (build 6.3.6000.8149) I am facing a very strange error.

Not for all users, not for all number sequence, not always for the same process, but many times during the labor day, we get an error like the following:

  • Purchase number %1 is already in use.
  • Voucher %1 is already used as at date %2.
  • Voucher %1 is already being used.

When we went to investigate, we notice that the number that is in one of the three messages above instead of the %1 already exists as a document posted or a voucher transaction also posted.

The system is trying the use the number in question, because his still remains on the status list form of the number sequence. The number is in the status "active" and is assigned to the user that receive the error log during the process that he's executing.

Someone with the same problem in the past?

Can the problem be related to a setup on number sequence? Can the problem be related to Ax code? Can the problem be located on the stored procedure "getNumInternal"?

Thank you.

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Pedro,

    Do you make use of the 'automatic cleanup' function for your number sequences?

    Is this configured?

    Do you know if this issue happens to users that open and work in multiple AX sessions at the same time?

    Best regards,

    Ludwig

  • Pedro Santos Profile Picture
    on at

    Hi Ludwig,

    Yes, we've the "automatic cleanup" set up to 24 hours for the number sequences with issues.

    This setup came from the last version (CU12), and on the past no issues like that were reported.

    No, isn't normal the users use/have more than a session. Furthermore, in some cases the number suggested to be used (and that will cause the number sequence error) was already used on the past, and when I say "past" many times is few days/weeks ago and not in the same day. So, we do not believe that the origin are the multiple client sessions.

    Thank you.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans