Another user is editing this item–Dynamics GP error

Another User Is Editing This Item

You can’t delete an item because another user is editing this item message pops up. This is due to a lock in the SY_ResourceActivity table (DYNAMICS..SY00801).

Check the table for the item number in RSRCID field, you can list all the records locked in the system with following SQL statement…



To resolve, remove the rows that are for the item in question.

DELETE FROM DYNAMICS..SY00801 where rsrcid='{insert item number}'

You should of course check the user is not editing the item, in this support case, the user themselves could not delete the item due to a system crash during a previous edit.