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 :
Microsoft Dynamics NAV (Archived)

Table locked by another user ILE, G/L & many other tables

(0) ShareShare
ReportReport
Posted on by 625

Dear All,

We are very much annoyed by this problem, on posting every time this messages shows. ten-ten times this messages shows then entry posted.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Amol Salvi Profile Picture
    18,698 on at

    Look at the following links

    https://community.dynamics.com/nav/f/34/t/145265

    https://dynamicsuser.net/nav/f/beginners/41289/lock-table-issues

    http://navisionworld.blogspot.com/2009/07/locking-in-microsoft-dynamics-nav.html

    As well as check any customization done as most of the time this problem occurs if any customization did and which was not properly programmed and handled

  • Community Member Profile Picture
    on at

    That's strange !! Usually it happens rarely when multiple users post at same time. Have you done any customization in the posting routines. If so, that is the area you have to first look into.

  • Suggested answer
    Suresh Kulla Profile Picture
    50,245 Super User 2025 Season 2 on at

    Do you have any customization in the posting process to create any journal entries ? or there any job queues/automation processing running to create any journal entries or to post ?

    Please do check for any third party integrations you have in the system.

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,096 on at

    It might depend on many factors. Might be the costing method you are using and users post to G/L together with items entries, and correction of cost also is performed during posting, and there are too many users. In this case, try running post to G/L as a separate batch job during the night.

    It might be also a reason of not optimal customizations, as other members mentioned.

    You can also refer to Jorg Stryk posts to learn more on avoiding blocks, e.g. dynamicsuser.net/.../solving-blocking-issues-practical-examples

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 > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans