Error message when you try to use the Sales Transaction Entry window in Microsoft Dynamics GP: "Transaction Level Posting Has Not Completed"

Applies to: Microsoft Dynamics GP 2015Dynamics GP 2013Dynamics GP 2010

Symptoms


When you try to use the Sales Transaction Entry window in Microsoft Dynamics GP, you receive the following error message:  
Transaction Level Posting Has Not Completed.


Your previous transaction-level posting has not finished processing. Please allow time for it to finish.  If you believe it has failed, log out of Microsoft Dynamics GP and log back in to recover transactions.

This problem occurs for one specific user ID.

Cause


This problem may occur if an invalid record exists in the SY00500 table.

Resolution


To resolve this problem, follow these steps;
  1. Have the user that had the issue log out of Microsoft Dynamics GP. (Note the document number for the problem invoice.)
  2. Open a query window in SQL Server Management Studio using the appropriate step: 
    • If you are using Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
    • If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    • If you are using Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.
    • If you are using Microsoft SQL Server 2012, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2012, and then click SQL Server Management Studio.
  3. Execute the following statement against the company database and if you find a batch listed with the user's ID as the batch name, you can delete it.

    SELECT * from SY00500 whereBACHNUMB = 'xxx'
    ---where xxx is the USER’S ID that had the issue.

    Delete SY00500 where BACHNUMB = 'xxx'
  4. If the user is logged out of Microsoft Dynamics GP, then they should not have any records in the SY00800 or SY00801 temp tables. If they do, remove these locked records:

    Select * from DYNAMICS..SY00800 where USERID = 'xxx'
    Select * from DYNAMICS..SY00801 where USERID = 'xxx'

    Delete DYNAMICS..SY00800 where USERID = 'xxx'
    Delete DYNAMICS..SY00801 where USERID = 'xxx'

    ---where xxx is the USER’S ID that had the issue.
  5. Now have the user log back in to Microsoft Dynamics GP and review the transaction or rekey it, if needed.
If the problem persists, see Microsoft Knowledge Base article 852623. For more information about how to resolve this problem, click the following article number to view the article in the Microsoft Knowledge Base:

852623 Error message when you try to open the Sales Transaction Entry window in Sales Order Processing in Microsoft Dynamics GP: "Your previous transaction-level posting session has not finished processing"