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 / Business Central forum / Does Business Central ...
Business Central forum

Does Business Central have record locking?

(0) ShareShare
ReportReport
Posted on by Community Member

Good morning all,

We're currently exploring the suite of Dynamics 365 offerings for our own business as well as being able to advise our clients.  Business Central is of particular interest, but someone has suggested that it doesn't have any record-locking controls (i.e. multiple people can try to edit records at the same time with resulting conflict errors for any organisation bigger than about 100 seats).

Is anyone able to confirm or correct this information please so we have a clear picture of whether it's likely to be a problem.

Many thanks, Oz

Categories:
Other
Business Central
  • Community Member Profile Picture
    Community Member on at
    RE: Does Business Central have record locking?

    Thanks Hannes, that's really helpful.

  • Verified answer
    Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Does Business Central have record locking?

    Hi,

    Business Central does utilize the record locking of the MS SQL server.
    I think, because both products are from the same company, the dev team in Copenhagen decided to make use of functionality that's already available instead of inventing the wheel again.

    In regards on the impact on performance. Yes, that's an issue that has often been reported. It depends always how many people do work in the same areas of Business Central. 100 people across all modules is OK, but 100 people entering Sales Orders only is to much. It's also a problem of bad programming when you have customizations in a database.

    But Microsoft is aware of this problem and invested time to find a solution which Microsoft published with the major April release this year. So, everything you did hear was some kind of true, but might be resolved.

    It also important to consider this as a general problem of business software that utilizes a MS SQL server. The legacy system of my current customer (it's not NAV or business central) does cause a problem once a month: When the finance department runs some reports, the warehouse can't operate.

  • Community Member Profile Picture
    Community Member on at
    RE: Does Business Central have record locking?

    Thanks for the prompt response Hannes, that's great.  Is there any detrimental (or beneficial) impact of the locking being done by the SQL server as opposed to other methods please?  I see that several larger organisations are complaining of regular error messages about locking and having to wait to be able to do updates.

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Does Business Central have record locking?

    Hi,

    Business Central does provide record locking based on the SQL Server.

    That means, the SQL Server does manage the record locking.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard > Business Central forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans