Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

"Item Ledger entry locked by another User" In Navision 2018

Posted on by 240

Hi All,

I am facing the issue "Item Ledger entry locked by another user" while posting Transfer Order. In Transfer Order, there are huge records in One Transfer Order with LOT Tracking Functionality and Dimension . for eg. In one Item transfer line, it has 5000 lot. When this process is executed by two users simultaneously when the Post button is pressed. Its causing table locking issue.

We are unable to resolve locking issue.

we have tried the following options :

1. Automatic cost Adjustment = Never

2. In NAV Development "Alter database" window in "Transaction log files" in that unrestricted growth is "Checked".\

3. In DB we have set parameters as MAXDOP = 6, Timeout =60 and cost threshold for parallelism = 15.

4. In Navision Created Department wise NAS Services.

5. no changes to Posting code of Transfer Order.

Any suggestions are welcome.

 

  • NeoMatrix Profile Picture
    NeoMatrix 240 on at
    RE: "Item Ledger entry locked by another User" In Navision 2018

    Thanks for the Reply.

    The Business process is that After Transfer Order execution the Production is generated while Production Order Posting with one user that time another user Post the Transfer order. during the same period which is holding the lock on the Item ledger table.  So in that Process, the Massage "Item Ledger entry lock by another user" is a display on Transfer Order user.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,640 on at
    RE: "Item Ledger entry locked by another User" In Navision 2018

    If you execute a process by two users at the same time which takes a little longer then you would receive the table lock. Why two users are executing the same process at the same time? I would recommend posting that order when you don't have many users probably before the start of the end or end of the day.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans