Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Batch continues on its merry way after getting stuck

Posted on by 75,730

I fielded a call today with the usual batch stuck in posting issue. This was a PO receiving batch. The batch in the SY00500 table was marked to post with a BCHSTTUS of 5. I set both of these values to zero and logged in as 'sa' I could see and print the edit list for this batch. The user who originally tried to post the batch was locked so I had to use task manager to kill GP. As soon as he logged back into GP the batch posting process picked up from where it left off and completed successfully. This is not the first time I have seen this type of behavior. How is this possible? What caused the initial locking were records in the DYNAMICS..SY00800 table. It appears that deleting those two records pertaining to this user's activity were what was causing the locking.

Categories:
  • Suggested answer
    RE: Batch continues on its merry way after getting stuck

    Hi Richard,

    This appears to be more of a comment than a question.   Records can get stuck in the activity tables, and having the user log out and back in again is one of those 'troubleshooting tricks' to see if it helps.   If not, then you would have to clear out the activity tables with SQL scripts.   But yes, sometimes logging and logging back in again can refresh temp/activity tables for that user and the process picks up where it left off.  We always have you do this as in this KB article for when a payables check run batch gets stuck:

    support.microsoft.com/.../852064

    A status of 5 just means that it was in 'printing' status.

    Cheryl Waswick

    Microsoft Dynamics GP Support  

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans