Thursday, August 18, 2011

Dynamics GP Project Accounting Error - The Project Is Being edited By another User


 One of our clients recently reported the following error while the user tries to open the Project Card.

 The Project Is Being edited By another User, please select another project/contract number"

 We checked all the users and no one was accessing this project. Then we found there are invalid entries under “PA Proj Contr Activity Master table”.

 Resolutions

Note: Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

To resolve this problem yourself, follow these steps:
  1. Have all users exit Microsoft Dynamics GP.
  2. Remove the invalid record from the PA000001 table. To do this, follow these steps:
    1. Back up the company database.
    2. Open one of the following query tools, depending on the version of Microsoft SQL Server that you are using:
      • SQL Query Analyzer
      • SQL Server Management Studio
      • Support Administrator Console
    3. Run the following statement against the company database.
Select * from PA000001
Note The PA000001 table works as an activity table. Therefore, if no user is in the system, you do not expect any records to exist in this table. If a record still exists in this table, the record is an invalid record.
    1. Run the following statement against the company database to remove the invalid record from the PA000001 table.
Delete PA000001
 
Alternatively, there is also an automated solution on partner source which can do the same for you.
Happy Consulting!

No comments:

Post a Comment