Knowledgebase

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 http://www.fkcrm.co.uk

Recently updated articles

SQL Joins


03 Mar 2017

Note: The word Outer is optional

Join Type Description Example Code
Inner Join

Rows that are in both tables (by id)

select * from tblA

inner join tblB

Dynamics CRM Add-Ons


20 Feb 2017

There are many add-ons available for Microsoft Dynamics CRM. Here is a list of some:

Order Product Pricing Locked


14 Feb 2017

In CRM 2016 with SP1, it seems that a "bug" has been introduced where the price of an order product added from the catalog (an "existing product") cannot be changed. This was not the case in earlier versions.

A field on the Order Product form, named Pricing (internal name ispriceoverridden) determined whether the price per unit can be changed. However, on the Order Product form this field is set to read-only with a value of "Use Default"; so there is no way to change the value to "Override Price".

Product Quantities


10 Jan 2017

When adding products to opportunities, quotes, orders and invoices you must specify the number (quantity) of items to add. What controls whether fractional quantities can be used and the number of decimal places to allow in quantities?

There are two settings to consider:

Dynamics 365 On-Premises


19 Dec 2016

The re-branding of Microsoft Dynamics CRM to 365 for on-premises deployments has arrived.

This is in the guise of the "December 2016 update for Dynamics 365 (On-Premises)" which you can download from https://www.microsoft.com/en-us/download/details.aspx?id=54515

Although it sounds like a new version, the December 2016 update is not a new version. Deploying this update changes the version to 8.2.0.0749, which is still part of the CRM 2016/version 8 release cycle.

Microsoft Dynamics CRM/365 Version Number and Code Names


30 Nov 2016
Product Name Version Code Name
4.0 4.0 Titan
2011 5.0  
2011 (Online only) 5.0 Polaris
2013 6.0 Orion
2013 SP1 and Spring 14 6.1 Leo
2015 7.0 Vega
2015 (Online only) 7.1 Carina

Microsoft Dynamics 365 and other services


15 Nov 2016

Work in progress

 

Common Data Service (using the Common Data Model)

PowerApps

Flow

 

For use with Office 365 Business SKUs, Outlook Customer Manager https://blogs.office.com/2016/11/14/introducing-outlook-customer-manager-relationships-made-easy-for-small-businesses/

 

Help Content Server Test errors


14 Nov 2016

In Microsoft Dynamics CRM On-Premises you might notice errors in the Event Viewer stating that the monitoring test failed for Help Content Server. The Event ID is 18732.

Microsoft Dynamics 365, Licensing and Pricing


14 Nov 2016

This is a work-in-progress article to record what I discover about Microsoft Dynamics 365 pricing and licensing

History

Microsoft announced the new cloud service, Microsoft Dynamics 365 as the evolution of Dynamics CRM in July 2016 planned for launch before the end of 2016. In fact, Microsoft Dynamics 365 was launched on 1st November 2016.

Associated Views


24 Oct 2016

In CRM, associated views are used to display lists of records when viewing related items within a record. An entity can have more than one associated view. So for example, when viewing activities from within an account, contact and so on, you can choose between the following views:

Pages