[ياسر حميد]

1- Make sure that you have a current backup of the company database. To create the backup in Microsoft Dynamics GP, follow these steps after all users log off from Microsoft Dynamics GP:
a. On the File menu, click Backup.
b. In the Company Name list, click the company that you want to back up.
c. In the Select the backup file box, click the yellow folder to open the location in which you want to put the backup file.



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- Verify the accuracy of the transactions.

6- Verify that you can edit and post the batches.