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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 95

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.

  • Asif Shahzad Profile Picture
    410 on at

    I think you need to set relevant permissions.

  • TanzeelurRehman Profile Picture
    95 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
    14,306 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
    95 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
    14,306 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
    970 on at

    Hi

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

  • TanzeelurRehman Profile Picture
    95 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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 677 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 430 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 280 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans