Wednesday, March 16, 2011

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

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!

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.

No comments:

Post a Comment