You cannot complete this process while transactions are being edited

When you attempt to reconcile Inventory Control in Microsoft Dynamics GP, you receive the following message.

You cannot complete this process while transactions are being edited.

Cause

You may have a user locked in a table even though all users are logged out.

Resolution


1. Have all users exit Microsoft Dynamics GP and execute the following query in the SQL Query Tool against the DYNAMICS database: 

delete SY00800

2. Execute the following queries against the Tempdb database: 

delete DEX_LOCK 

delete DEX_SESSION

3. Run this script 

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

APPLIES TO

• Microsoft Dynamics GP 2010
• Microsoft Dynamics GP 10.0
• Microsoft Dynamics GP 9.0, when used with:
• Inventory Control