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.