Who’s editing this transaction?

Dynamics GP manages transactions locking by saving the “ID” of the transaction’s being edited in the SQL (SY00800, SQL00801 and DEX_LOCK in tempdb) to avoid any deadlocks in the database. However, when a user tries to open one of the locked transactions, it will be notified that the transaction is currently locked by another user: Michael D Johnson posted a solution for this. Now, you can download the free Record Lock Tracing add-on for Dynamics GP (Tested on v10 and GP2010) that will replace this generic message with a message that includes the specific user that has the record locked: Well done Michael! Regards, — Mohammad R

Read the original here:
Who’s editing this transaction?