Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Record in table G/L En...
Small and medium business | Business Central, N...
Suggested answer

Record in table G/L Entry locked

(0) ShareShare
ReportReport
Posted on by Ivan Escobar 10

Bussines Central is extremely slow. In addition, when I try to post a payment and reconcile a bank account I get the following message (we only have one session open):

We could not update the data right now. Please try again later. Technical details: A record in table G/L Entry was locked for use in another session. Administrators can see current locks on the Database Locks page or use telemetry. (Snapshot ID: e240eacd-1684-447c-bc1d-e174f26021d8)

BC-Issue.JPG

Is this a global issue? Can anyone help me with this?

Many thanks.

  • Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    RE: Record in table G/L Entry locked

    this is not an issue but BC is telling user to wait until the ongoing task finishes so user could post. usually user wait and try again to post.

    for more technical details, refer to the below post:

    https://yzhums.com/27263/

  • Pragya752 Profile Picture
    Pragya752 210 on at
    RE: Record in table G/L Entry locked

    Same thing is happening to me where I have a JOB queue running in Background which fetches data from Dynamics 365 CRM on job table but I dont know sometime when I am working on puchase order table it is giving errror that "we cannot save your data due to a record is modified in another table by another transaction"

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 on at
    RE: Record in table G/L Entry locked

    Other user doesn't literally translate to another user. It could be your own user, but on different session / background task. Or it could be a job queue (scheduler) or an API call from third party.

  • Ivan Escobar Profile Picture
    Ivan Escobar 10 on at
    RE: Record in table G/L Entry locked

    Hi,

    Thanks for your answer.

    The problem is that there is no other user using Business Central.

  • Suggested answer
    Akshay_Panchal Profile Picture
    Akshay_Panchal 402 on at
    RE: Record in table G/L Entry locked

    Hii

    This the global issue of locking the table. It is happening because of the other user process with same table. It will disappear when process will completed.

    Thanks.

    Verify, If this answer helpful to you.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans