You are currently offline, waiting for your internet to reconnect

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"

Symptoms
You may receive the following error message when you try to open the Sales Transaction Entry window in Sales Order Processing in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains:


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


Note To open the Sales Transaction Entry window, click Transactions, point to Sales, and then click Sales Transaction Entry.
Cause
This problem may occur when records are locked in the SY00500 table, in the SY00800 table, or in the SOP10100 table. Records have a batch number that is blank, or the User ID is listed as the batch number.
Resolution
To resolve this problem, follow these steps:
  1. Have all users exit Microsoft Dynamics GP.
  2. Make a backup of the company database.
  3. In SQL Query Analyzer, run the following delete statement on the SY00800 table against the DYNAMICS database.
    DELETE SY00800
  4. Look for the problem records in the SY00500 table by running both the following statements against the company database.

    Note In the following statements, xxx represents the user ID that contains the error.
    SELECT * from SY00500 where BACHNUMB = ''
    SELECT * from SY00500 where BACHNUMB = 'xxx'
  5. If you have records that are returned with a blank BACHNUMB field, use the following delete statement.
    DELETE SY00500 where BACHNUMB = ''
  6. If you have records that are returned with a User ID in the BACHNUMB field, use the following delete statement.

    Note In the following statement, xxx represents the user ID that contains the error.
    DELETE SY00500 where BACHNUMB ='xxx'
  7. Verify that you can select existing documents in the Sales Transaction Entry window. To open this window, click Transactions, point to Sales, and then click Sales Transaction Entry. If you want to delete an existing document, click Delete. If you want to void an existing document, click Void.
  8. If you continue to receive the error message, or if you cannot select the existing documents in the Sales Transaction Entry window, run the following scripts in SQL Query Analyzer against the company database to locate problem records in the SOP10100 table.

    Note In the following scripts, xxx represents the user ID that contains the error.
    SELECT BACHNUMB,* from SOP10100 where BACHNUMB = '' SELECT BACHNUMB,* from SOP10100 where BACHNUMB = '<xxx>'
    SELECT * FROM  SOP10200 where SOPNUMBE in (SELECT SOPNUMBE from SOP10100 where BACHNUMB = 'xxx')
    SELECT * FROM  SOP10200 where SOPNUMBE in (SELECT SOPNUMBE from SOP10100 where BACHNUMB = ' ') 
    SELECT * FROM SOP10102 where SOPNUMBE in (SELECT SOPNUMBE from SOP10100 where BACHNUMB = 'xxx') 
    SELECT * FROM SOP10102 where SOPNUMBE in (SELECT SOPNUMBE from SOP10100 where BACHNUMB = ' ')
  9. Note any records that are returned, and then run the following statement in SQL Query Analyzer to delete the problem records from the SOP10100 table.

    Notes
    • You must verify that the transactions are posted to the Inventory module and to the Receivables Management modules. If the transactions did not post to the Inventory module and to the Receivables Management module, you must reenter the transactions in the Sales Transaction Entry window after you run the delete statements.
    • In the following statements, xxx represents the user ID that contains the error.
    DELETE SOP10200 where SOPNUMBE in (SELECT SOPNUMBE from SOP10100 where BACHNUMB = 'xxx')
    DELETE SOP10200 where SOPNUMBE in (SELECT SOPNUMBE from SOP10100 where BACHNUMB = ' ') 
    DELETE SOP10102 where SOPNUMBE in (SELECT SOPNUMBE from SOP10100 where BACHNUMB = 'xxx') 
    DELETE SOP10102 where SOPNUMBE in (SELECT SOPNUMBE from SOP10100 where BACHNUMB = ' ')
    DELETE SOP10100 where BACHNUMB = '' DELETE SOP10100 where BACHNUMB = 'xxx'
  10. In Microsoft Dynamics GP, point to Maintenance on the Microsoft Dynamics GP menu, and then click Check Links.
  11. In the Series list, click Sales, and then run the check links procedure on the Sales Work table group.
  12. If the transactions did not post in the Receivables Management module and in the Inventory module, reenter the transactions in the Sales Transaction Entry window.
Properties

Article ID: 852623 - Last Review: 01/07/2013 16:04:00 - Revision: 10.0

Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010, Microsoft Dynamics GP 10.0, Microsoft Dynamics GP 9.0, Microsoft Business Solutions–Great Plains 8.0

  • kbmbsmigrate KB852623
Feedback