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

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / how to restrict sales ...
Small and medium business | Business Central, N...
Answered

how to restrict sales order from being view/edit when it is open with some other user

(0) ShareShare
ReportReport
Posted on by TanzeelurRehman 75

Hi everyone,

We are having an issue in business central.

when a sales order is open with one user and another user comes somewhere and opens that as well and do some operation or post the sales order. The specific record locks for almost 8+ hours. The error displays is as below.

The operation could not complete because a record in the Sales Header table was locked by another user. Please retry the activity. 

So my question is when a record is open with someone is it possible to restrict other users to view or edit, unless the other user closes it.

Regards.

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Asif Shahzad Profile Picture
    Asif Shahzad 410 on at

    I think you need to set relevant permissions.

  • TanzeelurRehman Profile Picture
    TanzeelurRehman 75 on at

    Thank you for your reply, Can you share some materials or steps to achieve the desired functionality.

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,296 Super User 2026 Season 1 on at

    Not sure if it is possible to do that. Permission won't help you as well.

    You may need to figure out why the record lock is so long ( extension, etc. )

  • TanzeelurRehman Profile Picture
    TanzeelurRehman 75 on at

    I don't see anything in extension that can make the issue. This happens when a same SO is open with two users, When both are doing some operation on it, when one post or releases the SO then it locks down. One solution i got from searching is to kick off the sessions so that BC will release the locked record like here robertostefanettinavblog.com/.../ but i want a kind of solution where is can restrict a user while opening the record if it is open with someone else like it happens in SAP.

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,296 Super User 2026 Season 1 on at

    the locking mechanism is normal. what does not make sense is the long hours. it will release the lock after you finish posting.

    You may also want to review the business process and figure out why two users access the same order.

  • Verified answer
    divyeshchitte Profile Picture
    divyeshchitte 968 on at

    Hi

    Can you check if you have added any custom on Sales Order Page or Sales Header Table?

  • TanzeelurRehman Profile Picture
    TanzeelurRehman 75 on at

    Yes, the issue was some where in the custom code, that was locking some of the related tables, that's why it was locking the sales order.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,117 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,026 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans