Error message when you select an existing purchase order in Purchase Order Processing in Microsoft Dynamics GP: "This transaction is being edited by another user"

Applies to: Dynamics GP 2010

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 have us fix this problem for you, go to the "Fix it for me" section. To fix this problem yourself, go to the "Let me fix it myself" section.

Fix it for me

To fix this problem automatically, have all users exit Microsoft Dynamics GP, and then click the Fix this problem button or link. Click Run in the File Download dialog box, and then follow the steps in the Fix it wizard.

Note this wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

Note if you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

Let me fix it myself

To resolve this problem yourself, follow these steps:
  1. Have all users exit Microsoft Dynamics GP.
  2. Back up Microsoft Dynamics GP, and then back up all the Microsoft Dynamics GP databases.
  3. Start SQL Query Analyzer, and then run the following command against the DYNAMICS database.
    DELETE SY00800
    DELETE SY00801
    DELETE ACTIVITY
  4. Start SQL Query Analyzer, and then run the following command against the tempdb database.
    DELETE DEX_LOCK
    DELETE DEX_SESSION
  5. Start Microsoft Dynamics GP, and then select the purchase order.