How to create a workflow in Dynamics 365

This post will show you how to create a simple workflow using Dynamics 365.

In this example I will be creating a workflow where I will check to see if a person is over the age of 18, if this is true the person will be assigned to contact Tugrul (which is me).

Step 1: First we need to navigate to our Dashboard and go to the advanced settings which are located on the top right-hand side of the window.

Step 2: From the advanced settings window we can navigate to the Processes page from the drop-down menu.

Step 3: From the Processes window we can see all of the previous process created by default alongside any custom ones we may have created ourselves. We can now click on +New on the top left to create our own process. A prompt will appear on the screen which will ask us to fill in the necessary details. From the image below you can see the details, I have filled in to create our workflow.

Create new process
Processes prompt

Step 4: The first thing to do once we have created our process is to check the ‘Records field change’ under ‘Start when’. You can then click on the ‘View’ and select the relevant record we will like to set a listener on which in my case is birthday.

Select Birthday record

Step 5: Once we have selected the relevant fields it is now time to ‘Add Step’ and select the ‘Check Condition’ step so we can set our if statement to check if a person is under the age of 18.

Add step check condition

Step 6: We can now add our if statement which will select the entity Person, select Birthday field, add Greater Than clause and finally select current date to see if Person is <18.

Specify condition

Step 7: Once we have specified our conditions we can now save and Activate our process.

Activate process

Step 8: Finally we can check if our process is working by creating a new contact with a relevant date of birth or change a person date of birth who already exists in our database. We can check this by going to our processes and on the left-hand side selecting Process Sessions.

If everything goes well you should be able to see the status as succeeded and it will show whether the user was assigned correctly or not.

How to create new entities in Dynamics 365 ?

The objective of this post is to demonstrate the steps needed in order to create new entities in Dynamics 365.

Step 1: Navigate to Settings | Customizations

How to create an Entity in Microsoft CRM
Step 1

Step 2: Click on the Solutions tab. Select TopOneEntities solution to create an entity.

Step 2

Step 3: Click on Entities, then on the command bar, click New as shown below or you can select a pre-existing one

Step 3

Step 4: Enter the Display Name and Plural Name that will be used for this entity throughout Microsoft Dynamics 365.

Also, select the area that displays this entity, this will be dependent on which services you need this entity to show up on. Finally, once all changes are made be sure to Publish any changes made otherwise the changes will not take effect.

Step 4

Step 5: In the Ownership list, select one of the following:

User or Team. Records for this entity can be owned by individual users or by teams. Security can be defined according to the business unit with which the current owner is associated. For example, contact records are set to User or Team.

Organization. Records for this entity are used for reference by all Microsoft Dynamics 365 users. Individual users or teams can’t own these records. For example, product records are set to Organization.

Finally click on Save button and the publish button so all changes take effect.

How to create a custom dashboard on Dynamics 365 ?

This quick guide is to show users how to create their custom dashboards on Dynamics 365 and how to switch quickly between different dashboards. The image below displays a custom dashboard created by us. It demonstrates the different type of data that can be displayed on a dashboard.

Example of custom dashboard

How to view different dashboards:

On the top left of the dashboard there is a dropdown menu which displays all of the pre configured dashboards created by default. When users create their own dashboards they’re also stored here.

Creating new dashboard:

Header

On the header of the dashboard page we can see a bar which looks like the image above. On that bar click on new and select “Dynamics 365 Dashboard”.

Choose layout prompt

You’ll be prompted to pick your desired layout, there are a few pre-sets but these can be configured after being created. Once selected users will see a new pop-up on their screen with a template of the layout chosen.

Layout editor

From this layout editor users are free to add and remove elements from their dashboards. The example above shows the 3-column regular dashboard. Users can insert charts, lists, assistants, Iframe and web resources into any of these blocks. The layout editor also allows to remove blocks, change positions and even increase/decrease the height and width of the blocks (some blocks need to removed for this). Once users are happy with their layout they can save the changes and close the window. Now everything has been set we can go to the drop down menu on the top left and select our dashboard which will have the name the user has set on the layout editor.

What is Dynamics 365?

What is Dynamics 365? It is a set of connected modular SaSS applications and services designed to transform and enable core customer, employee and business activities.

Overview:

  • Combination of CRM and ERP solutions in a cloud service, which allows a more modular approach to purchasing and using business applications.
  • Each area of Dynamics 365 is a module, i.e. Sales or Operations and can be mixed and matched
  • Allows a more unified and integrated experience with fluid UX at its core
  • Bringing your business together as a cohesive unit by connecting people, processes, and data across many applications, including Microsoft Dynamics 365, Office 365, LinkedIn, and Azure.
  • Adapting the application to your needs rather than changing your business methodology. You can integrate most applications with existing systems or even customise them with Microsoft Power Platform.
  • Modernise your approach by incorporating AI, mixed reality, social, and mobile capabilities for progressive business innovation.

Modules (Organisations can choose from the following Microsoft Dynamics 365 applications and features):

  1. Sales: Provides insight into prospective customer sources, personalisation of service and customer engagement data, sales productivity and performance metrics on many platforms.
  2. Marketing: Links up Dynamics CRM with Adobe Marketing Cloud to provide campaign management and targeted, personalised marketing tools that cater to the businesses unique needs.
  3. Customer Service: Offers multi-channel tools for engaging customers, tools for self-service / self-care portals as well as tools for community engagement and support agents.
  4. Field Service: Primarily used for planning and scheduling resources, managing contracts, inventory, insights into the internet of things-connected products and customer communications tools.
  5. Finance and Operations: Financial management with all the reporting and analytics tools. It also includes manufacturing tools for project management, production planning, scheduling, cost management; and warehouse and inventory control tools for supply chain management.
  6. Project Service Automation: Automate project planning, resources scheduling, time and cost management, and service analytics in an all-in-one package. Gets you what you need while making management seamless.
  7. Retail: Combined business tools, store and employee management, merchandise management and operational insights.
  8. Talent: Human resource cloud services connected with LinkedIn to manage all aspects of HR. This includes attracting, hiring, and onboarding new employees in managing HR programs.

What is CRM?

CRM stands for Customer Relationship Management. It’s a technology used to manage interactions with customers and potential customers. A CRM system helps organisations build customer relationships and streamline processes so they can increase sales, improve customer service, and increase profitability.

The goal of CRM is to improve business relationships with their customers, this is achieved through customer retention and customer acquisitions (in laymen’s terms it is holding on to your current customers and the ability to gain new customers overtime).

Different uses of CRM:

  • CRM as Technology: This is a technology product, often in the cloud, that teams use to record, report and analyse interactions between the company and users. This is also called a CRM system or solution.
  • CRM as a Strategy: This is a business’ philosophy about how relationships with customers and potential customers should be managed 
  • CRM as a Process: Think of this as the system a business adopts to nurture and manage those relationships.

Benefits of CRM:

  1. Better Data Organisation: CRM software allows businesses to import their data through leads, contacts and customers which as a result allows a business to keep track of their sales and engagement with the business.
  2. Enhanced Communications: CRM software provides automatic reminders for sales teams and allows a business to create email templates speeding up the process of contacting customers.
  3. Easily Share Information within the Business: A portal that allows a business to easily share information with employees through the use of one application.
  4. Catch all Leads: Quick analytics can assign the right employee depending on customer needs and allow for a quick response from the business to the customer.
  5. Analytics: CRM provides a lot of information for a business including things like sale numbers which help keep track of revenue generated by each employee allowing for an easier way to keep track of targets.

The use of the information above CRM allows a company to take a look at the level of customer support they provide along with raw data which in return allows them to implement/change strategy depending on the business/customer needs at any time. As a result of this information provided a business should be able to increase customer satisfaction, engagement and profits. A CRM is just one of the many tools a successful business should be using as a means to improve profits and customer acquisitions.

(GDPR)Managing Dynamics CRM Data Retention Policy With Bulk Record Deletion

Thank you for taking time to read this post.  I am a Microsoft Dynamics Certified Professional.I am not a lawyer so l am not making conclusions but pointing out key GDPR considerations
This means that organisations should remove information pertaining to data subjects when:

• There is no further requirement to do so, either contractually or legally (i.e. they are no longer required to as part of a statutory instrument)

• The subject has withdrawn their consent

• It has been identified that data is being held which is at odds with an organisations policies or primary business activities

Article 5 extends this further by making it clear that data which you are unable to keep sufficiently accurate should be “erased…without delay”. To avoid this scenario would require the need to regularly contact the data subject concerned to verify their details are correct. One of the major “get out of jail free” cards that GDPR provides surrounding data retention is in instances where the data will be used as part of “archiving purposes in the public interest, scientific or historical research purposes or statistical purposes..” (Article 5). The scope of this is, as you can tell, rather limited and most non-governmental organisations/businesses may struggle to demonstrate their data archiving is in line with these broad principals.

The importance of ensuring a clearly defined and structured process for the removal of customer data, therefore, becomes a paramount concern under GDPR. Investigating and defining your organization’s data retention periods is an exercise that should be carried out if it has not been done so already. Once implemented, we can then turn to a component within CRM/D365 to automate and streamline the actual process – the Bulk Record Deletion feature. (Check the technet article for further guidance) https://technet.microsoft.com/library/dn531072.aspx
In a nutshell, this feature is a really efficient means of deleting large amounts of predefined data within CRM/D365. Administrators of the application will most often work with them when attempting to reduce the storage footprint of a CRM/D365 instance, via the removal of completed System Job records and other superfluous record types. The ability to define filter criteria, re-occurrence settings and to send out email notifications upon completion of a job, make them an excellent candidate to consider when streamlining your internal processes surrounding data retention.

For example, let’s assume your business has implemented a data retention policy that states Contact entity data that has not been updated or changed within 12 months should be deleted from the system. Setting up a Bulk Record Deletion Job within the application to assist with this task is remarkably straightforward, as the step-by-step guide below indicates:
1. Within the application, navigate to Settings -> Data Management on the Sitemap and click the icon to navigate to the Data Management page:

2. On the Data Management page, click on the Bulk Record Deletion icon to open the All Bulk Deletion Systems Jobs view. Once this has loaded, click on the New icon:

3. The Bulk Deletion Wizard will open a pop-up window. Click Next on the first screen to move to the Define Search Criteria window. Modify the settings as follows:
o Look for: Contact

o Search Criteria: Modified On Older Than 365 Days

   Click Next when you are ready to navigate to open the Select Options page. Give the Bulk Record Deletion Job a descriptive name and then ensure that the following settings are configured:

o Specify whether the Job should run immediately or in the future. It is recommended to schedule Jobs out of peak hours to prevent any performance detriment to other users.

o Ensure that the Run this job after every box is ticked and then select an appropriate time period. I would recommend 30 days.

o Ensure that the Send an email to me… box is ticked. You can also (optionally) specify additional email recipients, but note that these have to be valid application users (i.e. not any other email enabled entity such as Contact, Account etc.)
1. The final step in the wizard gives you the opportunity to review all configured settings. Press Submit to create the Job in the system and, if specified to start immediately, begin running it in the background. You can also navigate to the Recurring Bulk Deletion System Jobs view at any time to review the current status of a job, check to see when it is next scheduled to run or even modify its properties to suit your requirements:

A simple example is as below

• Create a custom entity to store contractual/statutory data retention limits and link these to your common entities within the application via a 1:N relationship. Once selected when a record is created, you can then define a workflow with a wait condition that updates a Two Option custom field on the entity as a flag for a Bulk Delete Job to remove from the system.

• Using a custom field on your entity to indicate that a customer has expressed their “right to be forgotten”, define a workflow that sends a customer confirmation that their details will be removed from the system within 30 days and then use this same field as a flag for a Bulk Record Deletion Job.

• Define a workflow that sends an email to owners of records that have not been modified within a set period (i.e. are inaccurate), prompting them to speak to the customer to update their details. Records that are not updated would then be deleted, using a Job similar to the one above.

Autonumbering in D365

https://www.encorebusiness.com/blog/dynamics-crm-auto-number-entities/

https://community.dynamics.com/crm/b/razdynamicscrmconsultant/archive/2016/01/17/free-autonumber-solution-for-microsoft-dynamics-crm

https://community.dynamics.com/enterprise/b/dynamics365fordevelopers/archive/2017/10/02/native-dynamics-365-v9-auto-number-solution-for-custom-entities

http://celedonpartners.com/blog/celedon-autonumber-solution-for-dynamics-crm/

Working version: https://crm2015autonumber.codeplex.com/

Solving Dynamics 365 Integration Scenarios with KingswaySoft and SSIS

Let me introduce very popular data integration’ scenario. The purpose of this presentation is an introduction a concept of CRM data integration based on Student Information System(SIS) – popular and interesting scenario. The thing is, many UK and Ireland’ universities have successfully implemented Microsoft Dynamics 365 – CRM. It is very interesting how they can take advantage of Dynamics CRM, KingswaySoft and SSIS. Based on my experience it is the best possible example to tell compelling story about CRM  data integration. Following concept keeps everything simple and really goes to the point.

1. Main points :

– Following solution was designed to provide an integration solution for passing data from/to Dynamics CRM from/to Student record System (including UCAS)

– As updates are made to the Student Information System(SIS), the updated record are written to an Intermediary Database(ID)

– Updates are periodically collected  from the Intermediary Database(ID) and written to Dynamics CRM

– As updates made to integrated records in Dynamics CRM, the updated record are written to the Intermediary Database

– Updates are periodically collected from the Intermediary Database(ID) and written to the Student Information System(SIS).

– Good data integration solution should be possible generic so config entities for data integration are implemented at CRM

– Solution covers an error handling and archiving as well

2. Daily Integration Steps
2. 1.    Collect the integration mappings configuration (config entities) from CRM

2.2.    Send Applicant data from the Intermediary Database(ID) to CRM for all applicants that are flagged as “dirty”. Dirty means that the records has been updated since it was last read (by the integration).

2.3.    Set the Applicants successfully written to CRM as not dirty.
2.4.    Read the integration last started date from CRM.
2.5.    Write the integration last started date to CRM.
2.6.    Send the following sets of data to CRM where the items are flagged as dirty (unsure?). For each Entity, set the successfully written rows as not dirty.
–    Applicants (contacts at CRM)
–    Applications (opportunities at CRM)
–    Documents
–    Form Qualification
–    Entry Qualifications
–    Clearance Checks
–    UCAS Choices
–    Communications