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 / Small and medium business | Business Central, N... / How can I stop number ...
Small and medium business | Business Central, N...
Suggested answer

How can I stop number series from skipping numbers for master data

(0) ShareShare
ReportReport
Posted on by Ola Darwish 905

Hi 

how can I stop BC from skipping numbers due to users trying to create a number customer or vendor then deleting it

so for example vendor number series is V0001 to V9999 and incements by 1    

if last vendor number is V0003 and a user was trying to create a new vendor. If the user open the screen he will see V0004 then during entry user decided he \she is not going to proceed so he deleted that vendor. Then next number the user will get when he tries to create a vendor will be V0005....so V0004 will be skipped for no reason and will never be used and vendor list numbering sequence will look a bit odd

is there a way to prevent this from happening?
thanks

Ola

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 13,044 Moderator on at
    RE: How can I stop number series from skipping numbers for master data

    The only way that I can think of is to take the delete permission for that masters from users. They can create new customers and vendors, but never delete.

  • Bilal Haider Profile Picture
    Bilal Haider 232 on at
    RE: How can I stop number series from skipping numbers for master data

    Dear Raelhefn, you are absolutely right but for the financial transactions. If the setting(Not allow gaps) that you are pointing to is used for non transactional table's no series then user will not able to delete a record later.

    Thanks

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at
    RE: How can I stop number series from skipping numbers for master data

    By default, gaps are not allowed in number series because the exact history of financial transactions must be available for auditing, by law, and therefore must follow an unbroken sequence with no deleted numbers.

    If you want to allow gaps in certain number series, then first consult with your auditor or accounting manager to ensure that you adhere to the legal requirements in your country/region. For more information, see Gaps in Number Series.

    please refer to this doc for more information about how to setup number series docs.microsoft.com/.../ui-create-number-series

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 232 on at
    RE: How can I stop number series from skipping numbers for master data

    Hi Ola Darwish,

    You are right if a number from a number series is assigned to a record and then that record is deleted you will get next number because that number is already used. If you open No Series and see its related Line table you can understand that it stores the last number used in table and then assign next number for new record.

    If there is gap then on creating new record you can put number manually that has been skipped. This way your gaps will be filled but it is not easy way to remember the skipped numbers and also you have to allow manual numbers in no series.

    There is another solution but it will only work correctly if you know that there are no new records created after the skipped numbers. For example in your case you have deleted vendor with V0004 so next number will be V0005. If you open No series page and select No series that is attached and then open its Lines you can see that there the Last No used will be V0004. Change it to V0003 again and in this way you will get V0004 again automatically. But this only works if you are sure that some other user has not already created new vendor V0005 at the same time.

    Thanks

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... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans