Tip #242: Don’t forget the default filters

Default Report Filter

Are your users confused when a CRM report freshly-minted by a report wizard, does not deliver the data they expect? Inspired by our twice the tip, our fellow contributor Andre “I’ve got 88 in my handle” Margono sent us a fresh reminder that “the default filter is something that I often forget to remove/update and […]

Tip #225: When CRM makes ye say “Arrrrrrgh!”

Friday, September 19 International Talk Like a Pirate Day 2014 If ye be usin’ Dynamics C Arrrrrrrrrrrr M fer several years, ye may spy wit’ ye eye that CRM starts runnin’ like a scallywag. Here be several thin’s ye can do to swab th’ deck ‘o ye CRM system, hoist performance, ‘n spit shine th’ cobwebs […]

Tip #197: Don’t forget the cascading

You implement Microsoft Dynamics CRM and create a custom entity called “Account Review” as a child of the account entity. This entity is part of a sales management account review process. You make the entity relationship parental so that deletions and re-assignments of account records will cascade to related Account Review records. Five years later, when […]

Tip #189: What does “reparent” mean?

CRM 1:N relationships that are “Configurable cascading” type allow you to customize several cascading behaviors. For example, in the system parental relationship between Accounts and Contacts, you can change the relationship type to “Configurable Cascading” and then set the “Share” permission cascading to “Cascade None” so that sharing an Account with George will not also […]

Tip #184: Use CRM forms in Outlook

From the “Great features that have been in the application for a long time but many users don’t know about” file In CRM for Outlook user settings, you will see checkboxes for various activity types and contacts. If these checkboxes are checked, when a user hits the new [appointment/task/Email/Contact] button in Outlook, that user will […]

Tip #180: Don’t use that name

Microsoft Dynamics CRM restricts some words from being used for organization names. On Premises customers can find the list by running the following query: use mscrm_config select reservedname from reservednames The following is the restricted name list in CRM 2013: About Activities AdvancedFind api AppWebServices aspnet_client bi bin Biz Calendar Condition CRMReports CS dev Help […]

Tip #175: Miscellaneous privileges with multiple access levels

Send As Privilege

We are all familiar with the record privileges in Dynamics CRM. User-owned entities have 5 access levels (None, User, Business Unit, Parent: Child Business Units, Organization) while organization-owned entities have only two of those (Go/No Go). Then there are miscellaneous privileges and training documentation states that (highlight is mine): Each Security Role also includes miscellaneous […]

Tip #171: If email router is having a slow day or how to add custom index

Sometimes things are slow. Very. Slow. So slow that your email router starts spitting dreadful messages: #9628 – An error occurred while delivering the e-mail message with subject “None of your business” in mailbox foo@bar.baz for delivery to https://crm.bar.baz. System.ServiceModel.FaultException`1 [Microsoft.Xrm.Sdk.OrganizationServiceFault]: SQL timeout expired. (Fault Detail is equal to Microsoft.Xrm.Sdk.OrganizationServiceFault). If you are on CRM […]

Tip #169: Update related records with a workflow

Ever wish you could use a workflow to update related/child records? For example, when I update the address on an account, update the address on all of the related contacts. You can, with the help of the very helpful CRM 2011 Distribute Workflow Activity assembly written by Alberto Gemin on Codeplex. While this says “CRM 2011” […]