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.
- 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 2: Delete the recordsTo 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 meYou 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 myselfYou 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:
Article ID: 866440 - Last Review: 12 Sep 2011 - Revision: 1