Notifications
Announcements
No record found.
We can't print check, were getting "another user is printing computer checks for this checkbook id select a different checkbook id" error. Please help.
Thanks!
Marlon
*This post is locked for comments
Hi Marlon,
Have all users log out of GP and then run the following in SQL:
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
If this does not sort the issue - run SELECT * FROM SY00500 (against whateer company database you are working in).
Look for a batch related to check run - and then run:
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='???'
Try the above and see how you get on. As with anything else like this do a full company and Dynamics database backup first. Better still do the above in a test enviornment.
Ian.
I have the same problem and have tried all the suggestions above to no avail. Any other solution out there?
Are you certain you ran the following SQL Statement after you cleaned up the locks in GP.
Additionally, you have to change '???' to the actual batch number.
Finally, the SY00500 table is not in the Dynamics database, it is in the Company database.
Managed, the user had not given me the actual batch which was interrupted so my troubleshooting got narrowed when she provided that info and the batch was not there under print payable cheques rather it was in payables batch entry. Thanks
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
