Friday, May 11, 2012

MSCRM 2011: Mapping fields from Lead to Contact and Account Entities when Lead is Qualified and Converted.

A client recently asked “How can we map additional/custom fields from a Lead to a Contact or an Account when a Lead is converted?”

Leads in Microsoft Dynamics CRM represent potential customers that can be qualified or disqualified based on criteria set by your organization. After you work with a lead record and determine whether or not the potential customer fits your lead qualification criteria, you convert the lead. When you convert the lead, you specify whether or not the lead is qualified or disqualified.

When you qualify the lead, you can create one or more of the following record types: Account, Contact, or Opportunity.
Your business process should indicate which of the records to create. For example, if your organization sells to businesses, you will probably want to create both an account and a contact. If your organization sells to individual consumers, you might not want to create an account. Likewise, you might not always want to create an opportunity when you qualify a lead. You might determine that a lead fits your qualification criteria but that an immediate sales opportunity does not exist.

When you qualify a lead, you can select a check box to open the newly created records, which will open the new account, contact, or opportunity records created during the lead conversion process so that you can work with them right away, saving yourself a few clicks.
Microsoft Dynamics CRM will populate data fields in the account, contact, and opportunity records you create from a qualified lead, based on the mapped data fields. For example, the website and phone number fields are automatically mapped. If there are custom fields that are created on the Lead and Contact/Account/Opportunity, you can map these fields when the relationship between the Lead and those entities is created when the lead is converted. For example, suppose you keep track (via a picklist) on what service a lead is interested in and you would like to also have that information on the Account record. The custom picklist field for “preferred service” would need to be created on the Lead and the Account entities. Below are the detailed instructions for mapping that custom field from a Lead to an Account when a Lead is converted:

* Go to Settings on the Sitemap

* Click Customization

* Click Customize the System

* Click on Entities.

* Double-click on Lead.

* Click 1:N Relationships in the left navigation

* Double-Click on the row – contact_originating_lead with the Primary entity value showing Lead and the related entity value showing Contact.

* Click Mappings in the left navigation pane.

* Click New.

*Select the “Preferred Service” field in the Lead Source Entity Attributes list on the left and the corresponding “Preferred Service” field in the Account Target Entity Attributes list on the right.

*Click OK.

The mapping will now automatically be complete when a Lead is converted and an Account is created. The same process can be performed to map fields from the Lead to a Contact and Opportunity.


Christoph Berthoud said...

Talk about perfect timing with your post! I was struggling to find the answer and you gave it to me exactly in the conext I was applying it.


sathis2251987 said...

Thanks for great info

Sudan Roman said...

A really really really good post...thanks

Azeem said...


Anonymous said...

contact_originating_lead is to create mapping b/w for lead to contact right ? but you were explaining about lead to Account but have used that row instead

Anonymous said...

Thanks, that's helped me a lot.

Leslie Lim said...

Wow. Awesome article. Please do more articles like this in the future. Very informational and knowledgeable. I will expect more from you in the future. For now i will just bookmark your page and surely I'm gonna come back later to read more. Thank you to the writer!


Silvia Jacinto said...

Reading your article is such a privilege. It does inspire me, I hope that you can share more positive thoughts. Visit my site too. The link is posted below.

林磊 said...

2016-2-20 leilei
polo ralph lauren
juicy couture
uggs sale
michael kors outlet online
burberry outlet online
michael kors outlet
ray ban sunglasses
mulberry uk
michael kors handbags
michael kors outlet
ugg boots for sale
abercrombie and fitch
nike outlet store
air max
canada goose uk
longchamp outlet
louis vuitton outlet
cheap jordan shoes
burberry outlet
chi flat iron
pandora jewelry
michael kors
ugg outlet
louboutin shoes
gucci belt
coach factorty outlet online
michael kors handbag
canada goose uk
gucci outlet online
moncler jackets
air jordan femme
michael kors handbags
louis vuitton handbags
kate spade outlet
rolex replica watches
coach outlet
louis vuitton outlet
louis vuitton handbags
michael kors outlet
jordan 6s

sarah lee said...

I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.