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
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 #840: Shared personal views and charts on mobile
One of the limitations of the Dynamics 365 (and 2016) mobile app is personal charts and views shared with another user do not display in that user’s mobile app. Saved personal views and charts that I own (or that a team on which I’m a member owns) do display in the mobile app. As a […]
Tip #761: Script error in main.aspx on line 1
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 #563: Where did my column go?
You are configuring a form, and you remove the sections from the third column of the tab. Then you find you can’t move any sections to the third column. To fix this, close the form and reopen it. The third column will have a section in it, and you can move other sections to that […]
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 #540: Blank Base Currency Fields
So you build a view that includes money/currency fields, but when you run the view, all of the base currency fields are blank. If you want to see the value of the Base fields, add at least one non base currency field to the view.
Tip #492: Whatever happened to the “copy a link” button?
Remember me? Users of CRM 2015 may notice that the “Copy a Link” button no longer appears in CRM forms and views. Email a link does, but copy a link does not. The reason goes back to the introduction of cross browser compatibility late in the lifecycle of CRM 2011. Since all browsers do not […]
Tip #461: Getting started with that mysterious USD development
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: […]