web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Purchasing Batch Posting Interrupted

(0) ShareShare
ReportReport
Posted on by

Hi all,

We use GP 10.0. A user was posting a payables batch containing 4 invoices and somehow the process got interrupted. When going back to Purchasing > Batches, the batch was still there but it showed a status of "Posting Interrupted". We could not open up the batch or make any changes to it. It also did not show up under Batch Recovery.

I noticed that all 4 of the documents in the batch are still in PM1000. However, 3 of the 4 are also in PM2000. Those 3 show up as normal documents, however if we try applying a payment to them we get the following error message:

"You can’t choose this document because it is part of a recovered batch or is still in the process of posting."

I tried following the basic steps to reset the batch found here. We kicked everyone out, and set the batch status from 7 back to 0 in SY00500 as instructed. This caused a new error message when viewing the list of Purchasing Batches:

"Unhandled script exception: Index 0 of array 'VerifyBatchTotals' is out of range in script 'Batch_Lookup_Scrolling_Windows SCROLL_FILL'. Script terminated."

I found someone with this exact same problem on this forum here. Following the suggestion on that thread from the wonderful Leslie Vail, I tried deleting the batch from SY00500 entirely, and then running Check Links on the Payables Transaction Logical File to recreate it. Check Links returned no errors and it didn't recreate the deleted batch. So the good news is the "script exception" error is gone, and the batch is no longer stuck on my list showing "Posting Interrupted". The bad news is I still have entries in PM1000 and PM2000 from this now non-existent batch, and I'm not sure how to safely get rid of them.

Thanks in advance for any help!

Benjamin

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mariano Gomez Profile Picture
    26,225 on at
    RE: Purchasing Batch Posting Interrupted

    You will need to remove the transactions that made it successfully to the PM Transaction Open File (PM20000) from the PM Transaction Work File (PM10000), then you will need to check the PM Key Master File (PM00400) and ensure that the Document Status (DCSTATUS) column is set to 2 for the documents that are now in open - check the voucher number.

  • Community Member Profile Picture
    on at
    RE: Purchasing Batch Posting Interrupted

    Thanks Mariano, I'll try that. Looking in PM00400 I see that all 4 documents are in there. The 3 that made it to PM2000 have a current Document Status (DCSTATUS) of 2. The 1 that is only in PM1000 has a Document Status of -1. What should I do with that one? Should I delete it in PM1000? Should I change or delete it in PM00400?

    Thanks again

  • Mariano Gomez Profile Picture
    26,225 on at
    RE: Purchasing Batch Posting Interrupted

    Ben,

    Since that's a work document, I would suggest you delete and re-enter.

  • Community Member Profile Picture
    on at
    RE: Purchasing Batch Posting Interrupted

    This seems to have worked. For future readers, here's a summary of what I ultimately did:

    1) Kicked everyone out and took a backup of the database

    2) Deleted the batch entirely from SY00500.

    3) Deleted from PM1000 the three documents that had made it into PM2000 already.

    4) Confirmed that in PM00400 the DCSTATUS for those three documents was set to 2.

    5) Deleted the one document that was only in PM1000. I deleted it in both PM1000 and PM00400.

    After that, the messed up batch was gone, and we were able to void or apply the three open documents left sitting in PM2000.

    Thanks again for the help!

  • Mariano Gomez Profile Picture
    26,225 on at
    RE: Purchasing Batch Posting Interrupted

    Thanks for the update and glad it all worked out for you. I appreciate you marking the response as the answer to your question.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans