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

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: Table locked by another user ILE, G/L & many other tables

    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

  • Suggested answer
    Suresh Kulla Profile Picture
    47,688 on at
    RE: Table locked by another user ILE, G/L & many other tables

    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.

  • Community Member Profile Picture
    on at
    RE: Table locked by another user ILE, G/L & many other tables

    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
    Amol Salvi Profile Picture
    18,696 on at
    RE: Table locked by another user ILE, G/L & many other tables

    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

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans