355
Hi, my AR department received a check, and they applied the cash to the customer's account. They said they posted the batch, however, I don't see it's posted. when I go back and opened the batch to post, the batch is showing as no transactions. When I pulled up the "Transaction by Customer" window, the payment is showing there, however, the status is showing as "WORK". It looks like the batch is hanged. Is there a way to fix this?
*This post is locked for comments
Please have a look on the below my blog.
Hope this helps!!!
I already looked in the Batch Recovery and not seeing anything in there. I don't have admin access and don't know how to use SQL Script. Usually when there is a stuck batch, we call our consultant for help. Can you point me to where I can learn how to use SQL Script and do I need admin rights to run the script?
Thank you very much, I appreciate your help.
I would first go into Batch Recovery and see if the batch is seating there as a stuck batch
If there is a stuck batch there are SQL statements that can update the information for you.
Do you have access to SQL Management Studio?
1. Run the following script against the company database. Replace XXX with the batch number or the name of the batch that you are trying to post.
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
Note The value of BACHNUMB is the same as the value of the Batch ID window in Great Plains.
2. View the contents of the SY00800 table that is located in the DYNAMICS database to determine the value of the DEX_ROW_ID field for the batch that you are trying to unmark. You can view the contents of this table by running the following script.
SELECT * FROM DYNAMICS..SY00800
Note If no results are returned, go to step 5.
3. Run the following delete script that is based on the results that you received in step 3. Replace XXX with the DEX_ROW_ID value of the batch that you are trying to unmark.
DELETE DYNAMICS..SY00800 where DEX_ROW_ID= 'XXX'
4. Verify the accuracy of the transactions.
5. Verify that you can edit and post the batches.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
