Great Plains - account locked

We are using GP 8 with a national accounts module from PA.  When we try to apply payment from a parent account we get an error message that reads:

XXXXX-XXX-XXX is being accessed by another user, please choose another Parent/CustomerID

even though no one else is using the account.  Has anyone seen this issue before?  Any idea how to free up the locked account?  

Thanks.
baytowelAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Abdulmalek_HamshoConnect With a Mentor Commented:
National Accounts is from AR. Try deleting the following tables:

SY00801 from Dynamics
Sy00800 from Dynamics
Dex_Locks from tempdb
0
 
mnation1Commented:
The first thing I would try is to reboot your SQL server that hosts the Dynamics DB.  Prior to that you could ask that everyone quit Dynamics and see if someone inadvertently had that account record locked.

-mitch
0
 
baytowelAuthor Commented:
We tried that to no avail.  The entire system was down for maintenance last weekend but the account did not release.  Could there be a table somewhere that lists which accounts are locked that needs to be cleared?
0
 
baytowelAuthor Commented:
Thanks!  SY00800 had the records we were looking for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.