Dynamics Community Forum Thread Details

Solving stuck printing problem - Payroll Checks

One of our payroll clerks printed and posted payroll checks last week. The process was interrupted when the printer failed to print the reports. She was able to reprint the reports and the check amounts are showing posted correctly to the people's accounts but when attempting to remove a batch from the build a message opens stating "Checks are currently being printed. Please wait until printing has finished."

Anyone have any ideas on the proper way to address this?

Eric, because the process was interrupted, GP thinks the check batch is still processing. Here's what to do in SQL Management Studio to correct -

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.

Hope this helps,

Quick Links