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:
- Make sure that no one is logged in to Great Plains
- Go to to your Microsoft SQL server
- Open a SQL Query editor such as SQL Server Query Analyzer.
- 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.