You’re offline. This is a read only version of the page.
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
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.
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
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.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,232
Super User 2024 Season 2
#2
Martin Dráb
230,064
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (