Revision as of 12:12, 12 June 2019

Microsoft Dynamics CRM

Purpose

The purpose of this guide is to document the process of:  

• Configuring ICM with Microsoft Dynamics CRM Connector. 
• Mapping data entities and saved searches from ICM to Microsoft Dynamics CRM Connector.

The guide also describes how to use Microsoft Dynamics CRM Connector for standard scenarios.
The document is primarily intended for:

• Administrators, who configure ICM and Microsoft Dynamics Connector
• Other users who work with Agreements in ICM

Overview of Microsoft Dynamics CRM Connector

Microsoft Dynamics CRM Connector allows you to access the full suite of ICM functionality within Microsoft Dynamics CRM Connector. 
With the Microsoft Dynamics CRM Connector, you can integrate data between Microsoft Dynamics CRM and other enterprise applications, Web Services, XML data sources, legacy systems and simple and complex flat- tiles. Whether your connection is with cloud, mobile or on premise software applications, you will be able to integrate quickly with a wizard-driven interface.

Setting up ICM in Microsoft Dynamics

Prerequisites

• Microsoft Dynamics CRM Organization
• System Administrator privileges to install and configure the Microsoft Dynamics CRM Connector
• Respective ICM instance should be configured on the system

Configuring CRM Dynamics 365 in ICM

To integrate ICM with Microsoft Dynamics CRM 365:

1. Log on to Microsoft Dynamics CRM. The Dynamics CRM 365 home page opens. 

 

6. Select the solution which you have downloaded from AppSource to your local drive. 

7. Click Next.

  
8. Click Import. The Import Options page opens.

9. After the Importing process is complete, the Import Solution page opens. The imported solution is visible on the All Solutions page.

10. Click Close to close the Import Solution page.

12. After all customizations are published successfully, ICM Solution opens in the list of solutions on All Solutions page in Microsoft Dynamics CRM Connector. 

 

Configuring ICM Solution

You can configure ICM Solution only after you have installed Microsoft Dynamics CRM Connector. For more information about ICM App installation in Microsoft Dynamics CRM Connector, see Configuring CRM Dynamics 365 in ICM. 

Configuring the ICM Solution

To configure the ICM Solution: 
1. Click Settings on the top navigation bar and navigate to Solutions. 
2. Click ICMSolution on All Solutions page. The ICM Setting page opens.

\ 
3. The following text boxes are available on this page, which can be set as per the requirement:

• Client Type: It is the name of the client that will be mapped with ICM. This value does not require any changes. 
• Version: It is the ICM version mapped with CRM. 
• Base URL: It is the URL of the ICM instance that is mapped with CRM. 
• Context URL: It is the specific URL of the ICM instance using which ICM application can be accessed through CRM. This URL is used to display the ICM user interface in CRM. 
• API URL: It is the specific URL of the ICM API. 

• Validate User Token API 
• Execute Saved Search URL 
• Get Config URL
• Quick Contract URL
• API Key
• Create Contract Caption: This field defines the title/header of the Create Contract page in CRM. 
• Create Contract Request Caption: This field defines the title/header of the Create Contract Request page in CRM.
• View Contract Caption: This field defines the title/header of the View Contract page.
• View Contract Request: This field defines the title/header of the View Contract Request page.
• Saved Search: It is the unique name of the saved search created in ICM. Replace the appropriate value of ICMSavedSearchName in this field that contains the existing JSON.
• Hide Contract Request Section On: Type the comma separated unique names CRM entities for which you want to hide the Contract Request section.
• Enable One Click Contract Creation: Select this checkbox to enable creating a Contract from CRM with a single-click.
• Allow Redirect: Select Yes or No to enable or disable the logging. Enabling the logging helps tracking the errors occurring on any environment for which logging is enabled. 
• Logging Level: Select the logging level from Info, Error or All from the drop-down. 
  • Info: Selecting this option logs basic information and data about the processes occurring at the back-end.
  • Error: Selecting this option logs the errors thrown by the system if any. 
  • All: Selecting this option logs all the information as well as the errors thrown by the system.

Quick Create Configurations

1. Click the plus icon next to Quick Create Configurations if you have enabled creating the Contract with a single-click. 

• Button Label: Type the text that you want to view as the button label in Contract or Contract Request sections when creating a Contract or Contract Request with a single-click.
• Active: Select this checkbox to enable the button in the Contract or Contract Request section. Only the buttons selected as Active will be available in the ICM section on the CRM user interface.
• Button Type: Select Contract or Contract Type from this drop-down based on your requirement. This is a drop-down just to specify the button type.
• Select Entities: Type and select the entities from this field where you want to make this button available.
• Select Action: Select the action you want the system to perform after clicking Quick Contract.
  You can select one of the following actions:
  • Create: Select this option to only create the Contract. The Contract is not visible to anyone until it is published. You (primary owner) can only make necessary changes to the Contract. If you have selected button type as Contract Request you can only create it and not perform any other action. 
  • Create and Publish: Select this option to create and publish the Contract. After publishing, other users with adequate privileges can take actions on the Contract.
  • Create and Send for Approval: Select this option to create and send the Contract for Approval. 
• Contract Type: It is the unique name of the Contract Type in ICM that you want to create with a single-click.
• Delete: Select this button to delete the row from this page which also removes the button from the user interface.

Enabling Single Sign-On 

You need to setup single sign-on for CRM to work seamlessly with ICM. For more information about setting up single sign-on refer to:
https://community.dynamics.com/crm/b/microsoftdynamicscrmsolutions/archive/2016/11/11/sso-configuration-for-crm-portal 

Working with Saved Searches 

You can use the Advanced Search option to search for existing entities. You can save these searches and pin them as Favorites for easy access. Saved searches can be opened for easy access to the search results.

Performing a Search to Save

 

• Metadata: the search is performed in the metadata of the selected Agreement. 
• Full Text: the search is performed within the contents of the document of the selected Agreement.

Saving a Search

If you have the search criteria defined and need to use it repeatedly, it is recommended to save the search. To configure Saved Search, we need some Data mapping which includes CRM Account and Opportunity ID (which is 18 digit of alphanumeric reference value). Hence, when defining the mapping of a CRM Opportunity with Contract Request, create a field/Attribute in that Contract Request that will hold the CRM Opportunity Id. You can similarly create an Attribute for the Account ID reference. After creating these required mappings, you can use the Saved Search.

To save the search:

1. Click the Save icon. This opens the Save Search window. Set the parameters for this Saved Search.
2. Type the name for the search. Use a name that you can easily associate with this search.
3. Click Yes to make it a global search. This allows all users of the selected Security Groups and Organization units to view it. Select No to save this search locally so that it will only be visible to the person creating it.

4. Specify the Advanced Parameters as follows: 

Updating Saved Search Configuration 

With this feature, the CRM Administrator can map any of the entity level or parent level Attribute for executing Saved Search provided the Saved Search is created in ICM as per the Attribute configured in CRM.
If you do not configure the Attribute in CRM, the Saved Search is executed based on the CRM record System ID. The Contracts or Contract Requests will be retrieved from ICM to CRM provided the saved search in ICM is configured.

Mapping Data between ICM and Microsoft Dynamics CRM Connector

Use the Configuration tile in the ICM application to specify the mapping details between CRM and ICM. Data Mapping involves the following two primary tasks:

• Creating Masterdata Contract Type
• Creating Masterdata records for mapping entities 

Support for different Attribute Types

Multi-Select Attribute

• This enables in creating an Agreement in CRM that contains multi-select Attributes.
• When you select multiple attributes in CRM for the Contract, it must be mapped with the multi-select fields in ICM.

Lookup Attribute

• This enables creating an Agreement in CRM that contains Lookup Attributes.
• When you select lookup attributes in CRM for the Contract, it must be mapped with the appropriate Masterdata record in ICM.

File Attachment 

• This enables creating an Agreement in CRM with attachments added in the Notes section.
• When you add an attachment to an Agreement created in CRM, it must be mapped with the appropriate Association added to the Agreement in ICM. The files in the Notes section are mapped to the File Selection Attribute in Agreement.

Creating a Masterdata Contract Type

1. Log on to the ICM application. 
2. Click Configuration on ICM Dashboard. The Configuration page opens. 

3. Click Create Contract Type on the Configuration page. The Select Contract Type page opens displaying the following options: 

• Agreement
• Associated Document 
• Masterdata
• Contract Request

4. Select Masterdata on the Select Contract Type page and click Next. The Create Contract Type page opens displaying the following five sections:

• Details 
• Attributes
• Display Preference
• Team
• Verify

Details
Enter the following information on this page: 

• Contract Type Name: Type the name in this field as Client App Entity Mapping. This Contract Type is used for mapping entities between ICM and CRM. 
• Contract Type Code: Every Contract Type is assigned a unique ID known as the Contract Type code. It is auto-generated when you create the Contract Type. 
• Enable Approval Workflow: Select Yes to enable the approval workflow. 
• Two Column Attribute Layout: Select Yes to enable a two-column Attribute layout. 

Attributes
5.  Click the plus icon and create the following Attributes in ICM because the integration between CRM and ICM is restricted to the use of these Attributes only. 

• Name
• ICM Entity Name
• Client Entity Name
• ICM Attribute Name
• Client Attribute Name

6. When creating each of the above Attributes, ensure that you retain the following default settings:

• Data Type: String
• Is Default: Off
• Is Editable: On
• Is Mandatory: Off
• Tracking Attribute: Off
• Is Unique: Off
• Defined by Rule: Off
• Is Inherit: Off
• Is Searchable: On
• Is Conditional: Off
• Is Lookup: Off
• Is Localized: Off 

Display Preference
7.  Select any four attributes that you want to display on the agreement tile view. 
8.  Click the plus icon or select the following attributes from the Available Attributes and click Next.
The Team section is displayed. 

• Client Name
• ICM Entity Name
• ICM Attribute Name
• Client Entity Name
• Client Attribute Name 
• ICM Relationship Key
• Data Flow Type
• Enable Sync
• Contract Events 

 

 
 

Creating Masterdata for Mapping the Entities 

You can create a Masterdata record for the Contract Type Masterdata that you created earlier. This helps in mapping the entities between CRM and ICM. ICM allows mapping this data from any CRM entity such as Opportunity, Account, or Quote to a Contract Request or Agreement by creating the Masterdata record in ICM.

To create the Masterdata record: 

1. Click Configuration on My Dashboard. The Configuration page opens.
 2. Click Masterdata on the Configuration page. The Masterdata page opens.

 
3. Click Create Masterdata on the Masterdata page. The Create Masterdata page opens. 

4. Complete the information in the following sections:

• Masterdata Details 
• Attributes 

5.  Click Next at the end of Masterdata Details section to go to the Attributes section and complete creating the Masterdata record. 

Masterdata Details 
6. Select the Category from the drop-down list. 
7. Select the Contract Type Masterdata that you created earlier. For the purpose of mapping the data between ICM and CRM, select Client App Entity Mapping. 

8. Click Next. The Attributes page opens. 
9. Click the plus icon or select the following Attributes from the Available Attributes. 

• Client Name
• ICM Entity Name
• Client Entity Name
• ICM Reference Key
• Client Reference Key

Attributes
10.  This section displays the Attributes that you created when creating the Contract Type Masterdata. Complete the following details on this page:

• Masterdata Code: Each Masterdata you create is assigned a unique ID. It is auto-generated when you create the Masterdata.
• Name: Type the name of the Masterdata record you are creating for mapping with ICM. 
• Ensure that the name you give to the Masterdata record is unique and can be identified easily. For example, you can use the following name for mapping: CRM_Acct_Agr_AccountName. This example clearly states that you are creating a mapping for an Agreement with a CRM Account (CRM Acct) entity and the Attribute that you are mapping is the Account Name on Agreement.
• Client Name: This helps in defining the mapping with the external system. For example, add CRM in the Client Name field to define the mapping between ICM and CRM.
• ICM Entity Name: Type the ICM Agreement Contract Type for which you are creating this mapping. 
• ICM Attribute Name: Type the ICM Attribute Name of the Contract Type Masterdata that you created earlier where the CRM data will appear. 
• Client Entity Name: This is the CRM side entity name (technical name) for which you are defining the mapping between ICM and CRM.
• Client Attribute Name: Type the CRM side Attribute name (technical name). It is the CRM side Attribute name (technical name) for the client entity name that you mapped.
• Data Flow Type: This defines the direction of mapping for the data flow. You can select from any of the following data flow types:
  • Client to ICM: Select this option if you want the data mapping from CRM to ICM. If you create the Agreement from CRM, the respective CRM entity value will populate in the ICM attribute. When you want to create or update the data from CRM to ICM, ensure that you select the flow as Client to ICM.
  • ICM to Client: Select this option if you want the data mapping to happen from ICM to CRM. 
  • Both: Select this option if you want to use the same mapping for data flow from ICM to CRM and CRM to ICM.
• Enable Sync: Select Yes if you want the data mapping to synchronize the data from CRM to ICM. This option works only if you select the data flow as Client to ICM.
• Contract Events: It is used to synchronize data from ICM to CRM. You can enter the events that happen in the Contract lifecycle such as Created, Approved, and Executed.

11. Click Save to save the Masterdata record and enable mapping between ICM and CRM.

Creating a Contract Request from an Opportunity

You can create a Contract Request if your organization does not provide the privileges to create a contract directly.
To create a Contract Request from an Opportunity: 
1. Log on to Microsoft Dynamics CRM Connector using your credentials. The Sales Activity Dashboard opens.

2. Select Opportunities under Sales on the top navigation bar. The Open Opportunities page opens.

9. Click Create Request. The Opportunity Summary page opens.
10. Click ICM on the top navigation bar. Then, click Contract Requests. The Contract Request page opens showing the list of available Requests.
11. Click View next to the Request you created. The Request Details page opens.
12. Use the buttons in the table below to perform a desired action:

Creating a Contract from Opportunity 

The process of creating a contract from ICM in Microsoft Dynamics CRM Connector is dependent on the workflow implemented in your organization.
To create a Contract from an Opportunity:

1. Log on to Microsoft Dynamics CRM connector using your credentials. The Sales Activity Dashboard opens. 
2. Select Opportunities under Sales on the top navigation bar. The Open Opportunities page opens.

3. Select Opportunities from the drop-down list under Sales on the top navigation bar of your Microsoft Dynamics CRM Connector page. The Open Opportunities page opens. 

4. Click the Opportunity from the list to create a Contract from Opportunity. The Opportunity Summary page opens. 

5. On the Opportunity Summary page, scroll down to the ICM section. 

 
6. Click the plus icon next to Contract. The Create Contract page opens in Microsoft Dynamics CRM connector. 

7.    Complete the following details in the sections below and click Next. 

Contract Type Details 
8. Enter the following information in this section: 

Attributes
This section contains the attributes that the primary owner selected while creating the Contract Type for the Agreement. Now, you are creating a contract using the same Contract Type. You can also save the details at any stage and return to this page to complete the Agreement later. The attributes displayed in this section vary based on the Contract Type you select.

 

Some Attributes are described here: 

Template Name
This section displays the Templates that you created for the selected Contract Type. This section opens only if you select Own type of paper to create the Agreement. Select the Template from the list.

 
Verify

• Click Previous to go back and make any changes to the Agreement. Click Next to return to this section after making the required changes.
• Click Create to create the Agreement in Microsoft Dynamics CRM Connector. After you create the Agreement, it is not visible to all users until it is published by its Primary Owner.
• Click Create and Publish to create and publish the Agreement. After the Agreement is published, it becomes visible to other users and a Draft watermark opens on the Agreement in all states until it is approved by designated approver.
• Click Create and Send for Approval to create and send the Agreement for approval. The Agreement is sent to the approvers that are set by rule for the Contract Type selected for this Agreement.

 
9.    After you create the Agreement, the Summary page opens. You can perform the following actions on the Summary page:

• Click Download All to download and save the Agreement and all its Associated Documents on your local computer.
• Click Download to save the Agreement on your local computer.
• Click Upload Document to upload the document in ICM application.
• Click Confidential to move the Agreement to a confidential Organization Unit.
• Click Edit to go back and make changes to the Agreement.
• Click Delete to delete the Agreement from ICM application.
• Click Cancel to cancel the process of creating Agreement.
• Click Lock to restrict any other user from taking action on the Agreement.
• Click Collaborate to share the Agreement with External users.
• Click Assemble Contract to include the Associated Documents with the Agreement.
• Click Request Review to send the Agreement for review. You can send the Agreement for review to an internal or external (third party) reviewer.
• Click Send for Approval to send the Agreement for approval. The Agreement is sent to the approvers that are set by rule for the Contract Type selected for this Agreement. If there is no approver in the Agreement team, the status of the Agreement changes to Approved automatically.

  
After the Agreement is created in Microsoft Dynamics CRM Connector it is available in ICM in the Draft state. You can send the Agreement for approval through Microsoft Dynamics CRM Connector, however, approve and reject actions on the Agreement can only happen through ICM.

Single-click creation of ICM Contracts and Contract Requests from within Microsoft Dynamics CRM

ICM integration with Microsoft Dynamics CRM now enables creating an ICM Contract through Microsoft Dynamics CRM with a single-click.

Till now, when creating an ICM Contract in Microsoft Dynamics CRM, the user was required to go through the entire New Contract creation wizard even if all the form values were pre-filled based on the existing CRM data. With this enhancement, you can now configure and enable the Quick Create button on the Microsoft Dynamics CRM interface to create an ICM Contract without having to navigate through multiple form pages. A similar single-click creation capability has also been added to the ICM Contract Request in Microsoft Dynamics CRM integration.

Support for synchronizing additional Attributes in ICM

ICM integration with Microsoft Dynamics CRM is now enhanced with support for the following entities, provided the appropriate mapping configuration is present in ICM:

• Multi-select and Lookup Attributes: When a user is required to select multiple or lookup values for a particular field in Microsoft Dynamics CRM, they are mapped and synchronized to the corresponding multi-select or lookup fields in ICM.
• File Attachment: Now, user has the ability of synchronizing the documents (in all ICM supported file formats) from the Notes section of Microsoft Dynamics CRM to ICM, on creation of a Contract from Microsoft Dynamics CRM. This can be achieved by creating appropriate mapping to the available file type attributes in ICM.

Increased flexibility to configure ICM Contract and Contract Request lists within Microsoft Dynamics CRM entities

With this release, Microsoft Dynamics CRM administrator can configure the list of Contracts and Contract Requests displayed in Microsoft Dynamics CRM entities like Opportunity, Accounts etc., on the basis of other custom attributes, for example, Region, Country etc., rather than the Microsoft Dynamics CRM system ID. If a specific criterion is not provided, the list of Contracts or Contract Requests will be filtered on the basis of Microsoft Dynamics CRM system ID by default.

Configuration for allowing user to start or stop redirecting to ICM iframe in CRM

With this release, CRM administrator can now allow the user to stay on the Agreement Details page in CRM after creating the Agreement. This enables the user in avoiding to navigate through the CRM user interface to access the Agreement that was created. The CRM administrator can configure the Allow Redirect field on the Configuration page in CRM.