Tuesday, March 15, 2011

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

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