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.