delete CB900034 where CHEKBKID = 'the cashbook id goes here'
Wednesday, September 12, 2012
Great Plains Error: User is busy doing a final reconcile
We had a user who's laptop kept crashing, and it would lock him out of GP. One of the errors were "User xxx is busy doing a final reconcile. Please post later" when trying to post CB batches
I found an amazing lack of info on the web re this error.
So, I delved into SQL, and queried each and every table for the cashbooks I could find (CB%). I eventually found a table "CB900034" that looked like it held the locks.
I deleted his record, and voila, it worked. Whether it is the right way to do it or not, I can't say, but the ends justify the means... the code I used was:
Labels:
busy,
chequebook,
final,
GP,
Great Plains,
later,
post,
Reconcile,
User
Subscribe to:
Posts (Atom)