Contact us today: (866) 4-WEBSAN (932726)                Get Instant Support

Leave the spreadsheets to your data analysts, and appreciate the effectiveness that charts provide. Dynamics 365 comes with a handful of charts out-of-the-box which you can pair with corresponding views to surface data visually. Like most companies, you likely have unique measures which the standard charts do not account for. That is where the flexibility and ease of creating your own charts in D365 shines. Dynamics 365 provides a variety of chart types allowing you to create column, bar, pie, funnel, and many more chart types, to fulfill your business needs.

chart pic 1

Charts interact with the view which is chosen, and the data reflected in the chart is refreshed when you toggle between views. So, if viewing My Opportunities, the chart will depict that information, if you switch the view to All Opportunities, the Chart will change to reflect the data of the newly selected View. Similarly, you can switch Charts to display the View data in another way.

chart pic 2

There are two types of Charts which can be created, system charts and personal charts. System Charts are created by a System Administrator or System Customizer, and are available to everyone in the organization. Personal Charts are those that a User can create for themselves, and are only viewable by that User (or Users they “share” the chart with), and what this blog will focus on.

Creating a Personal Chart

To create a chart, navigate to the entity (Accounts, Contacts, Leads, Opportunities…) for which you want to create a chart and choose the view which best demonstrates the data you want to visualize. Click the charts pane to expand this section.

chart pic 3

You can either create a chart based on an existing one by clicking on the disk and performing a “Save As” or you can create a new one by clicking the plus symbol.

chart pic 4

Specify what you want to display in the chart. Indicate the field and aggregate option for which you want displayed for the Series axis. Then select a field for your Category axis. You can create a chart with either multiple series or multiple categories, but not multiples of both.

chart pic 5

Click on the chart icon to select the type of chart you want to create.

chart pic 6

If you want to apply any specific filters, you can utilize Top and Bottom Rules. This allows you to only show the top or bottom values for your query. For example, display the top 3 Accounts by Estimated Revenue.

chart pic 7

The chart is automatically named based on the fields you chose for the series, category axes, and top/bottom filter, but you can re-name the chart to a value of your choosing. Save when done. Click the “x” to return to the chart selector.

chart pic 8

Your personal chart(s) will be displayed at the bottom of the chart selector.

chart pic 9

You now have the basic steps to create your own personal charts. Start thinking about your data, and how you may be able to add a visual twist. Should you need a hand, we are always available to assist, reach out to us at This email address is being protected from spambots. You need JavaScript enabled to view it..

The records you store in Dynamics 365 typically share some association with other records of the same type. Whether it be leads owned by a specific user, accounts of the same relationship type, contacts located in a specific city, opportunities created in last “X” days. The list is endless and limitless. With a little planning, you can create Views which automatically filter records for you based on the criteria you set.

So, what are Views in D365?

Views display all the records of a specific entity type in your D365 environment. Out-of-the-box you are provided with a variety views, but you can add to these, creating custom views which are significant to you. Clicking the drop-down arrow next to a view name reveals all the views you have at your disposal.

view 1

There are two types of Views which can be created, system views and personal views. System Views are created by a System Administrator or System Customizer, and are available to everyone in the organization. Personal Views are those that a User can create for themselves, and are only viewable by that User (or Users they “share” the view with), and what this blog will focus on.

Creating a Personal View

The creation of a personal view affords you the ability to configure the following attributes:

  • The filters which need to be applied, thereby restricting the records that appear
  • The columns you want displayed and their width
  • The sort order of the listed records

You can create personal views by saving a query that you define by using Advanced Find or by using the Save Filters as New Views and Save Filters to Current View options in the list of views. These options and saved Personal Views are included at the bottom of system views in the application.

view 2

To create a personal view, either choose Create Personal View at the bottom of the view list or select the Advanced Find icon in your navigation bar.

view 3

In either case the Advanced Find window will open, and you can begin a search on any record type. In the Look for dropdown, select the entity you want to perform the query on, and then you can either use an existing view and edit the conditions by performing a “Save As” or you can create a new view by selecting New.

view 4

Filter: In the select area, choose the fields you want to perform the search on, the query operator (equals, contains, begins with...), and the data value. Repeat these steps for each condition of your query.

view 5

All conditions are processed as an AND statement. In the graphic above based on how the data has been entered, the results will only display an Account that is in all three states and has open opportunities. This query will return zero results because an account cannot be located in 3 different states. To display results of Accounts that are in CA, TX, or NY you will need to process as an OR statement. Select the arrow next to each of the field names that you want to include as an OR statement, and choose Select Row. Then in the navigation bar, select Group OR.

view 6

Select Results in the ribbon to view the results.

view 7

Customizing Columns: From the query screen, select Edit Columns in the ribbon.

view 8

To add columns, select Add Columns, and make your selections. Then select OK.

view 9

To move the columns from left to right, select a column and use the arrows to move the column to the desired position.

view 10

To adjust the width of a column, you can either double click the column or select the column and choose Change Properties.

view 11

Configure Sorting: Select Configure Sorting to choose your sort column(s) and the sort direction, ascending or descending.

view 12

If you have added a column in error, or just decide you do not want the column in the view, select the column and choose Remove.

view 13

When you are done configuring the view, click OK. From the query screen, select Save or Save As in the ribbon and enter a Name/Description, then select Save.

view 14

After a quick refresh, when you navigate back to the entity you created the view for, you will find it at the bottom of the View list.

There you have it, you now know the steps to create your own personal views. So, have at it, and start creating views to your hearts delight. Should you need a hand, we are always available to assist, reach out to us at This email address is being protected from spambots. You need JavaScript enabled to view it..

Monday, 14 May 2018 23:02

Create D365 Quick View Forms in 3 Easy Steps

Written by

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.

quick view 1

quick view 2

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.

quick view 3

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.

quick view 4

2. Create a Quick View form

Next, we need to go to the entity the lookup was created for and create the quick view form. Navigate to the entity and go to the form section. Once there click the new button and pick Quick View Form.

quick view 5

This will open the quick form editor window. Here simply drag and drop the fields you wish to display to the form body on the left.

quick view 6

Once the desired fields have been added, click save and then publish.

quick view 7

3. Add the Lookup and Quick View form to a Form

Now that the lookup field and the quick view form have been created, it is now time to add them to a form where you want the associated data displayed. Go to the form you wish to display the quick view form on.

quick view 8

Open the form editor, drag the lookup field onto the form then switch to the insert tab. Here click Quick View form.

quick view 9

This will open the quick view control. From here, give your quick view form a name, select the lookup field you created earlier, pick the related entity, as well as the quick view form you created. Once done click OK.

quick view 10

This will create a field on the form. To apply these changes click Save and Publish on the Home tab.

quick view 11

Below is a preview of the result.

quick view 12

Now that you know how to create a quick view form and how to apply it, why not give it a try and enjoy the benefits it affords today! If you have questions or need assistance implementing quick view forms please contact This email address is being protected from spambots. You need JavaScript enabled to view it..

Get Ready, Get Set, Get Marketing with Dynamics 365 for Marketing!

Have you heard the buzz that Microsoft has launched a new marketing application, Dynamics 365 for Marketing?! The target market for this solution is small to medium-sized organizations who require an end to end marketing solution. Large organizations need not count themselves out, this solution has a little bit of everything. Join us for this session which will serve as an introduction to one of the newest Microsoft product offerings.

• Dynamics 365 Out-of-the-Box Marketing vs Dynamics 365 for Marketing
• What comes with Dynamics 365 for Marketing
• Navigating the Application
• Standout Elements of the Application

Date: Wednesday, May 30, 2018

Time: 11:00AM EST – 11:30AM EST

CLICK HERE TO SIGN UP FOR THE WEBINAR TODAY!


Crystal Williams, Web Marketing Assistant, WebSan Solutions Inc.,a 2017 Microsoft Modern Marketing Innovation Award Winner

Thursday, 10 May 2018 14:47

Five Reasons Why You Need A Payroll System

Written by


Five Reasons Why You Need A Payroll System

It takes a lot of time to keep track of the total hours worked by employees, stay up-to-date with tax preparation and update employee profiles. It’s time to get a new Payroll system if the HR department can’t keep up with daily operations. Here are five reasons why you need a payroll software.

1. Save Time: Payroll can be very strenuous with the mass amount of operations needed to keep everything in order. Calculating hours, tax preparation and employee data maintenance can take multiple hours to complete when it's done manually. Investing in a good payroll system will allow information such as direct deposits pay, up to date tables, and even updating your general ledger to be automated.

2. Reduces Human Error: When businesses manually enter employee wages, there is always the possibility of human error. Use a payroll system to reduce human error is and save the company money.

3. Always Up-To-Date with Taxes: When tax season is approaching it can take hours to ensure that all information that has been entered manually is correct. Payroll systems will always have the tax tables up-to-date, so your business will always be compliant without the added stress.

4. It is secure. One of the most essential features that a payroll system needs is security. Payroll contains very sensitive data, which is kept confidential and can be stored away safely in the cloud. The only person who has access to this data is granted permission through role assignments.

5. Easy Integration: It is important to have your systems talk to each other. Your ERP system and payroll system go hand in hand. Payroll software can easily be integrated with well-known systems such as Microsoft Dynamics 365 Business Central.

Microsoft Dynamics Business Central is an all in one system that allows businesses to work digitally and became scalable. Insight Works has developed a Canadian Payroll add-on that integrates with Dynamics 365 Business Central. Join our Canadian Payroll with Microsoft Dynamics 365 Business Central Webinar to learn how their system makes the whole process of employee administration and finance much easier.

Date: Thursday, May 24, 2018

Time: 11:00AM EST – 11:30AM EST

CLICK HERE TO SIGN UP FOR THE WEBINAR TODAY!


Crystal Williams, Web Marketing Assistant, WebSan Solutions Inc.,a 2017 Microsoft Modern Marketing Innovation Award Winner

You can now brand your Dynamics 365 environment! Themes allow you to apply your distinct logo and color scheme to your Dynamics 365 environment. Three simple clicks and you are well on your way to a D365 environment with a look all your own.

1. From the Navigation Bar, select Settings

2. Select Customizations

3. Select Themes

 Theme 1

Theme 2

Upon navigating to Themes, a few out of the box themes will be available to select and set as the default theme. The default themes cannot be modified, but can be cloned, should you want a head start on designing your theme. Otherwise, you can put your designing skills to the test and get theming.

Theme 3

Start by selecting an out of the box theme and cloning it, or create a new theme record.

Theme 4

Theme colors are defined using hexadecimal codes. You will need to either know the hexadecimal codes you want to use or find a good online resource, such as http://www.color-hex.com.

Theme 5

Theme 6

Theme 7

Theme 8

A fascinating feature is the ability to take a test drive of the User Interface with the newly defined color scheme before it gets released to your organization.

Theme 9

When you are ready to release the new theme, thereby making it the default, you can either select the theme from the Theme view and select Publish Theme, or do the same from within the theme record.

Theme 10

If you need assistance or have any questions while using Themes, please reach out to our support team at This email address is being protected from spambots. You need JavaScript enabled to view it..

 

 

In-Depth Cash Flow Analysis and Forecasting

Having enough cash flow to keep your business going is a primary focus for a business owner who wants a successful business. That's why we developed a series that will provide you with all the accounting tools you'll need to run a successful business. In this webinar, the following topics will be covered.

  • In-Depth Cash Flow Analysis
  • Cash-Flow Forecasting

Time: 12:00PM EST - 12:30PM EST
Date: Thursday May 24, 2018

CLICK HERE TO SIGN UP FOR THE WEBINAR TODAY!

Crystal Williams, Web Marketing Assistant, WebSan Solutions Inc.,a 2017 Microsoft Modern Marketing Innovation Award Winner