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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Locking Issue on Cust. Ledger Entry Table

(0) ShareShare
ReportReport
Posted on by 1,638

Hi Experts,

There had been a situation with our clients, where constantly different users are facing this locking issue below -

which happens to occur while posting any credit memo, sales invoice.

image_5F00_2021_5F00_04_5F00_12T19_5F00_55_5F00_18_5F00_456Z.png

Any help would be appreciated,

Thanks.

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Tanya,

    in general locking of tables is needed because at one time only one person can write the transaction into table. This is to prohibit junk data and wrong results.

    It seems multiple users are trying to access the "Detailed Cust. Ledg. Entry" table at same time.

    Try to Restart the NAV Server and it will resolved the locking issue.

    Note: Before Restart of Service please notify all the users to Logoff from NAVISION.

    If this issue occur frequently then try to find the pattern like at which event this issue is occurring, so that the issue can be resolved permanently.

    Hope this helps.

  • Suggested answer
    Community Member Profile Picture
    on at

    Tanya,

    I see you are on NAV 2013. The Locking issues within NAV were addressed and Microsoft rewrote the code in future releases. I would follow what Naveen wrote to restart the Server but I would highly recommend upgrading or evaluating the Postings the Users are completing and see if these posting can be completed in a Job Queue in overnight processing.

    Hope this helps.

    Thanks,

    Steve

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans