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
Project Executive Dashboard
Dynamics GP Module:
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.
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.