Microsoft Dynamics CRM (Archived)

Unique lead ID

(0) Share

Report

Posted on by Community Member

Hi all,

Does the CRM automatically assign each lead a system generated unique ID?

If so, where can I find it?

Many thanks

David

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (4)

Suggested answer

PS 23,577 on at

Like (2)

Report

No unique ID is assigned by default from the system; you need to install a free unique id solution in CRM and configure it as per your requirement, its easy

Download the solution from here & read the steps to do:

www.planetxrm.com/microsoft-dynamics-crm-2013-2011-auto-id-generator

Other way is by creating a real time workflow; follow the below URL:

community.dynamics.com/.../auto-numbering-with-crm-workflows-real-time-vs-asynchronous.aspx

if my post has helped you, please mark it as verified

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

Mognoose,

Yes, it does. All of CRM entity record has the unique ID assigned by CRM.

community.dynamics.com/.../121490.aspx

In your case, the Lead entity, yes, it does as well. "leadid" is the field name.

You can find it through SQL,

select leadid from lead

but you are using CRM Online so you can get it once you export to excel (include and tick the re-importing data feature) or using odata query, power query connect to CRM.

community.dynamics.com/.../121490.aspx

But it is a system generated ID, 32 characters GUID with dashes. If you want to build new one you need to create yourself or re-use the read-made solution (free and paid), generate the Running Number

www.powerobjects.com/.../powerautonumber

advcrm2011autonumber.codeplex.com

Hope this helps you!

Thanks.

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (2)

Report

You can use Advanced auto number solution from codeplex to set uniqueue number to eash leads

advcrm2011autonumber.codeplex.com

Was this reply helpful? Yes No
Verified answer

Mahadeo Matre 17,021 on at

Like (1)

Report

If you are not using contracts, case, articles, Quotes, orders , invoice or campaigns.. then you use CRM auto numbering for one of your entity.

Suppose you are not using Contracts..

Then create workflow on lead entity creation as follows

When creating Contract record set only required fields to create contract..

Then copy the contract Id to Lead Id field.. here I am using Job Title attribute to show..

Then activate your workflow..

Create lead record..

You will lead Id will auto numbered..

You are using CRM auto number functionality.. so CRM is taking care of unique number.. you can easily configure your auto number with CRM.. by adding pre fix, ID length etc.

Note: Only thing you need to do is that you need to delete contract records created during this process by scheduling bulk delete operation..

This is easy way to generate auto number..

Hope this will work..

Was this reply helpful? Yes No
Verified answer

Mithilesh Kumar 10,047 on at

Like (0)

Report

Hi David,

Yes, Dynamics CRM automatically assigns a Unique ID which is also referred to as GUID (Global Unique Identifier) when a new record is created. The GUID is stored in a specific system field called <EntityNameID> like "leadid", "accounted", "incidentid".

All activity entities GUID is stored in "activityid".

The GUID is in the form of "8-4-4-4-12" set of characters.

eg: 541067bd-4db1-2208-e5b0-a601ead56d03

However, this is not a user friendly set of characters which can be used to identify records in Dynamics CRM, there you can specify a more user friendly Unique ID for your Leads (Like the one for Case Record - CAS-00002-B8K4H9).

You can create a Custom Field and then create a Real Time Workflow to update the field with your own unique id.

Here is one good article on achieving this

community.dynamics.com/.../auto-numbering-with-crm-workflows-real-time-vs-asynchronous.aspx

Hope that helps

Thanks

Please mark my post as verified if you found it helpful

Was this reply helpful? Yes No
Verified answer

PS 23,577 on at

Like (1)

Report

I would correct myself, yes there is something called GUID, but I can understand you are looking for something like LD-AU-0001, while GUID is a 32 characters string, for which you will have to do a lot of customization to get it on the form, moreover, it does not make sense to Auto-number a lead with 32 characters. And on top of that if you are using CRM online, it would be a lot of clarical work to get it via excel export & reimport.

My solution in the above post, will let you decide the pattern of auto-number/Lead ID you want to get on Leads form

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Aileen,

Can you please help me for retrieving leads from CRM..

I posted a question here -- community.dynamics.com/.../215055

am using this - jlattimer.blogspot.in/.../PHP

Thanks!

Was this reply helpful? Yes No