Back to website Login
There was a problem loading the comments.

A batch is held in the Posting, Receiving, Busy, Marked, Locked, or Edited status in Microsoft Dynamics GP

Support Portal  »  DCIP  »  Viewing Article
  Print
  1. Make sure that you have a current backup of the company database, and ask all users to exit Microsoft Dynamics GP.
  2. View the contents of the following tables to verify that all users are logged off: DYNAMICS..ACTIVITY, DYNAMICS..SY00800, DYNAMICS..SY00801, TEMPDB..DEX_LOCK, and TEMPDB..DEX_SESSION. To do this, run the following script.

    ================================
    SELECT * FROM DYNAMICS..ACTIVITY
    SELECT * FROM DYNAMICS..SY00800
    SELECT * FROM DYNAMICS..SY00801
    SELECT * FROM TEMPDB..DEX_LOCK
    SELECT * FROM TEMPDB..DEX_SESSION
    =================================

    Note: When all users are logged off from Microsoft Dynamics GP, these tables will not have any records in them.

  3. If no results are returned, go to 'Step 4'. Otherwise, clear the stuck records by using any of the following appropriate scripts.

    ===========================
    DELETE DYNAMICS..ACTIVITY
    DELETE DYNAMICS..SY00800
    DELETE DYNAMICS..SY00801
    DELETE TEMPDB..DEX_LOCK
    DELETE TEMPDB..DEX_SESSION
    ===========================

  4. Run the following script against the company database. Replace XXX with the batch number or the name of the batch that you are trying to post or select in Microsoft Dynamics GP.

    ===========================================================
    UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
    ===========================================================

    Note: The value of BACHNUMB is the same as the value of the Batch ID window in Microsoft Dynamics GP.

  5. Have the user verify the accuracy of the transactions.
  6. Verify that the user can edit and post the batches.
Share via

Related Articles

Categories

Tags

© Cinergy Support