Thursday, February 28, 2019

SI Common solution in Dynamics 365 CRM

We have received a weekly update from Microsoft which caused error in transferring the solution between our environments.
When we tried to import the solution into the target environment, we received error saying:


<MissingDependency>
<Required key="655" type="60" displayName="Přehled prodeje" parentDisplayName="Klient" solution="SICommon (9.0.1.70243)" id="{cb430327-bcc1-416d-959d-db7592e685af}" />
<Dependent key="655" type="60" displayName="Přehled prodeje" parentDisplayName="Klient" id="{cb430327-bcc1-416d-959d-db7592e685af}" />
</MissingDependency>

We don't see such a solution in our system, so we had to ask Microsoft Support for help.
It turned out, that there is a mismatch between our two environments.

The issue we’re seeing is happening due to a version mismatch between source and target environments for the solution “SICommon” which is one of the Microsoft solutions that are not visible from the UI.
On source environment, the version is: 9.0.1.70243
On the target environment, the version is: 9.0.2.7

Suggested workaround:
If the form is not needed, we can remove the form from the solution on the source environment and re-export the solution
Though this is not recommended, but we can also adjust the solution.xml to remove the tag for missing dependency on this form.

If you don't do anything, it will be solved eventually.

Have a great CRM Day!

Friday, February 8, 2019

Alternate Keys on Connection entity

My customer wanted to manage the connections between accounts and contacts from external system.
We have configured the connection entity and created a new field called new_relationshipid and we used this field for setting up Alternate key, because this is an external id which should be used for future updates by the external system.

So far it is ok. Now comes the trick. When connection is created, the CRM is automatically creating a connection with the opposite direction. The one which you created has attribute ismaster = true. The duplicate one has the attribute set to false.
But when you create an alternate key on the connection entity, you actually block creating the connections. Alternate keys must be unique! So when the system tries to create opposite connection record, it fails.

I have created a ticket with Microsoft Support to handle this issue and the result of this was that the product team will remove the possibility of alternate keys for connection entity from the UI. So we will not be able to use them.

As a result we are forced to create a new custom entity to save connection information.

Michal

Tuesday, January 29, 2019

Sharepoint Online Integration - wizard keeps "working" without any error

Last days I have spent quite some on resolving the issue related to Sharepoint integration, so I would like to share my findings with you.

We have an online CRM  (D365CE) instance which we want to connect to the Sharepoint which is in the same tenant. Very simple task, really.

My problem was, that we want to set the site manually, because automatic setting is not how we need to have it in the Sharepoint. So I created the Sharepoint site in Dynamics manually. Then I needed to enable the documents on the entities. Very easy so far.
Then as a last step I wanted to do was to enable the Server Side Sharepoint integration. It did not finish.

The wizard was stuck after the second step, just before you should enter the Sharepoint URL.
I have passed this:
I never got to this:



Very hard to investigate what is going on :-( There was no error, nothing.

I had to contact the support team of Microsoft - they suggested that we need to have Global Admin role to enable the Sharepoint integration (that was not the case, this is not true - you can enable the integration just with Dynamics Admin role). Then they suggested that the URL of Dynamics and Sharepoint should be the same (like xxx.sharepoint.com and xxx.crm4.dynamics.com).
Again, this is just recommendation, but it is not a must.

Finally, we have deleted the existing configuration (the manually created Sharepoint sites) and started the configuration from scratch. It turns out, that you have to start the Server-side Sharepoint integration by enabling this option. Then, the site is automatically created and you can modify it further.

So the conclusion: When you want to use the Server-side Sharepoint integration, always start with enabling it first. Do not make any other changes before you enable the server-side integration!

You don't need to be a System administrator and the URLs do not matter.

Have a good CRM day!

Tuesday, January 22, 2019

Custom solutions history

Dear reader,
in the latest version which has Microsoft released is a new feature :-) !!
I have noticed this in version 9.1.0.1459 which has been deployed to us last weekend.
You will find it in the Settings area - it is call CUSTOM SOLUTIONS HISTORY.
It shows the history of imports of your cusotm solutions and the results of these imports.
Previously we were using the xrmtoolbox to enable this feature. Now it is out-of-box.


Great improvement I think.
Michal

Thursday, January 3, 2019

Wildcard in UCI

Just a short tip in the new year :-)
Our users are used to wildcard search (*) in lookup fields when working in Dynamics 365.
However, when we started testing the new Unified Interface, we have found out that this wildcard does not work anymore.
Instead we are now supposed to use % as a wildcard.
I hope this helps you.
Michal

Monday, December 3, 2018

Categorized search - view attributes

May be you have noticed that in the Categorized Search, you can see the results organized in groups by entities. Each record contains 3 attributes on the result page. Some of them will have "---" in place of actual values.
Here is the account. By default, the Categorized search shows account name, account number (why??? - this attribute has been removed from the form and therefore it is usually empty) and primary contact.
If you want to change what is displayed, you need to go to the appropriate entity and select Quick Find View.
Open it for editing.
You notice, that this view has the same three attributes as written above. The categorized search displays the first three attributes from this view. So if you want to change the results in categorized search, you need to modify these fields. Just click on the Add View Columns. Make changes, save and publish.

I hope this was helpful.

Have a great CRM!


Wednesday, November 28, 2018

Business rule can trigger custom Javascript

Recently I have discovered on feature which is documented properly, but it can be very useful.
Inside a Business rule, you can also use action called "Run script".
If you go to business rules and try to create one, you will most likely not see this option. Here is the trick.

This action is only available on the forms connected to the Task flows (accessible from mobile interface and the new unified interface).
So you need to create a new Task flow or open existing one. The go to Business rules.
Create a new Business rule there. You will notice, that this Business rule is only valid on the form which name is the same as the Task flow. It cannot be modified.
Now you can insert the Run script  component. Simple script can be inserted in the text field.

I would suggest putting only simple script here, as it is not stored as a Web resource and cannot be managed well.

I am using it for simple logic which must be implemented in the Task flow. I can access fields, change their properties and so on. But basically, any code will run. I did not hit any limit in terms of max number of characters.

I will keep investigating it and post any updates.