Solved

Great Plains - account locked

Posted on 2011-03-01
4
772 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:baytowel
  • 2
4 Comments
 
LVL 3

Expert Comment

by:mnation1
ID: 35011845
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
 

Author Comment

by:baytowel
ID: 35012076
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
 
LVL 10

Accepted Solution

by:
Abdulmalek_Hamsho earned 500 total points
ID: 35012097
National Accounts is from AR. Try deleting the following tables:

SY00801 from Dynamics
Sy00800 from Dynamics
Dex_Locks from tempdb
0
 

Author Closing Comment

by:baytowel
ID: 35017386
Thanks!  SY00800 had the records we were looking for.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question