Welcome to my knowledgebase, which contains snippets of information that I find (mostly about Microsoft Dynamics CRM) and then forget.

You are most welcome to browse and if any of the information helps you in your work with Microsoft Dynamics CRM then that is great.

Use the search box or the tag links to search for articles.

About Me

I’m an experienced Microsoft Dynamics CRM Consultant and Microsoft Certified Trainer. Find out more at

Recently updated articles

Hiding navigation items in a form

29 Oct 2012

The following javascript in a form may be used to hide left-hand navigation items. Note that is unsupported because it is not documented in the SDK.

In this example, the navigation item is for More Addresses - replaces navAddresses with the appropriate item.


To display the navigation item use:



Hiding Sections on Forms

29 Oct 2012

One method is to use the physical order in which a section appears on a tab (starting at number 0).

// This hides section number 1 on tab 0, i.e. the second section on the first tab

Changing country fields to picklists

29 Oct 2012

Changing country fields from free text to picklists is not a trivial undertaking. There are several considerations:
1. The existing country fields cannot be changed to be a picklist
2. The country field appears in several record types (account, contact, quote, order, invoice and addresses).
3. Addresses are mapped when creating records in the context of other records.
The options appear to be:

Customizing Marketing List Views

29 Oct 2012

The CRM application does not allow marketing list views to be customized. However, the views are stored in the savedquerybase table and may in fact be customized.

Firstly, we need to find the GUIDs for the relevant views. There are nine views in total, All, Active and Inactive members for Accounts, Contacts and Leads. Query the table (using SQL Server Management Studio) for these views using:

select * from savedquerybase where name like '%mem%'

Columns shown in duplicates detected view

29 Oct 2012

The columns shown in the Duplicates Detected windows are based on the Lookup view for the relevant entities.

For the new and potential duplicate records, the columns used in the duplicate detection rule that triggered the duplicate detection are also shown.

For the potential duplicate records, the record status and modified on columns are also shown.

The application does not provide a way to customize the additional columns that are shown.

Change name of the root business unit

29 Oct 2012

It is not possible to change the root business name for a CRM organization after installation using the application. But what if you have installed CRM with the wrong root business unit name or need to change it after installation?

There is a way round this if you follow these steps. But please make sure you read and understand completely what has to be done and also make sure you have sufficient backups in case things don't work out.

Multiple relationships between the same entities cause multiple lookups to be populated with the same value

29 Oct 2012

Imagine that you create multiple relationships between Accounts and Contacts. This will create several lookup attributes on the Contact entity which may be added to the Contact form.

When a new contact is created within an Account all the lookup attributes will be populated with the name of the Account. Often this is not desirable but according to this article,, this is by design.

Can Custom Activities synchronize with Outlook?

29 Oct 2012

Microsoft Dynamics CRM 2011 introduces custom activities. However, custom activities cannot be configured to synchronize with Outlook records.

Are duplicate security roles allowed?

29 Oct 2012

I recently discovered in CRM 2011 that it is possible to have security roles with the same name in a Business Unit.

For example, imagine a simple business unit scenario where the root business unit is called BU1 and there is one child business unit, BU2.

Create a security role in BU1 called Manager. The Manager role will also be available in BU2 as an inherited role. If you try to create a role called Manager in BU2, the application throws an error, Role Error - The role already exists.