You’re offline. This is a read only version of the page.
320
I am using a remote desktop connection for our client and was doing a batch post in series post in the Sales tab for a credit memo. I selected to view the posting reports on screen and send them to print. When the batch started posting, I received a message that there was a printer error encountered and then another error that the printer could not be found, but the posting continued rather than stopping or showing as a batch error to be recovered. I called our client to make sure their printer was working properly and they confirmed that it is, but they did not receive any posting reports or see any attempts for something to come through the printer from us.
I tried to repost the batch but I get the message that the batch is in the posting process and cannot be changed. I need to complete the post or stop the post and post it again and then apply the credit memo to their customer's AR. How do I stop a post? Or how do I move this batch through to completion of posting? It is a single-use batch with only the credit memo in the batch.
Any ideas would be greatly appreciated.
*This post is locked for comments
Hi Frank,
I have the same problem but in PM batch, the situation is I post a batch but It had errors(the batch still open) so from 17 transactions only 16 gone to GL (I checked GL20000) i tried to delete the 16 transaction from the batch(in GP) but it says it can not be deleted because it was posted, then I search the transaction in PM00100, PM20000, PM10100, PM10000, PM10500 Tables and there are the 17 transactions, I just want to be sure if I can delete the 16 transactions(from those tables) posted in GL and then post the only was with errors,
I'll apreciate your help, thanks!!
Nancy, you need to clear the batch from a couple of tables to free it up:
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.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (