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.

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

Details:

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!

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.

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.

Dynamics AX 2012 Living Document - Getting Ready For Dynamics AX 2012

Dynamics AX is near to launch in Q3 CY 2011, checkout its living document with resources (below) are available and planned to help you get ready for Microsoft Dynamics AX 2012.

·         Application Platform Training

·         Microsoft Dynamics AX 2012 Documentation Plans

·         Partner Technical Services: Product Release Training

·         Microsoft Learning: Microsoft Dynamics AX 2012 Official Courses

·         Microsoft Dynamics AX 2012 Certification Exams

·         Solution Implementation Workshops

·         Microsoft Dynamics AX 2012 Sales Training

·         Microsoft Dynamics AX 2012 Industry Sales Assessments

Check out the complete details on partner source HERE.

Management Reporter For Dynamics GP 2010- Release Download

Management Reporter for Dynamics GP 2010 has been released and is available to download.  You can get it from the following links

Data Provider For Dynamics GP 2010
Management Reporter For Dynamics GP 2010

For further details on Management Reporter view this site HERE.  It includes the roadmap, fact sheets.

Managing Microsoft Dynamics Implementations Certification Exam MB5-858

Managing Microsoft Dynamics Implementations Exam MB5-858 for Sure Step 2010, MB5-858 is available on Prometric. 

This certification exam measures your ability to understand Microsoft Dynamics Sure Step as a structured engagement methodology for Dynamics implementations. This exam measures the working knowledge that the candidate has of Microsoft Dynamics Sure Step.

As per SPA published at Microsoft (https://partner.microsoft.com/global/productssolutions/dynamics/solsprovideragreement)

·          

Partners must employ or contract with at least one individual who passes the Microsoft Dynamics methodology implementation exam, Managing Microsoft Dynamics Implementations MB5-858, to be authorized for any Microsoft Dynamics solution. This exam is available from April 15, 2010.

Till now what I know is the exam will have 40-70 questions with the time of 140-160 minutes. The basic skill set weight for the exam is as follows

Prepare to Manage a Microsoft Dynamics Implementation with Microsoft Dynamics Sure Step (47.14%)

• Identify key goals and pre/post activities associated with Microsoft Dynamics Sure Step decision accelerators and the Diagnostic phase. 
• Given a scenario, identify the appropriate Microsoft Dynamics Sure Step project type and the related key activities.
• Identify Microsoft Dynamics Sure Step cross phase processes and the key activities and deliverables associated with each cross phase.
• Given a scenario, identify the appropriate Microsoft Dynamics Sure Step documentation.
• Identify Microsoft Dynamics Sure Step optimization offerings.
• Project Management Library.

Manage a Microsoft Dynamics Implementation with Microsoft Sure Step (41.43%)

• Given a scenario, identify and complete the appropriate Microsoft Dynamics Sure Step documentation.
• Complete the Microsoft Dynamics Sure Step Analysis phase.
• Create a Microsoft Dynamics Sure Step project.
• Gather and document customer business requirements by using the Microsoft Dynamics Sure Step FRD.
• Given a scenario, identify how to use Design documents in the Microsoft Dynamics Sure Step Design phase.
• Identify and complete key test activities in a Microsoft Dynamics Sure Step Development phase.
• Identify key activities of the Microsoft Dynamics Sure Step Deployment phase.
• Manage change, risks, and issues by using Microsoft Dynamics Sure Step tools and templates.
• Conduct a Microsoft Dynamics Sure Step Tollgate Review.
• Create a Microsoft Dynamics Sure Step Go-Live Cutover Plan.
• Project Management Library.

Manage Post Implementation Activities with Microsoft Dynamics Sure Step (11.43%)

• Given a scenario, identify appropriate Microsoft Dynamics Sure Step Quality Management activities.
• Given a scenario, recommend appropriate Microsoft Dynamics Sure Step Post Go-Live Support activities.
• Given a scenario, recommend appropriate Microsoft Dynamics Sure Step Performance Tuning and Optimization activities.
• Identify the key tasks associated with closing out a Microsoft Dynamics Sure Step project.

You can check the detailed exam preparation guide on MBS here

Good luck.

Product Release - Microsoft Dynamics GP 2010

An exciting news that the newest version Microsoft Dynamics GP platform–Microsoft Dynamics GP 2010 is available for download. 

Dynamics GP 2010 will focus on increasing depth and reach for core functionality, enriching integrations with the Microsoft Office system, extending external connections through Web Services, and ensuring faster Return on Investment (ROI) for customers.

You can download it from one of the below links

-      Customer Source

-      Partner Source

If you are planning to upgrade please note that the upgrade paths for Microsoft Dynamics GP 2010 are as follows:

-  Version 10 :   10.00.1368 (Service Pack 4) or later >> Microsoft Dynamics GP 2010
-  Version 9  :    9.00.0371 (KB971017) or later >> Microsoft Dynamics GP 2010