How to Find which user is locking a table?
Orginal error message will came on Purchase Line table as follows
The operation could not complete because a record in the Purchase Line table was locked by another user. Please retry the activity.
This means that another user is also modifying data in the same table. Navision has locked the table for the user to modify so that no other users can modify the same data at the same time. Any other user who wants to modify the same data must wait until the user who locked the table to finish his/her changes first. Once the user has finish modifying the data, Navision will release the table lock for other users to use.
Find Locking User Details
- 1) Go to File–>Database–>Information.
- 2) Select the Sessions tab.
- 3) Drill down to the current sessions.
- 4) Check on the Blocking user id column to find out who is locking other people.
You overcome this issue by scheduling posting users different departments.
For example, Tell Purchase invoice team to post the transaction between 10 AM to 2 PM for one set of user. And other set of users to assign other time etc. Make sure 2 users will not post the same transaction at same moment.
You can also kill the session of other user to over comethis. For doing this select the user session and press delete button. Then on popup message select yes to kill the user session.
Strongly recommended, all to get over this by upgrade your ERP solution to latest versions.
If you are still having issue then do raise one comment over here. We are Happy to Help U.