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.

4. 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!

Dynamics GP Project Accounting Reports - Project Analysis Budget Vs Actual By Cost Categories

Dynamics GP Project Accounting Series is very detailed, but reporting always been a key to most of the client such as dashboards and project details. I have developed some reports on project accounting. Have a look at one of those

Report Name:

Project Analysis Budget VS Actual By Cost Categories

Dynamics GP Module:

Project Accounting

Development Using:

SQL Scripts (Views)

Database Connection Type: OLE DB (ADO)

Crystal Report: Version 11

Details:

Project Analysis report displays the budgeted amounts along with the actual amount for the project during the report date criteria. This will also show the variance in terms of amount between budget and actual. All amounts are represented by the project cost categories and report can be generated for one or more projects at the same time.

You can download your copy From HERE

The Zipped Package includes SQL Scripts and Crystal Report File.

Happy Reporting!

Disclaimer:

I tested this on limited data (Project with “Fixed Price” Type & “Cost-To-Cost” Accounting Method), if you find an issue or have a suggestion for improvement, please let me know and I will post the update here for everyone.

Dynamics GP Project Accounting Reports - Projects Summaries Budget Vs Actual

Dynamics GP Project Accounting Series is very detailed, but reporting always been a key to most of the clients. I have developed some reports on project accounting. Have a look

Report Name:

Projects Summaries Budget VS Actual

Dynamics GP Module:

Project Accounting

Development Using:

SQL Scripts (Views)

Database Connection Type: OLE DB (ADO)

Crystal Report: Version 11

Details:

Project Summaries Budget Vs Actual report displays the budgeted amounts along with the actual amount for the project & the report date range criteria. This will also show the variance in terms of amount between budget and actual.

You can download your copy From HERE

The Zipped Package includes SQL Scripts and Crystal Report File.

Happy Reporting!

Disclaimer:

I tested this on limited data (Project with “Fixed Price” Type & “Cost-To-Cost” Accounting Method), if you find an issue or have a suggestion for improvement, please let me know and I will post the update here for everyone.

Dynamics GP Project Accounting Reports - Project Summaries Sheet

Dynamics GP Project Accounting Series is very detailed, but reporting always been a key to most of the client such as dashboards and project summaries .I have developed some reports on project accounting. Have a look

Report Name:

Projects Summaries Sheet

Dynamics GP Module:

Project Accounting

Development Using:

SQL Scripts (Views)

Database Connection Type: OLE DB (ADO)

Crystal Report: Version 11

Details:

Project Summaries Sheet displays the budgeted amounts along with the actual amount for all projects during the report date criteria. This will also show the variance in terms of amount between budget and actual.

You can download your copy From HERE

The Zipped Package includes SQL Scripts and Crystal Report File.

Happy Reporting!

Disclaimer:

I tested this on limited data (Project with “Fixed Price” Type & “Cost-To-Cost” Accounting Method), if you find an issue or have a suggestion for improvement, please let me know and I will post the update here for everyone.

Dynamics GP Project Accounting Reports - Project Analysis % of Completion

Dynamics GP Project Accounting Series is very detailed, but reporting always been a key to most of the client such as dashboards and project summaries. I have developed some reports on project accounting. Have a look

Report Name:

Project Analysis % of Completion

Dynamics GP Module:

Project Accounting

Development Using:

SQL Scripts (Views)

Database Connection Type: OLE DB (ADO)

Crystal Report: Version 11

Details:

Project Analysis report displays the project statuses by their percentage of completion based on cost. This shows the status in terms of KPI (Meter Gauges), it has different definition colors which are also mentioned at the bottom of the report to represent the statuses.

You can download your copy From HERE

The Zipped Package includes SQL Scripts and Crystal Report File.

Happy Reporting!

Disclaimer:

I tested this on limited data (Project with “Fixed Price” Type & “Cost-To-Cost” Accounting Method), if you find an issue or have a suggestion for improvement, please let me know and I will post the update here for everyone.