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"

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.