Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 759
  • Last Modified:

Microsoft Dynamics CRM - Opportunity Entity

I am soliciting for help with the Opportunity Entity form. One of the fields on the form is Rating and i have several options E.G Hot, warm, cold etc. What I want done is, every time the rating changes from one phase to the another, there should be date associated with it. That is each phase should have a date to show when and how long it was on that phase.

That is, if the opportunity was on cold  on, say, May 15, and then on May 20 the phase is changed to warm. I want to be able to catch that on my report to say that on May 15, the rating was on cold and on warm on May 20.

Thanks!
0
Lyn Udy
Asked:
Lyn Udy
  • 4
  • 3
  • 2
1 Solution
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
Hi,

You can create a child entity for Opportunity with Rating and Date fields.

Now a script need to be written so whenever Rating field is updated, a new record in child entity will be created with rating name and current date.
0
 
Lyn UdyDonor Database AdministratorAuthor Commented:
Hi, thanks for this possible solution. But I'm still very new in CRM and don't really know how to go about writing the script. How do I go about that please?
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
Hi,

You should be aware of C#, .net programming to achieve this. You will need to create a plugin with the help of Microsoft CRM 2011 SDK.

SDK: http://www.microsoft.com/en-in/download/details.aspx?id=24004
How to develop Plugin: http://crmconsultancy.wordpress.com/2010/10/25/plugins-in-crm-2011/#helloWorldPlugin
How to register Plugin: http://msdn.microsoft.com/en-us/library/hh237515.aspx
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
Lyn UdyDonor Database AdministratorAuthor Commented:
Ok, thanks. I have no knowledge of C# and .net programming. Plus, I use CRM 4.0 not 2011.

I might need to find a different route of solution if there's any.

Thank you for your help :)
0
 
Chinmay PatelEnterprise ArchitectCommented:
Hi lynanee,

If you requirement is not very complex like tracking each and every change i.e. say the Oppty goes to warm then cold then hot then warm and so on then you can simply create fields on Oppty entity itself and then update them using a workflow whenever the change happens.

and in your report you can calculate the difference between these dates and show how many days a particular Oppty was in a given phase.

Creating a workflow in CRM 4.0 is a simple task but if you need guidance with it just let me know.

Regards,
Chinmay.
0
 
Lyn UdyDonor Database AdministratorAuthor Commented:
Hi Chinmay,

Thanks for your help which looks like what I may have to implement. Yes, i just want a simple way of tracking and would very much appreciate if you can show me how to do it. I'm still very new in CRM.

What possible fields do I create on the Opp entity and yes, I need your help with the workflow.

Thanks so much!
0
 
Chinmay PatelEnterprise ArchitectCommented:
Hi lynanee,

Fields
 - All the 3 date fields as you want to track 3 status
Workflow
 - Go through this simple video and try it to change it to your requirements.
 http://www.youtube.com/watch?v=y-9KOhPVoO0

Regards,
Chinmay.
0
 
Lyn UdyDonor Database AdministratorAuthor Commented:
Hi Chinmay, does this mean I have to also create three different fields for the rating as well?
0
 
Chinmay PatelEnterprise ArchitectCommented:
No need if you just want to track 3 states. Name the fields per state for example warm_date and in reporting pick up the date based on the field's name.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now