You’re offline. This is a read only version of the page.
|
We have a batch that seems to be stuck. It is a purchasing batch.
When I go Batch Recovery, select the Batch and hit continue it says:
"Batch 0315 Failed to complete posting. Use the Batch Recovery window to complete the posting prcoess." Obviously that is the window I am in :) When I click "more info" I get: "[Microsoft][SQL Native Client][SQL Server]Invalid object name 'TPAI.dbo.ME123506'." that is an EFT for receivables table. Our original install had that module, we never configured or used it, and it was removed over a year ago. I tried re-adding it last night and still the same results. Any ideas? This is GP10 |
*This post is locked for comments
I would guess that Checklinks resolved the issue even though there were no error messages. Glad you got it fixed!
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?
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.
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.
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.
Actually, that table is an EFT for Payables table. Did you try to recover the batch?
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (