Great Plains 7.5 Error message

This is a Microsoft Great Plains 7.5 error message that I need to correct. Our company Controller is receiving the following error: Great Plains error - unable to save to batch activity table.You will not be able to use this batch.. How can I correct this error? I a m running Great Plains 7.5 on a Microsoft 2003 enterpriise server with SQL 2000 Server on the same box.
Who is Participating?
PioneermfgConnect With a Mentor Commented:
I think I have your solution.  This article gives you what you need to correct your batch locking issue:

In case you can't open the file, here are the steps:

A record may be locked in the SY00800 (Batch Activity) table.


Recreate the SY00800 table to free any locked records.

1. Make a backup of the database that can be restored in case a data loss occurs.

2. Using Query Analyzer, run the following delete statement against the Dynamics database.


3. You should now be able to post your batch.

This article was TechKnowledge Document ID: 31508

in what module are you getting this error?  e.g sales order processing, inventory etc...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.