Using Microsoft Dynamics CRM for Project Management

Visit Website View Our Posts

One of the best features of Microsoft Dynamics CRM 2011 is its ability to fulfill functions that were not designed out of the box, a concept known in the CRM community as “xRM”. One such potential function is project management. Maintaining some project-level information in CRM can be incredibly valuable, especially if you are already using CRM for service management with Cases. For any organization that engages in professional services delivery, keeping ongoing projects in CRM next to current customer service issues provides a better view of a given customer. Organizations that don’t perform projects for their customers can also benefit, as CRM could be used to track internal projects as well.

Since CRM doesn’t have any project management functionality out of the box, this means you can customize and tailor the functionality to suit your needs. At the most basic level, you will want to have an entity (record type) to track a project, and within this entity you can create the fields that apply to you – things like a description, an owner and/or a project manager, perhaps a time entry code, and some custom status values. At this base level, you can just update the fields as the project progresses, and set it as closed when it is done.

You can, however, extend beyond this. Create your project entity with activities, and you can set up specific tasks, assign them to other CRM users for completion, and track project-related emails from Outlook. You may also choose to use those activities to track time spent working on the project, which could either produce time reports or integrate with a time-tracking system. Use the built-in integration with SharePoint 2010, and you can use CRM/SharePoint as the document repository for project documents, signed proposals, requirements documents, etc. I have encountered a number of organizations where project information is known only by the project manager and anyone who is working on it regularly. Anybody else has to ask one of these people what the current status is, which copy of the requirements document on the shared drive is the most current, and other similar questions. When this information is located centrally through CRM, it becomes an easy place for anyone to go to and get a full picture, including the documents. If you enable versioning on the SharePoint library that CRM is integrated with, you can avoid the common “which document is the most recent” problem. Just save over the top of the same file in SharePoint, and let it handle the multiple versions. From the end user perspective, they only have to look for one document. From the PM perspective, if you need to review previous versions, they are all still there.

You can also extend your project process using the CRM workflow engine. Perhaps when a project gets started you wish to alert a salesperson, or an internal accounting person. Maybe when a project is marked as completed you wish to send a closing letter to the customer, or send a satisfaction survey. You can create workflows that are driven by changes in the status to automate these processes so you don’t need to remember to do it manually. You could also automate task creation. In a situation where a certain type of project always requires the same set of preparation steps, have a workflow create those tasks automatically and assign them to the PM or owner of the project.

I also like to extend the project management capabilities to include change orders and bug fixes. This gives you even more extended functionality by simply adding 2 relationships. A change order is just another project related to the first, so a circular relationship works there. Something like a bug or serious issue can be tracked with the built-in Cases, so linking a project to cases works very well for that.

As you can see, using CRM for project management can be a very powerful and useful tool. Keep in mind that if you require a true Enterprise Project Management (EPM) tool, CRM by itself may not suffice. Tracking and managing resources and utilization, stacking multiple projects by interconnected dependencies, and other higher-level functions would be more difficult to create in CRM and probably would not be as user-friendly as some EPM applications, but many of these applications will integrate with your CRM system, so you can still get some information visible to other staff.

You can learn more about project management in CRM by visiting our website or attending one of our CRM focused events.

By OTT, Inc., a Minnesota Microsoft Dynamics CRM Partner

2 thoughts on “Using Microsoft Dynamics CRM for Project Management”

  1. Hi Donna,

    You can use SQL server reporting services to pull the data and then make the appropriate column comparisons.

    Its also possible to export the data to excel and make the comparisons that way although it depends on some formatting details. We use the export to excel for some pivot tables we like to update each week and the "get data from CRM " button in excel works well for this.

    SSRS requires some know how but is very flexibile.

  2. We use CRM for all of our projects and I am the project coordinator. My management is asking me to run reports that show if tasks/projects are "on schedule", "at risk", or "missed due dates."

    I can pull the raw data from CRM but is there a reporting tool that will help me analyze and compare columns of data to each other.


    If a project has 5 tasks and 3 are on time but 2 have not started and the estimated end date is 2 days from now, then they want the project to show up on the report as "at risk."

    This is data analysis and I need some type of tool or software reporting product. Can you recommend a solution?

    Thank you.

Comments are closed.

Show Buttons
Hide Buttons