Hi guys..
One of the most common error we come across when there is an interruption during posting a batch.Here's Microsoft's guidance to go around it..
Cheers.
After you try to post a batch in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, the batch is assigned one of the following statuses:
- Posting
- Receiving
- Busy
- Marked
- Locked
- Edited
"Batch is marked for posting by another user."
This problem occurs when you use Microsoft Dynamics GP together with Microsoft SQL Server.Follow these steps to fix this problem yourself:
- If you are using Microsoft SQL Server 2000, run the statement in Query Analyzer. To open Management Studio, click Start, point to Programs, point to Microsoft SQL Server 2000 and then click Query Analyzer. To run a script, click New Query.
- If you are using Microsoft SQL Server 2005, run the statement in Microsoft SQL Server Management Studio. To open Management Studio, click Start, point to Programs, point to Microsoft SQL Server 2005and then click SQL Server Management Studio. To run a script, click New Query.
- If you are using Microsoft SQL Server 2005 Express, run the statement in Microsoft SQL Server Management Studio Express. To open Management Studio Express, click Start, point to Programs, point to Microsoft SQL Server 2005 and then click SQL Server Management Studio Express. To run a script, click New Query.
- If you are using Microsoft SQL Server 2008 (and later versions of SQL), run the statement in Microsoft SQL Server Management Studio. To open Management Studio, click Start, point to Programs, point to Microsoft SQL Server 2008 (or the version you have) and then click SQL Server Management Studio. To run a script, click New Query
- Make sure that you have a current backup of the company database, and ask all users to exit Microsoft Dynamics GP. To create the backup in Microsoft Dynamics GP, follow the appropriate steps after all users log off from Microsoft Dynamics GP:
- On the File menu, click Backup.
- In the Company Name list, click the company that you want to back up.
- In the Select the backup file box, click the yellow folder to open the location in which you want to put the backup file.
Or- In the Object Explorer, Expand your databases so you see the database you want to back up.
- Right click the Database Name, go to Tasks, and select Backup.
- Click the add button and select the location and file name you wish to save your backup to.
- Click Ok to start the backup.
- 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
- 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
- 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'
- Verify the accuracy of the transactions.
- Verify that you can edit and post the batches.
No comments:
Post a Comment