Tip #928: When CRM monthly charts won’t render

Just another pie chart

In Dynamics 365/CRM on premises, if you create a chart and group by month and find that it doesn’t render, you may need some additional SQL permissions. Database owner must have external access assembly/unsafe assembly permission SQL database Trustworthy property must be set to “on.” With these settings in place, your monthly grouped charts should render […]

Tip #917: Too many business units

Microsoft org chart

Someone recently asked me what I thought of someone adding 1,000 + business units to Dynamics 365. I told them it was a bad idea. Here’s why: Business units are like large granite rocks–they are designed to be permanent and infrequently moved. While users can be moved between business units, it is not a trivial […]

Tip #761: Script error in main.aspx on line 1

Fragile

When creating fine-tuned roles for restricted access to your Dynamics CRM deployment, be very careful about privileges granted on Customization tab in role editor. Some of the privileges are easy to overlook and, if not granted, that can break the user experience. What I learned today is that CRM is very sensitive about Process privileges. […]

Tip #621: When migrating notes, sort correctly

Dynamics CRM 2013 and later sort notes by modified on date. This means that when migrating legacy notes into CRM , it is important that you sort the source data correctly, so that notes will appear in the correct chronological order after the migration. Sort notes by created on ascending. This will load the oldest […]

Tip #554: Recently Visited Items in Outlook Client

One fantastic time saving feature in Dynamics CRM is recently visited items. In CRM in browser, if I click the drop-down arrow by an entity tile, I will see the recently viewed records for that entity. But what if I’m using CRM for Outlook? There is not drop-down to display the recently visited records. But […]

Tip #461: Getting started with that mysterious USD development

Kamaji - the perfect call center employee

Not United States Dollars, I’m afraid. Unified Service Desk, the quite achiever in the Dynamics family, and the secret sauce to any successful call center implementation. In addition to having CRM (any version from 2013 SP1 up to CRM Online 2015 Update 1 will do), USD initial setup even for the development is very trivial: […]