Have you ever come across a situation where a contact leaves a company but joins another company that is also your client? What do you do with all the notes and emails you have captured from his previous employer? We recently came across a similar scenario where we were implementing Microsoft Dynamics CRM Online. The client mentioned that the employees (contacts) move frequently between companies. Their goal was to keep track of last three companies to which the an employee (contact) was associated along with their job title, position level and the date on which they changed companies.
On the surface, this tracking seems pretty straight forward at first glance via auditing. But, simple as it sounds, there are a lot more things to analyze about this scenario. In native Dynamics CRM, when the parent company (account) of a contact is changed, the child records (activities) will also move with it. For example when contact is changed from company A to company B, all the activities the contact performed at company A will move and roll up to the company B level. This roll up of activities, notes or contact’s child records is not an accurate representation of where this information was originally created from.
- When John Doe is created in the system with Company A as the company he works for, the plug-in triggers on save and creates row #1 in the custom entity. The record is then displayed in the sub grid with a lookup to the contact as a reference.
- Row #2 – This is where the real magic starts to happen. On 5/1/2015 John Doe moves to Company B as a Business Analyst. The changes are made in Dynamics CRM and the record is saved.
With this approach you can keep track of your contact’s history. Along with that this approach it also covers the scenario where a contact changes multiple positions within a company. Not only that but you can keep the activities and other child record with the correct contact as the newly cloned contact record will always starts fresh at the new organization or company.
If you have a similar situation where the out of the box Dynamics CRM functionality needs to extended, please contact our professionals for more information on our services at 855.437.7202 or [email protected] If you like these tips, consider subscribing to our Dynamics Community News publication.
By: Gaurav Chauhan – Virginia Microsoft Dynamics CRM partner