Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Stuck in batch recovery
Microsoft Dynamics GP (Archived)

Stuck in batch recovery

(0) ShareShare
ReportReport
Posted on by Ed Glasser 105

In "Receivable Batches" I have a batch with a status "Journal Printing Interrupted".  When I select the batch I get a window that says I can't edit the batch, use the batch recovery window.

When I go to the batch recovery window it has the same status " "Journal Printing Interrupted".  When I select the batch and choose continue, it prints and keeps looping me in the error message to use the batch failed to complete printing, use the batch recovery window to complete the posting process.

Any idea how to fix this?

*This post is locked for comments

  • Samantha0114 Profile Picture
    Samantha0114 195 on at
    RE: Stuck in batch recovery

    Typically you would login to SQL studio to run the scripts.    It is good practice to run a backup of the databases before you run any SQL script in case something goes wrong.  

  • Kerry Travis Profile Picture
    Kerry Travis 645 on at
    RE: Stuck in batch recovery


    This may be a dumb question, but where do I go to enter those "delete" statements?

  • Ed Glasser Profile Picture
    Ed Glasser 105 on at
    RE: Stuck in batch recovery

    This was very helpful.  Thank you.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Stuck in batch recovery

    With all the users logged out of GP, run the following statements

    DELETE DYNAMICS..ACTIVITY 
    DELETE DYNAMICS..SY00800 
    DELETE DYNAMICS..SY00801 
    DELETE         TEMPDB..DEX_LOCK 
    DELETE         TEMPDB..DEX_SESSION

    UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 WHERE BACHNUMB='XXX'

    This will get your batch released, and can be accessed on the originating batch window. Before you post on the batch level, go to the transactions included within the batch and check if there is any improper distribution. Then, go and post the batch back.

    Does this happen with all the batches, or this one specifically ?

    If it happens with this one specifically, then you could try to delete the batch and include a new batch for the transactions, and try to post. Usually "Journal Printing Interrupted" status of the batch is caused by any "Posting Interruption" caused during the posting process, which will take the batch to the batch recovery window, in order to prevent any data to post incorrectly.

    Hope this helps

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans