Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / KB guide not helping -...
Microsoft Dynamics GP (Archived)

KB guide not helping -- Payable Batch status 'Posting Interrupted'

(0) ShareShare
ReportReport
Posted on by William Kow 3,795

We have a Payable Txn Batch with status = 'Posting Interrupted', caused by the power failure.

So, we tried to check SQL queries, but all showing empty record.

SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION

but I still insist to update the SY00500 and set the BCHSTTUS=7 to become 0, then I lookup for the Payable batch again it show error as below:

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

Please advice and many thanks in advance.

*This post is locked for comments

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: KB guide not helping -- Payable Batch status 'Posting Interrupted'

    I have deleted the record in SY00500 for the particular batch number, and then I run the checklink on Payable Txn Logical File, even though this process to do not recreate the batch, but the "Unhandled script exception" no longer prompting, whenever I lookup for a payable batch. And I have also delete a record in PM10000 for the particular batch number, as per Mohammad's comments -- PM10000 and PM20000 should not have record with the same voucher number (should not exist in both tables).

    I think both SY00500 & PM10000 should not have the record as PM20000 has So far I think it is fine now, because I do not have error Unhandled script exception, and I can see the voucher (the posted invoice received is now ready for "Apply Payable Document" transaction). I hope everything is fine now, and many thanks to  L Vail. 

     

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: KB guide not helping -- Payable Batch status 'Posting Interrupted'

    Did it do any good to delete the batch from the sy00500 and run check links to recreate it? Another thing you can do just to check it is to change the voucher number for the record in the PM10000 table. Also in the SY00500 record the existing balances the following columns and then set them as below:

    MKDTOPST - set to 0

    NUMOFTRX - set to a positive number

    BCHTOTAL - set to a positive number

    BCHSTTUS - set to 0

    ERRSTATE - set to 0

  • William Kow Profile Picture
    William Kow 3,795 on at
    KB guide not helping -- Payable Batch status 'Posting Interrupted'

    Thanks for your reply. However, nothing i can do for those tables (Activity, SY00800, SY00801, DEX_LOCK, DEX_SESSION) because there is nothing in there.

    As for the error when apply payable document, this is can consider like a different case, as per Mohammad's comments, I can find the same document and same voucher number is exist in both PM10000 and PM20000. I not sure whether is ok to delete the record in PM10000. see my queries for the 2 tables.

    Anyway, this will still not help for the batch with status = "Posting Interrupted" even if i update the SY00500 and set the BCHSTTUS=7 to become 0

    Please advise. Thank you so much.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: KB guide not helping -- Payable Batch status 'Posting Interrupted'

    Hi William,

    You have done well in trying the usual suspects - and letting us know you did!

    Next thing I might suggest is that you delete that batch ID from the SY00500 table and then run Check Links on the Payables Transaction Logical File. This should recreate the batch and make it open for edit.

    How far through the posting process did the batch progress?

    Let us know how it turns out after reading Mohammad's comments.

    Kind regards,

    Leslie

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: KB guide not helping -- Payable Batch status 'Posting Interrupted'

    Besides that I also encounter below error when Apply Payable Document :

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

     So, then I currently reading the below link, to see if the suggest solution can help.

    https://community.dynamics.com/blogs/gpmohammad/comments/38288.aspx

     

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