Skip to main content

Bring your data to life with D365 Reporting

Dynamics 365 is a great tool for storing your business data, but if that is all you are using D365 for, then do we have news for you! One of the biggest values of D365 is the ability to create reports gaining valuable insight from your data. These reports can be setup in a variety of ways depending on your environment and organizational needs.

Do any of the above diagrams look familiar to you? If your response is “WHAT ARE THOSE!?” then you, my friend, are missing out! All the above are reports based on D365 data. These D365 reports can be run directly from D365 which gives users ease of access to analysis of business data. There are several types of reporting options available for D365, some are out of the box, while others require a bit more work to setup. With that in mind, many organizations opt to export their data to Excel and then use Excel to create reports, when they could be using these much richer options instead.

D365 out of the box comes with report building functionality, in the form of Charts and Views. Users can setup Dashboards incorporating these components, which can help them take their first step into the world of reporting. The CRM Report Wizard allows users to build reports using filters and conditions, like Views, with a touch more functionality and flexibility over the latter options.

While these out of box options are great, they do have their limitations which is why we also provide external reporting options. SQL and XML Reports are great for generating more complex reports and documents. However, if you are looking for an option that is more robust, and intensely eye-catching, then Power BI is the way to go. Power BI is one the most powerful BI and reporting tools on the market and integrates seamlessly with D365. Power BI allows for powerful drill down capability and smart slicers to filter your data however you like.

Reports are a great way for organizations to better understand performance, and with the various report options available, you are not limited to a specific visualization type. Data can be displayed through bar graphs, pie charts, map representations, grids…just to name a few! Maximizing the reporting options is great for upper management, who want a quick, high-level representation of how the business is doing. But wait there’s more! Automated reports can be generated with a click of a button and often require no additional maintenance once they are setup, reducing time and effort and improving efficiencies.

Continue reading
  4821 Hits

Setting up D365 Sales and SharePoint Integration

Setting up the native SharePoint integration in Dynamics 365 can greatly benefit your organization. SharePoint allows users to store files, organize them, and provide ease of access to their colleagues. One of the biggest upsides of enabling this integration is that SharePoint offers much more storage space then D365 Sales, so you do not need to worry about your D365 instance running out of storage, thereby incurring steep costs to increase storage limits.

D365 SharePoint integration allows records in D365 Sales to have their own folders in SharePoint, this ensures all files have their own place in the system. This blog will walk you through the step-by -step process on how to setup your D365 SharePoint integration.

Before you get started, ensure you meet the following criteria so the process runs smoothly.

Requirements:

  • Dynamics 365 Sales License with System Admin Access
  • Office 365 Global Admin Access

Once you have verified the requirements, log into your Dynamics 365 for Sales web client and go to the Settings tab, in the drop-down menu select Document Management.

Continue reading
  5915 Hits

Take Scheduling to the Next Level with Dynamics 365 Field Service

One of the newer modules in the Dynamics 365 family, Field Service, leverages the latest technology offered by Microsoft and combines it into one powerful solution. D365 Field Service is an integrated solution with your current D365 environment, enabling you to be field ready with your already configured environment, filled with customer data.

D365 Fields Service has tools to help organizations optimize their resources, effectively manage team members and automate work order creation to save you time and money. Field Service can even be used with IoT devices to alert you of an issue even before your customers are aware there is one.

In D365 Field Service, Work Order Management, Service Scheduling and Resource monitoring are 3 key capabilities provided by D365 Field Service.

Work Orders in D365 Field Service are records that track service jobs. Work orders can be created automatically based on set criteria from your opportunity or case records or created manually. Within a work order you can track specific incidents types, estimated time required to complete a job and create the bookings for the work orders With Work Orders stored in D365 you also can create rich reports to identify which phases of your services can be improved upon.

Scheduling Service has never been easier with D365 Field Service. With the Field Service Schedule Assistant, all you must do is specify your criteria and the system will find the best resource to get the job done. Field Service considers factors such as skill set, availability and even current location of your resources to help make the best decision possible. If you want to get even more efficient, you can setup up resource scheduling optimization to let the system handle all the scheduling for you.

Continue reading
  6172 Hits

DocuSign with Confidence

DocuSign for Dynamics 365 brings all the benefits of the DocuSign electronic signature solution to your finger tips inside D365. With a seamless integration into Dynamics 365, you can access DocuSign functions directly from your form’s tool bar. Some of the key functions include the ability to sign and get signatures, track document status, and dynamically pull data from records.

The most known function of DocuSign is the ability to capture electronic signatures which are encrypted and secure, allowing for accelerated turn around on getting those all-important signatures. Consider all the sales transactions in your pipeline which are slated to close, why not simplify the process for you and your customers by providing the option to sign electronically. DocuSign takes the hassle out of the traditional pen and paper approach by allowing users to sign on any device and have it integrated back to D365.

An added benefit is that elements of your DocuSign documents can be dynamically populated from your D365 records. This is a real timesaver, eliminating the need for your team to customize the document each time it needs to be sent to a new customer. In addition to being time saving, it also eliminates human error along the way, providing you the confidence of knowing the document was sent correctly the first time.

A final noteworthy feature of the DocuSign/Dynamics 365 integration is the ability to track the progression of your email and document. This level of transparency provides 100% visibility into the entire process, affording you piece of mind every step of the way.

To find out more about DocuSign for Dynamics 365 or to implement it for your business, contact This email address is being protected from spambots. You need JavaScript enabled to view it. today!

  6995 Hits

Relationships made easy!

Ever find that two or more of your Dynamics 365 contacts are related and want a quick way to record that relationship? Or have a Contact that is related to an Account record even though it is not directly associated? Well look no further because we have your answer.

Connections in Dynamics 365 are a great way to link records together without any hassle. Sometimes you may want a quick way to link records together without having to spend hours coming up with a custom solution to satisfy this everyday requirement. Connections is your answer for that, whether it be linking records of the same type or of completely different record types.

To connect two records together, all you need to do is click on the Connect button in the tool bar.

This will open the new connection window.

From here, lookup the record you wish to connect to by clicking the name field and then selecting search for more records.

Continue reading
  6086 Hits

D365 Workflows, your personal assistant

Ever wonder how your team can work more efficiently in D365? The answer is automation, and the number one tool to automate processes in D365 is workflows. Many of the simple (and complex) tasks users perform in D365 can be automated using workflows. Workflows evaluate given parameters and perform actions based on predetermined logic. Such an example is the automation of sending a welcome email when a new contact is created without you having to lift a finger.

Workflows in D365 are processes that typically work in the background to automate the flow of information. D365 Workflows are comprised of triggers, conditions, steps and actions. These properties determine the behavior which you want to have occur which impact your D365 records.

There are many functions you can accomplish using workflows in D365, below are some of the most common:

  • Automate Emails – Send out Emails to accounts, contacts or users when a certain criterion is met
  • Transfer Information – Automatically pass data from one entity to another entity
  • Update Fields – Update fields value based on different conditions and field value changes

These are just some of the automated processes which workflows can perform. The true possibilities of workflows are endless because they are custom built and can be created for just about every entity in D365. Contact This email address is being protected from spambots. You need JavaScript enabled to view it. today to learn more about how these quiet helpers can be implemented in your D365 environment, allowing you to be more efficient, organized, and on top of your day to day responsibilities.

  5900 Hits

Know where your records are going with cascading rules

Everyone knows that Dynamics 365 has many great ways to link entities together, however once they are linked what controls do we have over their behavior? Enter, Cascading Rules. Cascading rules are a set it and forget it setting which controls the behaviors between two related entities. Cascading rules in D365 allows users to control what actions are passed down from one entity to another.

A great example where cascading rules come in handy is when users want to reassign the owner for a specific account record. However, they do not want its related activities such as emails, tasks and appointments to change owner when this happens. This is when you would go into cascading rules and update the assign setting to prevent the assign action from being passed down to its related activities.

In D365 the out of box settings for cascading rules, for a good majority of relationships, is Set to Parental (Cascade All), which means the action taken on the parent entity will be passed down. Now this may be suitable for some relationships, but in the case of the assign action being applied to Activities, this typically causes some undesirable results.

Toggling the Type of Behavior to Configurable Cascading allows you to customize each of the relationship behaviors individually.

Below are the possible cascading options you can select for each action.

Continue reading
  6743 Hits

Finding Dynamics 365 Data Quickly with Global Search

Global Search is one of the most widely used features in Dynamics 365 since everyone needs to lookup records on a regular basis. Global search makes finding records easy because it allows users to query the entire D365 database in a quick and easy way. The main difference between global search and entity search is that global search checks multiple entities in the system while entity search only looks through records for a specific entity type.

Global search is great for looking up records if you only have a rough idea or small piece of information to go on. This is because global search checks multiple entities and multiple key fields in those entities for your search word. Global search casts a wide net and finds anything with a close match. With that said, global search does not check every field for a match because that would simply take too long.

With the above in mind, do you know which fields are being checked in your company right now when you perform a global search query? To find out, you will need account admin privileges, allowing you to look at the system backend and customize your global search setup.

To start, let’s check which entities are currently enabled for global search. To do so, go to Settings > Administration in the navigation menu.

Within the Administration screen click on System Settings.

Continue reading
  14836 Hits

Combine and Conquer with Teams in Dynamics 365

Dynamics 365 Teams are a great way to manage records and tasks because teams can own records and have a definitive security role associated outside the scope of a Users default role. This provides enhanced visibility to managers regarding which group is responsible for which objective; extends a Users reach enabling them to access and work with records they otherwise would not have privileges for; and allows for a simplified security structure, particularly when managing a large group of users.

A few examples of situations wherein teams are best utilized include:

  • When Users span multiple business units but share a logical association
  • Security Roles within a Business Unit are primarily restricted to User Access Only
  • In Customer Support where work is routed to a Support Queue and the management of the Cases is best done through team ownership

To setup a new team in D365, go to the Settings tab in the navigation menu and select Security.

In the Security section click on Teams.

In the team view window, click the New button on the command bar. This will open a new team form.

Continue reading
  5122 Hits

Have an idea, bring it to life with D365 Custom Entities!

Out of the box, Dynamics 365 has many great out-of-the-box entities such as accounts, contacts, leads, and opportunities. However, it is often the case, that the out of the box entities may not be the right fit or the only fit for every business. Businesses often have their own special requirements, and when these requirements do not fit the D365 mold, we look to custom entities to accomplish the desired result. Through the configuration of custom entities, D365 can be tailor fit to meet any business’ unique needs. That means custom forms, fields, business process flows, views, charts, and dashboards, all based on your specific requirements.

D365 out-of-the-box is like a good suit, you purchase it because you like the suit, but know that to get the “right fit,” your next stop will be your tailor. Custom entities are your D365 tailor. With custom entities you can construct entities based on your organizational needs. These custom entities can drastically elevate your D365 experience. By creating custom entities you’ll have a unique, one of a kind system, unlike anything on the market. This could be as simple as an entity to capture employee data in your organization, to a collection of custom entities working together to bring you a whole new experience.

The following is an example of some custom entities built to manage human resource activities. The below demonstrates a custom navigation tile built to clearly distinguish the custom entities which have been built to fall within the Human Resources component of the system, thereby easily distinguishing it from the out-of-the-box areas of the environment.

The Candidate entity in the collection had fields created and a custom business process flow built to manage the hiring process. This entity had relationships built which further tie it to the other custom entities which fall within the human resources collection. Being this is all custom built, the skies the limit. If you can imagine it, you can make it a reality.

Custom entities truly transform your D365 environment to fit your business requirements, so you never have to compromise. D365 out of the box is a great base to get started, but one size does not fit all, and that is where the ease and flexibility of the system is best recognized and where custom entities shine. Talk to your team and determine how you can leverage custom entities in D365, then email us at This email address is being protected from spambots. You need JavaScript enabled to view it. to discuss your ideas and get started on the path to building your perfect D365 environment.

  5004 Hits

Quick Create Forms, Data Entry Simplified!

One of the most common tasks for users in Dynamics 365 is entering data. Often users are required to enter data while on the call with a potential client or customer. Opening a new form and having to switch back and forth between screens can eat up valuable time for you and your client. It can also cause the user to lose focus and forget important information. Quick create forms give users a way to capture key information quicker and with less distractions.

To deploy quick create forms for your D365 environment, simply follow the steps below and you will be on your way to creating a more efficient data entry screen in no time.

Firstly, to use quick create forms you must enable it on the entity level. To do so, go to Settings > Customizations > Customize the System.

In the customization window navigate to the entity you wish to create the quick create form for and confirm that the ‘Allow quick create’ box is checked, otherwise select it to enable this feature.

Now that this has been enabled, go to the entity’s form section > click new > pick quick create form. This will open the quick create form editor.

Continue reading
  11419 Hits

Create D365 Quick View Forms in 3 Easy Steps

Quick View forms are a great way to view information from different entities while remaining on a single record. Quick view forms enable you to surface data from associated entities and display the data in read only mode on the form. This is done through linking the two different entitles together using a lookup field. Below you’ll learn how you can setup your own quick view form in just 3 easy steps.

1. Create a Lookup field

The first step in setting up a quick view form is to ensure you have a lookup field to the entity where the data is stored. If you do not already have a lookup field created, you will need to create one. To do so, go to Settings > Customizations on the navigation bar and select Customize the System.

Next navigate to the entity you wish to add the lookup field to, and thereby surface the Quick View form on. Click the Fields node, and create a new field.

Once you click new, the following pop up window will appear. Indicate a display name and change the data type to Lookup and select the entity you wish to associate to. Once that is done, click save and close.

Continue reading
  14204 Hits

Less options, more results with Dependent Option Sets in Dynamics 365!

Ever have the problem of scrolling down a long list of options only to miss what you were looking for? What if there was a way to limit your option choices based on values previously selected? Well now there is!

Dependent options in Dynamics 356 gives users the ability to filter down a long list of option values to just a handful of choices based on previously selected parent fields. This feature dynamically updates the options users see based on pre-set business logic.

Take the following transpiration data model as an example.

Traditional Option Set

Traditional option sets simply display all the options for each field without any consideration for previously selected option values. This method is cumbersome when it comes to long lists and can feel very redundant when looking through lists where some of the options obviously shouldn’t be there based on previous values selected.

Continue reading
  7550 Hits

Meet Advanced Find. Your Search is just Beginning.

Ever had your boss ask you to pull a report which meets a specific set of criteria or sat scratching your head trying to pull up a record, but could not recall the exact details? With Advanced Find in D365, you can find exactly what you are looking for in just seconds. Advanced Find is the most powerful and robust tool in Dynamics 365 for searching. Using intuitive, user friendly features, you can quickly create queries and search your entire D365 database with ease.

At first glance Advanced Find may appear a bit intimidating, however once you become familiar with it, you will find yourself using it all the time, and wonder how you ever worked without it.

Continue reading to learn everything you need to know to get started using Advanced Find today!

The Advanced Find button is simple to locate, no matter which screen you are on, because it is housed in the D365 navigation bar.

Once you click on the  Icon, a window like the following will appear.

Continue reading
  5084 Hits