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 perform the Inventory year-end close in Microsoft Dynamics GP: "You cannot complete this process while invoices are being posted"

Error message when you perform the Inventory year-end close in Microsoft Dynamics GP: "You cannot complete this process while invoices are being posted"

View products that this article applies to.

Symptoms

When you perform the year-end close in Inventory Control in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you receive the following error message:


You cannot complete this process while invoices are being posted.

↑ Back to the top

Cause

This problem occurs if a record is locked in the DEX_LOCK table or in the DEX_SESSION table in the tempdb database, or in the ACTIVITY table, in the SY00800 table, or in the SY00801 table in the DYNAMICS database.

↑ Back to the top

Resolution

To resolve this problem, delete the locked records from the tables. To do this, follow these steps:
  1. Make sure that all users exit Microsoft Dynamics GP.

  2. Make a complete backup of the DYNAMICS database and of the company databases.
  3. Start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.



  4. Log on as the sa user.
  5. Click the tempdb database in the database list.
  6. Run the following statement.
    delete DEX_LOCK
    delete DEX_SESSION
  7. Click the DYNAMICS database in the database list.
  8. Run the following statement.

    delete ACTIVITY
    delete SY00800
    delete SY00801

↑ Back to the top

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

↑ Back to the top

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