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.
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.
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
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: