Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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"

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"

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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

↑ Back to the top

Keywords: kbmsifixme, kbfixme, kbmbsmigrate, kbmbspartner, kbexpertiseinter, kbexpertisebeginner, kbtshoot, kb, kbfreshness2007, kbmbsgp10,, kberrmsg, kbprb

↑ Back to the top

Article Info
Article ID : 866440
Revision : 1
Created on : 1/7/2017
Published on : 9/12/2011
Exists online : False
Views : 196