Batch activity table error message

Question Status

TazMan1 asked a question on 16 Jan 2008 12:50 PM


I have a question about an error message that a user received earlier. It comes up with a unable to save batch activity table error when trying to add to the report. I am very new to dynamics so I don't know if this is a simple fix or something more serious. Any help would be greatly appreciated. Thank you much 

craigde responded on 16 Jan 2008 1:51 PM

Hi TazMan1 - Which version of Dynamics GP are you seeing this error in?

mwiley responded on 27 Jan 2008 1:47 AM

This table is SY00800 (DYNAMICS database) - there is a record in that table that is locking the batch. You probably can delete the table and run checklinks to recreate the record. Make a backup first.

Leslie Vail responded on 27 Sep 2010 9:53 PM

In addition to mwiley's good advice, I also recommend making sure everyone exists the system before deleting a table. My personal preference would be to simply delete the errant record using SQL, then everyone could stay on-line and no utilities would be necessary.

Kind regards,


Daniel Moore responded on 13 Sep 2012 12:23 PM


It looks like mwiley and Leslie provided you with the resolution. Clearing the activity and batch tables is usually recommended per KB 850289:

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

I will set this post to closed today.

Best regards,

Dan Moore

Customer Online Technical Community


This posting is provided "AS IS" with no warranties, and confers no rights