Great Plains 10 : This transaction is being edited by another user – error

While trying to process transaction in Microsoft Great Plains 10 Sp5, I am getting error message:

The Transaction is being edited by another user

Well, the trouble is that the transaction is not being edited by anyone it is just being stuck and to clear it and  get back in business you have to follow up these few steps:

  1. Make sure that no one is logged in to Great Plains
  2. Go to to your Microsoft SQL server
  3. Open a SQL Query editor such as SQL Server Query Analyzer.
  4. Run the following SQL commands:
use DYNAMICS
GO
DELETE SY00800
GO
DELETE tempdb..DEX_LOCK
GO
DELETE tempdb..DEX_SESSION
GO

Once you have completed the above, all users should now able to continue at work and access and process the transactions.