Your previous transaction-level posting session has not finished processing

Trying to open a document in SOP and you get told the following? Your previous transaction-level posting session has not finished processing. Please allow time for it to finish. Second most asked question in support…this occurs when posting routines were interrupted for some reason.

1. Back up your Dynamics and company databases.
2. Note down the GP user ID of the session that is getting the error message. Then get everyone out of GP.
3. Go to MSSQL and open a new query window. Run the following query: Delete dynamics..sy00800
4. Run the following queries against the Company database
5. SELECT * from SY00500 where BACHNUMB = ”
6. If this query returns any rows, then run: Delete SY00500 where bachnumb = ”
7. SELECT * from SY00500 where BACHNUMB = ‘???’ (where ??? is the USER ID of the person getting the problem in GP)
8. If this query returns rows, then run: Delete SY00500 where bachnumb = ‘???’