Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Batch activity table error message

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

 Hello,

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 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Batch activity table error message

    Hello!

    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

    vkbexternal.partners.extranet.microsoft.com/.../ViewContent.aspx

    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

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Batch activity table error message

    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,

    Leslie

  • Verified answer
    mwiley Profile Picture
    mwiley 170 on at
    Re: Batch activity table error message

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Batch activity table error message

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans