Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Bank Reconciliation...
Microsoft Dynamics GP (Archived)

Bank Reconciliation: User locked in chequebook - help

(0) ShareShare
ReportReport
Posted on by odyssey 55

Hi,

I work in a Northern Irish company that uses Microsoft Great Plains 8.0 and a few years ago we stopped using our support company as we so rarely required their services but were paying them a fortune. 

In the past we've got locked into batches, etc when the system has frozen and we were able to clear the activity but 2 days ago I was reconciling my bank and the system forze and when I log back in I'm getting this message in the chequebook window Chequebook "Operating Account" is already in use by user "me"  I am locked out of that chequebook and any chequebook maintenance as are the other GP users in my department.  Everyone has tried to clear the activity but none of the usual things work such as:

-Tools

-Routines

-Financial

-Bank Management

-Clear Activity

 Can anyone suggest a solution to get me out of this fix? 

Thanks in advance.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Bank Reconciliation: User locked in chequebook - help

    Hi Sandip, worked a treat.

    I kind of figured there had to be a user table somewhere for CBM, but couldn't find it. Now that I know...it was right there staring me in the face.

    Thanks again.

  • Sandip Chudha Profile Picture
    Sandip Chudha 175 on at
    Re: Re: Re: Re: Bank Reconciliation: User locked in chequebook - help

    Hi Ian,

    Just joined and looking at posts. The table you want is CBEU1020 this is the Cashbook Activity table run a Select on this table and delete the offending userid record locking the table, for some reason the "Clear Activity" doesn't always clear the table hence the message "another uers locking CB"

    Regards, Sandip

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Bank Reconciliation: User locked in chequebook - help

    Hi,

    Did you ever resolve this issue? I have the exact same issue with a UK customer and .... I can't resolve it.  Thought I would be able to. Would appreciate it if you could point me in the right direction...or perhaps your UK support company might be able to tell you how they sorted it?

     

    Best regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Bank Reconciliation: User locked in chequebook - help

    Hi, no problem. The offer still stands to log in and run the queries for you if you don't have any luck.

    I have a pretty good idea who your company is!   In fact, I believe I worked on your original implementation while I was working for another GP partner in Ireland. Since then I started a GP Partner company based in Ireland myself. My company provides support / implementation / development services etc. for Dynamics GP. If you are thinking about re-newing your support or enhancement, or indeed looking at a pay per call model, perhaps you might consider including us in your RFP. We support customers worldwide.

    Best regards,

  • odyssey Profile Picture
    odyssey 55 on at
    Re: Re: Bank Reconciliation: User locked in chequebook - help

    Hi Ian,

    Thanks for getting back to me.  Unfortunately we don't run SQL queries ourselves so that wouldn't be viable for us.  I have contacted our previous support company and they are willing to clear the problem for us and look at the option of paying per call rather than taking out a year long contract.  I have left this decision in the hands of our IT manager and I hope it will be resolved soon. 

    I really appreciate your advice and if we have no luck pursuing the support company I may contact you.

    Best regards.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Bank Reconciliation: User locked in chequebook - help

    Hi, in this case it is not a user that has been locked in the system (which clearing the activity file would resolve)...but a transaction posting routine has most likely been interrupted, and the transaction is damaged / corrupt.

    If you want to PM me, I am based in Ireland and can log into your system remotely and resolve this for you.

    If you don't want to do this, post again or PM me and I can send you some SQL queries you can try yourself. Are you comfortable using MSSQL queries etc? If you are doing this yourself, first create a test company and restore the live data into it. You can then attempt a solution in the test company...when it works, you can then replicate the solution in the live company.

    Best regards,

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans