Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Duplicate number in nu...
Finance forum
Suggested answer

Duplicate number in number sequence

Posted on by 1,416

We are using continuous number sequence for customer account in AR. We are facing a frequent issue with customer account numbers. As you can see below the next number system generates for customer account is a duplicate and has already been used.

5775.Image1.jpg

Looking at the status list for this number sequence, we can see that 2319 has status "Free" and that's why system picks this one as the next number.

Image2.jpg

The question is how can a number be available in the status list when it has already been consumed? We are also using automatic cleanup for this number sequence as recommend by MS.

Image3.jpg

Is this a bug or are we missing some configuration? Please advice. Thanks!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,186 Super User 2024 Season 2 on at
    RE: Duplicate number in number sequence

    Hi Muhammad,

    Do you have customizations or processes where you import customers? It could be related to a customization as well. If you don't have them, like Ievgen mentioned, you can log an incident for Microsoft Support.

  • M Anas Khan Profile Picture
    M Anas Khan 1,416 on at
    RE: Duplicate number in number sequence

    Hi Blue,

    This is what we are doing as a workaround, deleting from the status list. However the issue pops up again after sometime which is frustrating.

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Duplicate number in number sequence

    Hi Muhammad,
    Sorry, I failed to reproduce your problem.

    The reason should be caused by continuous in Number sequence (maybe it's a bug as others say)
    Did you try to manually delete '2319' with status free? (Alt+F9).
    Let it get to the next number.

    I hope it will help you.

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,641 on at
    RE: Duplicate number in number sequence

    Hi Mohammed,

    We have had issues with continuous number sequence in past (not D365 yet). Sometime numbers are skipped and strange is that issue can't be reproduced all the time. Only option is to correct them as needed.

  • Mea_ Profile Picture
    Mea_ 60,274 on at
    RE: Duplicate number in number sequence

    Then if you can repro it, just a log a bug.

  • M Anas Khan Profile Picture
    M Anas Khan 1,416 on at
    RE: Duplicate number in number sequence

    We are using standard application which means no mods. Customers are being created manually. Yes we have a regulatory requirement to use continuous number sequence so that no numbers get skipped.

  • Mea_ Profile Picture
    Mea_ 60,274 on at
    RE: Duplicate number in number sequence

    It's probably a bug, because allocated numbers should not be there, so if you have no mods in this area and did not import customers via data migrations\OData you can log a bug. However, why do you use continuous number seq at all ? It has bad performance and recommended to use only if you have legal requirements and I'm not aware of any in AU.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans