Update to post

In my post dated 12/10/2008 titled "How to correct Microsoft Dynamics CRM 4.0 user record if Active Directory domain logon changes", I documented the procedure to correct the logon for a user in CRM.

Well, I came across kb article 930853 that discusses this in more detail. Hope it helps.

Add AutoNumber functionality to Microsoft CRM

We have had many clients request the automatic generation of unique identification numbers for various entities in Microsoft CRM. For example, automatically generating and entering an account number for the Account entity or an opportunity number for the Opportunity entity.

Depending on the convention used and the complexity (e.g., sequential number, date-based number, etc.), the solution typically involves one of the following options:

• Manual generation and entry (inefficient)


• Custom JScript (not appropriate for more complex requirements)


• Custom Callout/Plugin (requires .NET developer and may be too costly to develop and maintain)


• Free (and unsupported) solutions from ISVs (not necessarily appropriate for production deployments since they are unsupported)

Well, I finally have another option: a paid (and supported) solution from an ISV.

This solution is inexpensive and appropriate for a production deployment of Microsoft CRM.

AutoNumber from CRM Innovation is a perfect option for the vast majority of situations I've come across, with only a couple of complex situations requiring something more advanced.

The pricing is VERY reasonable. Note that all prices are absolute prices and not per-user prices.

Up to 49 users: $295
50 - 199 users: $495
200 -499 users: $695
500 - 999 users: $1,295
1000+ users: $1,995

Note that maintenance, support and upgrades are all included for the first year, and 20% annually thereafter.

Support is via email, although it can be escalated if necessary.

I tested AutoNumber in my CRM 4.0 VPC image on the opportunity entity and it worked beautifully. The documentation made installation and configuration very easy and quick.

Some of the customizable options are:

• Prefix


• Suffix


• Increment or decrement


• Starting values


• Lengths and leading zeroes

AutoNumber can be configured for both system and custom entities.

AutoNumber will work even when records are imported using the built-in import utility or third-party import tools such as Scribe Insight.

A particularly helpful feature is the Backfill utility that enables assigning unique numbers to existing records. Ideally, you would run this utility after implementing AutoNumber in a Microsoft CRM deployment that includes records that were created prior to implementing AutoNumber, but before you start creating new records.

It's obvious that AutoNumber was designed based on real user requirements. As a result, it provides real value.

If you have a need for automatically generating unique identifiers for Microsoft CRM 4.0, then I highly recommend that you check out AutoNumber. More information on features, FAQs, and screenshots and videos are on the website.

Let me know your experiences and thoughts if you try it out.

How to correct Microsoft Dynamics CRM 4.0 user record if Active Directory domain logon changes

Issue:
We had a client using Microsoft Dynamics CRM 4.0 who created a new user in Active Directory, and then created the user record in CRM.

They then realized that the user's last name was misspelled, including the domain logon, which was in the format of first name initial and last name.

They corrected the spelling in Active Directory. They then attempted to update the user record in CRM by updating the domain logon field. The updated information is pulled in from AD. However, when they attempt to save the record, they receive a dialog box with the following message:

"You are attempting to create a user with a domain logon that is already used by another user. Select another domain logon and try again."

Resolution:
The solution is to modify the CRM user record to use a domain logon that is NOT currently used for a CRM user. Once the record is saved, you can then modify it again to pull the correct domain logon from Active Directory.

Case Study: Using Scribe Insight to Integrate Microsoft CRM with 4 Other Systems

This summer I worked on an interesting and challenging Microsoft Dynamics CRM project for a large university. This project involved not only implementing Microsoft Dynamics CRM, but also integrating 4 other systems with CRM so that CRM became the central repository of student and alumni data, making it easy for users to find data and report from one system.

The kicker is that each of the 4 systems used a different database platform!

The key to making this project successful was the use of Scribe Insight, a tool from Scribe Software (http://www.scribesoftware.com/) used to migrate data into just about any system, and integrate systems. Thanks to the power of Scribe Insight, we were able to integrate all systems with Dynamics CRM.

Here's the rundown of the applications we integrated with Microsoft CRM:

Application: Web-based career center management application
Source Data Format: Text files created by exporting data from the source system
Integration Type: Periodic batch load to CRM

Application: Campus calendar application with events that students register for
Source Data Format: mySQL database
Integration Type: Ongoing two-way real-time integration with CRM

Application: Student information system
Source Data Format: Sybase database
Integration Type: Initial batch load and ongoing one-way real-time integration to CRM

Application: Alumni information system
Source Data Format: Oracle database
Integration Type: Initial batch load and ongoing one-way real-time integration to CRM

Conclusion:
If you ever need to do ANY kind of systems integration work regardless of whether a Dynamics product is involved or not, then I recommend you check out Scribe Insight.

New feed service for the blog

If you have been receiving e-mails whenever new blog posts are created, then please note that we have decided to replace our current Feedburner service with Feedblitz.

If you wish to continue receiving notifications of the newest posts via e-mail, Skype, Twitter, etc., then please sign up again by entering your e-mail address on the subscription form on the home page of the blog and follow the instructions.

Thanks for reading our blog!

Product Downloads for Microsoft Dynamics CRM 4.0 on the Resource Center

Tired of searching for Microsoft Dynamics CRM downloads on the Microsoft web site? Talk about navigating a web in a maze in the dark!

Next time you need to download something related to CRM try the Resource Center first. In the Product Downloads section you will find almost everything you need in one place.

http://rc.crm.dynamics.com/rc/regcont/en_us/op/articles/downloads.aspx

Resource Center:

Product Downloads:

Options for creating a test environment for Microsoft Dynamics CRM 4.0

Do you have a need for a test or development environment for Microsoft Dynamics CRM 4.0?

If you have the Enterprise Edition, then you can take advantage of the multi-tenancy feature to create multiple databases without having to purchase additional Client Access Licenses (CALs).

For example, the URL for your production system might be http://crm.acme.com, while the URL for your test system could be http://crmtest.acme.com and the URL for your development system could be http://crmdev.acme.com.

There would be three different CRM databases, but they could all be stored on the same database server and use the same Active Directory organization.

The disadvantage is the additional cost of the CRM Server license (about 3 times the cost of the Server license for the Professional Edition).

If you have the Professional Edition, then your primary option is to take advantage of the software provided in the MSDN Premium subscription. Note that it's MSDN Premium and NOT MSDN Professional.

This can be confusing because there are a number of different subscription options depending on the version of Visual Studio and MSDN subscription that you purchase. However, the key is to purchase the MSDN PREMIUM subscription.

Compare the various options here.

The most common option is to purchase Visual Studio 2008 Professional with MSDN Premium. Check out all the software you get!



Just remember that all software obtained from the MSDN subscription is for NON-PRODUCTION use only! Learn more at the Frequently Asked Questions page.

Navint’s 2008 NY Dynamics Client Summit at Casa Larga on October 29

Do you like wine? Do you use any of the Microsoft Dynamics or Business Intelligence products, such as Dynamics CRM, Dynamics GP, or Microsoft Office SharePoint Server 2007?

If so, then you're in luck!

You have the once-in-a-year opportunity to attend the annual New York Dynamics Client Summit at Casa Larga Vineyards in Fairport, NY on Wednesday, October 29.

This will be a fun, information-packed event, so I encourage you to attend.

Learn more and register here.

I hope to see you there!

Microsoft CRM 3.0 - Update Rollup 3

In case you haven't heard, Microsoft has released Update Rollup 3 for Microsoft Dynamics CRM 3.0. This update rollup contains all of the fixes that were covered in the earlier Update Rollups (1 and 2) as well as additional fixes.

For more information about Update Rollup 3 click here.

To download Update Rollup 3 click here.

As always, when considering applying an Update Rollup please take care in understanding the associated warnings, prerequisites and recommendations made by Microsoft and Navint.

If you have questions about Update Rollup 3 please contact us.

Convergence 2008 Fun - Simulated Sky Diving

Navint's Director of Marketing, Amy Spencer (who totally kicks butt), put together an amazing Convergence Agenda this year including a few hours of simulated sky diving at a place called SkyVentures right down the street from all the happenings at Convergence.

Here is a picture from the event...

Notes From Convergence 2008

For those of you at Convergence this week - whether or not you've attended any Microsoft CRM specific sessions - you've heard all the buzz about Microsoft CRM anyway.

Not surprising, especially considering the recent launch of Microsoft Dynamics CRM 4.0 and the soon to be released Microsoft CRM Live (a SaaS version of the same product).

For the Microsoft Dynamics CRM related sessions that I've been able to attend, the repeating themes include:

- Prebuilt in-application dashboards (not SharePoint dependant)
- Improved integration with other line of business Dynamics applications (GP, SL, AX, NAV, SharePoint)
- Enhanced customization tools (i.e., do really cool stuff with even less need for coding)
- Even better Outlook client performance and stability
- And the best for last... interoperability with PerformancePoint (promise to blog about this in detail later!)

Stay tuned...

PS - Got a sneak peek at CRM 5.0 as well but can't really say anything about it since they asked us to sign NDAs.

Microsoft Dynamics CRM 4.0 Hotfix List

Although you've got to be a Microsoft Partner or Microsoft Customer to get access (via PartnerSource and CustomerSource respectively), thanks to this post by Microsoft's Ben Vollmer we now know where to go to get the most current listing of Microsoft CRM 4.0 related hotfixes.

Thanks Ben!

Microsoft CRM 4.0 Launch Event - In Your Home Town?

I know you've missed me so here's the top three on why it's been so long since my last post:

1) I decided to change my focus to an application even cooler Microsoft Dynamics CRM
2) My girlfriend hates it when I use weekends to write blog posts
3) Prospect and customer interest in the new version of Microsoft CRM is totally gangbusters

Well, let me clarify...

1) There actually is no application cooler than Microsoft Dynamics CRM (unless you are comparing version 4.0 to 3.0)
2) We never hang out near a computer so hating isn't even possible
3) It's truly like I said it: Prospect and customer interest in Microsoft CRM 4.0 is gangbusters

I'm serious... Navint has got something like 10 active Microsoft CRM projects going on since the beginning of 2008.

So if you have some time and you want to check out what all the new-CRM-version-commotion is about, come hang out with your favorite Navinteer at any of the following Microsoft Dynamics CRM Launch events:

March 5 - Rochester, NY**
March 18 - New York, NY
March 18 - Los Angeles, CA
March 19 - Hartford, CT**
March 20 - Boston, MA
March 20 - Huntington Beach, CA

Because the two are designed to work well teogether, the dates/locations marked above with a ** will have a Microsoft CRM 4.0 with SharePoint focus.

Let us know if you have any questions. Otherwise, see you there.

PS - The above list is not exhaustive. For a complete list of Microsoft CRM 4.0 Launch dates and locations, click here.

Migrating data from Salesforce.com to Microsoft CRM 4.0 using the Data Migration Manager

I just finished migrating data from Salesforce.com to Microsoft CRM 4.0 using the new Data Migration Manager (DMM) that works with CRM 4.0.

Overall, I was impressed with the DMM. It took some time to learn how it handled certain attributes (e.g., picklists, lookups, statuses, and users).

Pros:

• It's free.
• Does more than the Data Import Wizard available from within CRM.
• Can create custom entities and attributes for you, automatically!
• Can process multiple files at one time.
• Can establish relationships between records in different entities (e.g., set the parent account for a contact).
• Did I mention it's free?

Cons:

• Takes some time to learn how to use it correctly. If you haven't used it before, budget some time for this learning process (at least 2-4 hours).
• Works only with Text/CSV file formats.
• Can't handle files larger than 32 MB.
• Slow migrating from larger files (~10,000 records).
• More difficult to do more complex tasks such as transform data (e.g., use formulas). Rather than an easy-to-use interface such as one that Scribe Insight provides, you usually need to modify an XML file (uggh!).
• Even though there was a map for the Salesforce.com data, it did not handle everything. I ended up creating my own maps so I could become familiar with the data and have more control over the process.

Conclusion:
While I still recommend Scribe for more complex data migrations (and it's always more complex than you think), I believe the Data Migration Manager is a valid solution for many projects. Be sure to investigate the DMM as an option for your next data migration project.

Microsoft Dynamics CRM 4.0 is available! Download it here.

Want to get your hands on Microsoft CRM 4.0? Check out all the links below. E-mail us if you have questions or would like a demo.

Documentation (manuals, help files, and white papers):

1. Microsoft Dynamics CRM 4.0 Server Readme
2. Microsoft Dynamics CRM 4.0 Implementation Guide
3. Microsoft Dynamics CRM 4.0 E-mail Router Readme (On-Premise and Hosted Editions)
4. Microsoft Dynamics CRM 4.0 Data Migration Manager Readme
5. Microsoft Dynamics CRM 4.0 Internet Facing Deployment Scenarios
6. Microsoft Dynamics CRM 4.0: How to configure the on-premise E-mail Router in different deployment scenarios

Server Applications:

1. Microsoft CRM 4.0 Server
2. Microsoft Dynamics CRM 4.0 E-mail Router (On-Premise and Hosted Editions)

Client Applications:

1. Microsoft Dynamics CRM 4.0 for Microsoft Office Outlook (For On-Premise and Hosted Editions)
2. Microsoft Dynamics CRM 4.0 Data Migration Manager

Give Salesforce.com $10,000... For What Is Already Yours!

While commonly known that Saleforce.com charges its customers for their data - you will cry when you hear this...

This morning I was talking to one of Navint's new Microsoft CRM customers. They are in the process of terminating their relationship with Salesforce.com.

It turns out that their contract with Salesforce.com requires them to pay $10,000.00 for a full cut of their data. The only thing they can get for free is a flat file of Account and Contact data.

IMPORTANT NOTE: With the introduction of Microsoft's customer relationship management SaaS offering (CRM Live), when you decide to "switch" you're NOT going to get charged for data that is rightfully yours.

And for those of you...

1) Responsible for doing vendor comparisons - please add this to your list of items to consider when calculating TCO.

2) Responsible for negotiating contractual relationships with CRM vendors - make sure to draw attention to such clauses so that you don't have to end up paying for what is yours.

PS - Maybe this is why Marc Benioff is so defensive regarding CRM Live.

Microsoft CRM 4.0 Ships!

As reported by Micheal Lu and Ben Vollmer from Microsoft, it looks like Microsoft CRM 4.0 (Titan) has shipped!

Stay tuned for more details!

In the mean time, if you would like a preview of Microsoft CRM 4.0, please feel free to contact us.

We'll be happy to demo the new version for you!

New From c360 | BI Analytics for Microsoft Dynamics CRM

I sat in on a totally killer demo today of c360's new BI Analytics toolset. This is a really neat tool which provides the capability (via cubes) to create Dashboards and KPIs within 10-15 minutes. Seriously. The only thing you need to be running in addtion to the regular system requirements for Microsoft CRM is SQL Server Analysis Services (i.e., SQL 2005 SP 2). I've included a couple of screenshots below. More information can be found at c360's website.

Screenshot 1 - Creating A New Cube:

Screenshot 2 - A Finished Dashboard:

What are you waiting for?!? Check with Navint for pricing details.

Microsoft CRM 4.0 (Titan) Features Overview

Microsoft CRM 4.0 is almost here!

Yes, version 3.0 is great but Microsoft CRM 4.0 (code named Titan) rocks. Microsoft finally lifted the NDA restrictions on October 1st so we can finally share with you what we can all look forward to in version 4.0.

If you were lucky enough to attend any of Navint's client summits in New England or New York, then you already saw and heard a bunch of what follows. If not then here's the top ten Titan features list that Mike Cross, Kris Kratky and I put together for Navint's recent client summits.

Note: There's one more Navint client summit scheduled on October 25th in LA for our West Coast clients.

Anyway, here's the the Microsoft CRM 4.0 top ten list. Let us know if you have any questions or if you want to see a demo of the new version.

(Disclaimer: What you are about to see is subject to change prior to Microsoft CRM 4.0's release at the end of this year.)

Navint's /Microsoft CRM 4.0 Top Ten

1) User Interface and Office Integration

- Office 2007 UI
- All CRM Activity Types Integrated with Outlook (get pop-up reminders for phone calls, etc.)
- Background Synch (no more manual synching)
- Word Mail Merge (for the web client too)
- Export to Excel (now includes access to EVERY object schema in Microsoft CRM)
- OneNote Integration
- Presence Management (with integration to Live Communication Server)
- Dynamics (GP, SL, NAV, AX) Integration

2) Architecture

- Multi-Tenant Architecture (CRM Live, Cheaper intra-enterprise deployments)
- Support For Internet Facing Deployment (no VPN needed!)

3) Internationalization

- Multi-Language (user-defined language specific UI)
- Multi-Region
- Multi-Currency (exchange rates are stored within the database)

4) Data Analysis

- Improved Advanced Find (now includes access to EVERY object schema in Microsoft CRM)
- Export to Excel (ODBC live/dynamic link)

5) Workflow and Reporting

- Workflow Manager (web client, added triggers, all entities support stages, Win WF based)
- Report Scheduling Utility
- SRS Report Wizard (create an SRS report in 7 clicks!)

6) Data Integrity and Enhancements

- Data Enrichment (Export CRM data to excel > Update it > Import it to update CRM records)
- Configurable Duplicate Detection (includes cross-enterprise notifications)

7) Data Import and Migration

- Data Import Wizard (supports import of data into ANY entity)
- Asychronous Processing (improve the speed of importing data)

8) Entity Relationships

- Many to Many
- System to System
- Self Referential

(Do you have any idea what this means?! Woo-hoo is all I can say!)

9) Developer Treats

- Server Side SDK
- Offline SDK (improve online/offline consistency)
- Offline APIs (improve online/offline consistency)
- Plug-ins (replace call outs)

10) Resource Center

- New Menu Item
- Find and Share Best Practices
- Access Online Help
- Submit Support Requests (from within the application)

With over 100 new features in Microsoft CRM 4.0, this top ten list barely scratches the surface. Future posts will get into much greater detail. We promise.

Please email us or give us a call if you want to see a Microsoft CRM 4.0 demo.

Also, Microsoft has promised Navint that upgrades to 4.0 are going to be smooth and seamless. More on that subject in future posts. Stay tuned.

What is a Lead in Microsoft Dynamics CRM?

One of the most common issues that crops up during a Microsoft CRM implementation is the confusion around the definition and purpose of the Lead entity, and how it relates to other common terms such as Suspect, Prospect, and Sales Opportunity. Confusion is particularly common among users of ACT!, Goldmine, and other contact managers due to the way these applications are designed.

Let's clear up the confusion once and for all! In this article, I do the following:

• Define a Lead in Microsoft CRM
  
• Explain how Suspects and Prospects are tracked as Leads in Microsoft CRM
  
• Explain how a Lead is converted to a Sales Opportunity, as well as an Account and/or Contact

By the end of the article, you should be able to envision how to use Microsoft CRM to track your leads.

Definition of Lead in Microsoft CRM

A lead in Microsoft CRM is either a Suspect or a Prospect:

• Suspect - a person who might be interested in what you sell but who has not yet indicated any interest. An example might be a list of people purchased from a service such as InfoUSA or D&B, or a list of names compiled from a telephone book.


• Prospect - a person who has expressed interest in what you sell, but who has not yet met the criteria to be considered a Sales Opportunity. An example might be a person who registered to download a whitepaper or to attend a webinar, but whom you have not yet qualified.

That's it! That's all a Lead is in Microsoft CRM.

In Microsoft CRM, Leads are separate from Accounts and Contacts. The main benefit of this design is the ease of segregating people who are very early in the sales process from those who are further along. In some organizations, sales people don't work with Leads in Microsoft CRM. Instead, it is the marketing people who work with Leads, and then once the Lead is converted to an Opportunity, the sales folks take over.

Keeping Leads separate from Accounts, Contacts, and Opportunities also makes it easier to develop workflow rules, reports, and security access.

How Suspects and Prospects are tracked as Leads in Microsoft CRM

Suspects and Prospects are both tracked as Leads in Microsoft CRM. Since this is the case, and since there is no standard out-of-the-box way to classify a Lead as a Suspect or Prospect (which is very important!), each organization needs to determine how to classify a Lead.

The most common method is to add a custom picklist attribute (done very quickly and easily) with two options: Suspect and Prospect. Another option is to add a bit attribute formatted as two radio buttons, with one button for Suspect and the second button for Prospect. See the screenshot below illustrating both options (click on the image to see a larger version).

How a Lead is Converted to an Account, Contact, and Sales Opportunity

Okay, so your lead was first a Suspect, then became a Prospect, and you have now determined that this is Prospect meets the criteria to be considered a Sales Opportunity, with a defined product or service to purchase and estimated buying timeframe. So what do you do with this Lead?

You click a button and convert it to a Sales Opportunity (or just Opportunity in Microsoft CRM).




Here is the ensuing dialog box. Note that with one click of a button, you can create three different records (Account, Contact, Opportunity) copying data from the Lead.




Once the Lead has been converted, this is what it looks like. Note that the fields are greyed-out (signifying that they are read-only) and that the status of "Qualified" appears in the lower left corner of the form.




Conclusion

And that's how a Lead is tracked in Microsoft CRM! There is a lot more to Lead Management than what this article discusses (capturing leads from a website, automating the assignment of leads, implementing a lead nurturing program, lead qualification criteria, etc.), but I hope that this helps you understand how your organization could start to use Microsoft CRM to manage your leads.