Notifications
Announcements
No record found.
*This post is locked for comments
Actually, that table is an EFT for Payables table. Did you try to recover the batch?
This IS in the batch recovery window, is there another way to recover a batch? For example an automated solution or sql command?
The only table starting with ME for this company is ME27623 and it is empty
Check links found no issues last night.
Yes, I understand it's in the batch recovery window but did you try to recover it? If so, and it didn't recover, thry this -
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.
Thank you so much, I will try this after business hours tomorrow, after a backup of course! I will update the thread with the results.
The strangest thing just happened. My accounting user just had a new batch to recover, selected both for the heck of it and it worked correctly this time. I'm glad the issue is resolved, but absolutely confused on how it worked out. I ran check links on the financial and purchasing series last night, but it did not report any errors for either series. Any ideas?
I would guess that Checklinks resolved the issue even though there were no error messages. Glad you got it fixed!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
