Another user is editing this item–Dynamics GP error

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…

SELECT * FROM DYNAMICS..SY00801

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.