110
We are in the middle of closing and ran our normal depreciation routine. Everything was going well. the assets were depreciated and the journal batch was created. When we went in to post the batch it hung and is stuck saying that it's printing but nothing has happened. It has not hit the GL and has not printed.
Has anyone had this happen and what did you do to fix it?
*This post is locked for comments
1. bchsttus = 5 is Market to Print. Batch posting does not finalize until the Posting Journal(s) are printed.
2. SY00800 is the Batch Activity Master. Any batch activity in any Company database will appear in this table.
3. If you delete the batch, you will have to manually enter the financial transaction.
Thanks for the reply.
I have a few questions.
1) When I looked at the table SYS00500 the mkdtopst was already set to 0 but bchsttus = 5. Just curious if you know what the difference is in marking it from a 5 to a 0.
2) Does the batch status need to be set = 0 in order for anything to show up in SY00800?
3) If I end up deleting the record, will we need to manually enter the entry into a new batch?
Thanks so much for your assistance.
Have you tried Batch Recovery? Tools>Routines>Batch Recovery. If that doesn't work, you'll need to run the following scripts to free up the batch. Make sure you backup your database prior to executing these scripts.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (