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.

  • Pedro Santos Profile Picture
    on at
    RE: Number Sequence Number used but still remains on status list (CU13 Feb'2019)

    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.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Number Sequence Number used but still remains on status list (CU13 Feb'2019)

    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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,202 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans