Error message when you try to select a document in the Sales Transaction Entry window in Microsoft Dynamics GP: "This document is being edited by another user"

Applies to: Dynamics GP 2010

Introduction


This article describes a problem that occurs when you try to select a document in the Sales Transaction Entry window. This article also provides possible causes of the problem and a resolution.

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

Symptoms


When you try to select a document in the Sales Transaction Entry window in Microsoft Dynamics GP, you receive the following error message:

This document is being edited by another user.

Cause


This problem can occur for many reasons. This includes but is not limited to the following causes:
  • One user is trying to access a document from the Sales Transaction Entry window while another user is editing the same document.
  • A posting was interrupted. The interruption caused records to be damaged or locked.

Step 1: Have all users exit Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains.


Step 2: Delete the records

To have us clear the stuck records 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

You must have all users exit out of Microsoft Dynamics GP before running the Fix it wizard. To clear the stuck records automatically, 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

You must have all users exit out of Microsoft Dynamics GP before running the SQL Scripts.
To clear stuck records yourself, run the following statements in a Micrsoft SQL Query tool: 
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION