"This transaction is being edited by another user" Error message when you select an existing purchase order in Purchase Order Processing in Microsoft Dynamics GP
This article provides a solution to an error that occurs when you select an existing purchase order in the Purchase Order Entry window.
Applies to: Microsoft Dynamics GP
Original KB number: 859601
Symptoms
When you select an existing purchase order in the Purchase Order Entry window, you receive the following error message:
This transaction is being edited by another user.
This problem occurs in Purchase Order Processing in Microsoft Dynamics GP.
Resolution
To resolve this problem, follow these steps:
Have all users exit Microsoft Dynamics GP.
Back up Microsoft Dynamics GP, and then back up all the Microsoft Dynamics GP databases.
Start SQL Query Analyzer, and then run the following command against the DYNAMICS database.
DELETE SY00800 DELETE SY00801 DELETE ACTIVITY
Start SQL Query Analyzer, and then run the following command against the tempdb database.
DELETE DEX_LOCK DELETE DEX_SESSION
Start Microsoft Dynamics GP, and then select the purchase order.