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.

D365 reports can be made for all aspects of the business from financials and sales to marketing and service. With all these options at your disposal, why not try out reports for your business today. Talk with your team and find out the key metrics that matter to them, then contact us at This email address is being protected from spambots. You need JavaScript enabled to view it. to let us know how we can assist in getting you on the right track for reporting.

Goal management in Dynamics 365 is a tool which provides the ability to manage KPIs in just a few clicks. You can use goals to compare targets and actuals for a defined period. And given the fact that Goals is an out of the box feature with Dynamics 365, you can set them up in no time at all. Additionally, since Goals are native to the system, they work seamlessly with workflows, business rules and other various Dynamics 365 functions.

To help you understand how goals work, consider the following scenario:

Your company sells drywall, you, as the sales manager, want to set a revenue target for the overall sales team and then targets for each individual sales team rep who will contribute to the sales team target. With the given targets you want the ability to monitor progress throughout the fiscal period.

To get the results you desire you will need to utilize a couple entities in Dynamics 365 and create a handful of records:

1. Goal Metric: this allows you to set the detailed measurement (amount or count) for the defined goals. You can create multiple goal metric records to measure different elements, revenue and number of panels sold for example.

2. Rollup Fields: the goal metric includes a section where you identify the rollup fields which will be used to track against the metric. You will define rollup fields which will be used to measure both the in progress and actual values.

3. Goal: the entity where you will define who is responsible for the goal, the metric being measured and the target. In the scenario where you are setting an overall sales team goal and then individual goals, you will create multiple goal records (1 for the overall cumulative goal, and then 1 for each sales team member).

All sales records identified will be rolled up against each sales agent’s goal, which are the child goals. Then the child goals will be rolled up to the parent goal, which is the overall sales team goal. You can then set up a dashboard with data components which display goal metrics, allowing you to sit back and monitor results as they start rolling in.

If you need assistance or have any questions while setting up goals, please reach out to our support team at This email address is being protected from spambots. You need JavaScript enabled to view it.. We are always happy to help you increase the productivity of your Dynamics 365 environment!

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.

In the Document Management screen, Click on Enable Server-Based SharePoint Integration.

This will open a pop-up window to walk you through the setup, first simply click Next to start the process.

Next select whether your SharePoint is Online or On-Premises, once done click Next.

On the next screen, enter your SharePoint site URL. Keep in mind your SharePoint should be under the same tenant as your D365 environment, once done click Next.

Once your site has been validated, click Enable and this completes your setup process.

Now that your Server-Based SharePoint Integration has been enabled, you can go back to your Document Management screen and select which entities should be enabled for SharePoint folders.

Click on Document Management Settings and in the pop-up window select the entities which you anticipate storing documents against and click Next.

On the next screen, you can define the folder structure. It is suggested that you choose Account, thereby creating the structure wherein the Account is the primary folder, and associated records fall as sub-folders beneath it. Make your selection and click Next.

Once this is done, click Finish.

That’s it! If all the steps were performed successfully you will now see a document option under your enabled entities which will allow you to store and manage files using SharePoint directly inside D365.

Enabling the D365 SharePoint Integration can be a huge boost to your office productivity. Users will no longer need to switch between windows and tabs looking for files; instead everything will be linked and managed, so your entire team can access them with ease. If you have any questions contact This email address is being protected from spambots. You need JavaScript enabled to view it..

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.

Finally, Resource Monitoring gives your manager and dispatch team a 360-degree view of where all your resources are. The Field Service schedule board tracks your resources’ schedules and where they currently are based on job sites. The schedule board also displays the status of the job in different colors to easily distinguish the various statuses of jobs, from Traveling to In Progress to Completed.

D365 Field Service is a great asset to have for any service organization. It helps business stay on top of their field work and provide great insight on how the organization is performing. D365 Field Service is a modern workplace necessity. To learn more about how D365 Field Service can benefit your organization, contact This email address is being protected from spambots. You need JavaScript enabled to view it..