Dynamics GP Project Accounting Reports - Project Executive Dashboard

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 Executive Dashboard

Dynamics GP Module:

Project Accounting

Development Using:

SQL Scripts (Views)

Database Connection Type: OLE DB (ADO)

Crystal Report: Version 11

Details:

Project Analysis Executive Dash Board will represent Projects analysis by ranking top 5 projects by following categories

1-    TOP 5 Projects By % Of Completion

2-    TOP 5 Projects By Project Value

3-    TOP 5 Projects With Cost Over Budget

4-    TOP 5 Projects By Revenue Recognition

5-    TOP 5 Projects By Profit

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.