Pricing Precision

Fields of type currency have a precision which determines the number of decimal places used in calculations and display. The settings for precision are described in the following table.

Precision Setting Number of Decimal Places
Currency Precision

Determined by the setting on the currency.

Status and Status Reason


Most record types in CRM can be deactivated by changing the status. Many records have two status values such as:

  • Active
  • Inactive

But some three status values, for example, Leads can be:

  • Open
  • Qualified
  • Disqualified

Custom entities have two status values of Active and Inactive.

Status Reason

Each status has one or more status reasons. The available status reasons varies with the record type. Looking at Leads, the status and status reason combinations are as shown in the table:

Bulk Delete Suspended Jobs

Bulk Delete is a useful tool for deleting large numbers of records as an alternative to using Advanced Find and then clicking delete (which can only remove up to 250 records at a time).

System Job records are a good candidate for using Bulk Delete because the number of records is always increasing. However, suspended system jobs (such as workflows that are waiting) cannot be deleted using Bulk Delete. At least that was the case until Update Rollup 12 or 13.

Cascade Delete Behaviour

Consider the following scenario.


A custom entity, Project has been added to a Dynamics CRM system.

There is a 1:n relationship between Account and Project. The relationship behaviour is set to Cascade All for Delete.

A user has Organization level rights on all privileges for Account and Project except that the privilege is set to None for Delete on Project. A project record, Project A, is parented by Account A.

Service Principal Names (SPN) for Dynamics CRM

When setting up Microsoft Dynamics CRM it is likely that you will have to configure Service Principal Names (SPN).

What is an SPN?

An SPN is a mapping that associates a service with the account responsible for the service and supports mutual Kerberos authentication.

I like the explanation provided by Brian Murphy-Booth. He describes an SPN as a name that identifies a program that deals with credentials.