Great Plains Solutions - This transaction is being edited by another user
When clicking Transactions>Purchasing>Purchase Order Entry and entering an existing PO number, the error "This transaction is being edited by another user" appears even if no one is actually editing the particular PO.
To fix this error , do the following:
- Make sure that no one is logged in to Great Plains.
- 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
User/s should now be able to open the particular PO number.
