Skip to main content

Business Rules - Your One Stop Shop for Writing Logic Statements

Dynamics 365 Business Rules help organizations achieve automation by performing tasks for users based on predetermined logic. This means less time entering data and more time making key decisions. Business Rules can also be used to enforce behavior by controlling certain field properties. This allows upper management to ensure proper steps are taken daily. If these controls are implemented properly, both the organization and users will see the benefit afforded through the configuration of Business Rules.

Business Rules in Dynamics 365 are a simple way to apply logic to your business data without the need for any code. D365 Business Rules are effective, yet easy to manage. The typical Business Rule follows the “if, then” statement structure and often contains two or more parts. The first part is always a condition statement where you state the condition which will trigger the business rule to take effect. The second part is the action, meaning once the set condition has been met, what action should be performed.

Below is sample Business Rule diagram to illustrate how a typical Business Rule is setup.

As you can see, the condition statement is checking the Estimated Revenue for an opportunity, if the Estimated Revenue exceeds a certain threshold then an account manager must be associated to the opportunity. Simple rules like these can help organizations improve their daily process and grow more effective to achieve their goals.

Business Rules in Dynamics 365 can perform an explicit set of functions against records. Below is a list of the actions and what each does.

Continue reading
  6094 Hits

Manage all your companies using only one report with Multi-Company Consolidation in Dynamics GP!

 

Management Reporter provides the flexibility of consolidating financial data across one or multiple organizations in one single report. This report includes a summary (consolidated) report for all companies as well as the option to view a report for each of the companies that you are using on the consolidation.

The simplest method to create a consolidation of all companies is by using a reporting tree. A reporting tree is an optional “building block” that allows you to list all companies to be consolidated. Once the report is generated you will have the option to select any company from the reporting node on the consolidated report.

 


Viewing Companies Side by Side

The second option for consolidated reports is to show each company side by side. This can also be achieved by defining a reporting tree with all companies and using that reporting tree to assign each company on separate columns.

Continue reading
  10263 Hits

Can’t miss this: Add the Fixed Assets Module into Dynamics GP & improve asset management.

 

The Fixed Assets module for Dynamics GP helps your business improve its asset management by automating the accounting processes surrounding your property. You can use Fixed Asset Management, to set up, enter, and maintain asset records. When necessary, you can add insurance and user-defined information and create additional records for each asset, including investment tax credit information and lease information.

Simplify the depreciation process with modification, recalculation, averaging, comparison and projection capabilities.

Capture asset information in multiple books, allowing depreciation to be tracked under different methods for alternative reporting needs.

Provides accurate and accessible information – capture changes necessary for tax and financial reporting purposes.

Continue reading
  8413 Hits

Have you heard of the FREE tools available in the Professional Services Library in Dynamics GP?

 

The Professional Services Tools Library (PSTL) can be implemented in your Microsoft Dynamics GP environment very quickly. This add-on contains a large assortment of 25+ free tools for any business wanting to increase their business productivity. These modules are listed below;

    • Database Disabler – Allows the administrator to block users from logging into a company. The company will not appear in the list of companies when logging in to Microsoft Dynamics GP until the administrator unblocks the database.
    • Shortcuts Copy – Use this tool to copy the shortcuts options from one user to another user.
    • Update User Date – The Update User Date utility automatically updates the user data in Microsoft Dynamics GP to the next date at midnight each day. This is useful if Microsoft Dynamics GP is left running overnight.
    • Menu Inquiry Utility – Shows windows that are enabled and visible in Microsoft Dynamics GP.

 

    • Account Modifier / Combiner – Change a single or multiple account number(s) into new account numbers. Combine all of the open and historical data from two account numbers into one number or combine a range of numbers.
    • Checkbook Modifier – Allows the change of an existing checkbook ID to a new checkbook ID.
    • Fiscal Period Modifier – Use the Fiscal Period Modifier to change fiscal year definitions and reset data in the open and history tables. See detailed instructions before using this tool. Clicking on Setup Periods button removes previous year’s definitions.
    • GL Master Triggers – Keep the account numbers in sync between company databases. Add an account number to one database and it automatically replicates to other assigned databases.

    • 1099 Modifier – If the vendor was not set up as a 1099 vendor, can be used to update the records.
    • PM Master Triggers – Adds new vendors to additional selected company databases.
    • Vendor Combiner – Use the Vendor Combiner tool to combine a current vendor ID with another existing vendor ID.
    • Vendor Modifier – Use the Modifier tool to change an existing vendor ID or range of vendors to a new vendor ID. All work, open and history transactions are moved to the vendor ID.
    • Vendor Name Modifier – Use this tool to change the vendor name.
    • Minimum PO\Receipt Number – Stops Microsoft Dynamics GP from looking backward for unused document numbers.
    • POP Cost Defaulter – Defaults the current cost or the standard cost from the item master card instead of from the Item Vendors record.

 

 

Continue reading
  7051 Hits

Experience Digital Banking with the EFT for Payables Module for Dynamics GP

 

In today’s digital banking system, transferring EFT or ACH files to/from your bank has become a key element of any modern business. The EFT for Payables module for Dynamics GP will give your company the ability to automate this process entirely within your existing Dynamics GP environment. Proper utilization of the EFT for Payables module will increase productivity and reduce manual cheque processing.

     
  • Learn more about the EFT for Payables module for Microsoft Dynamics GP.
  •  
  • Eliminate costs associated with postage
  •  
  • Stakeholder has grown accustomed to-the convenience of this immediate payment method. 
  •  
  • Further, it is more environmentally friendly.
  •  
  • More secure than a cheque payment.

 

Contact us at This email address is being protected from spambots. You need JavaScript enabled to view it. to get started today

  5953 Hits

Build Dynamic Reports with Excel and Word Templates in Dynamics 365

Microsoft provides a robust connection between SSRS reports and Dynamics 365, allowing a user to run a report providing a summary of defined records. To create custom reports though, you will need to have a high-level knowledge of SQL/XML, or hire a consultant to build the report for you.

Why not take matters into your own hands and build your reports using out of the box components in Dynamics 365? Dynamics 365 offers both Excel Templates and Word Templates, empowering you to create reports which best suit your business needs, using the application that fits the bill.

Excel and Word templates allow you to create and share templates, so documents always have a consistent look and the necessary details included. Excel and Word templates are easily configured by selecting fields from your starting entity (i.e. Opportunity) to use as dynamic values in both Excel and Word. Not only can you select fields from the entity you began from, you also have the ability to select fields from related entities which have either a 1:N or N:N relationship with the starting entity.

With the help of Excel and Word templates, you can prepare beautifully crafted reports, which include data elements dynamically pulled in from D365. Should needs change, you can always modify and upload the revised template into D365, allowing you and your colleagues to always have the most current templates at your disposal.

Some benefits of using Excel and Word templates:

Continue reading
  9675 Hits

Simplify product and pricing management. Increase sales potential. D365 Product Catalog.

How many products/services do you sell? How many pricing structures do you have for each? Do you offer volume discounts? A no-nonsense, structured approach which can be seamlessly applied (every time and without a second thought) can improve your sales strategy and have everyone on the same page.

The Product Catalog in Dynamics 365 makes it easier for your sales reps to increase their sales by having an authority by which to work when talking to potential customers about products/services offered. The product catalog is a combination of the products themselves, and the underlying pricing mechanism.

Below are the components which form the Product Catalog:

  • Families & Products – Products are the items which you sell and product families provide a way to group, classify and categorize products for streamlined product management. Both bundles and individual products can be included in a product family tree.
  • Price Lists – Price Lists are product groupings with associated pricing. Sales operation managers can link Dynamics 365 territories to price lists. This directly benefits salespeople by defaulting the appropriate price list to opportunities, quotes, orders and invoices.
  • Discount Lists - Discount lists are optional and are used in conjunction with price list items for volume pricing offers.
  • Unit Groups - Unit Groups define the quantities by which a product or service is sold. For example, mouse pads may be sold in lots of 50, 100, or 200. Or Services sold by the hour may be grouped by day, week or month.

As you begin configuring your product catalog, add components in the following order: Discount Lists (if needed), Unit Groups, Price Lists, Products. When adding Product, you can define bundles, which allows you to combine multiple products into a group, to be sold as a package. Product relationships can also be defined, allowing for the suggestion of product substitutions; accessory recommendations; highlight cross-sell and up-sell opportunities.

Once the Product Catalog is setup, salespeople will have the ability to select and add products to their Opportunities, Quotes, Orders, and Invoices.

Continue reading
  5157 Hits

Locating Data in Dynamics 365 is a Snap!

Finding the data you are looking for may be far easier than you realize in Dynamics 365. There are many out-of-the-box elements in D365 which enable you to quickly (and easily) locate just what you need. Not only that, once you pinpoint the data, there are features that give you the ability to save the filter and create valuable metrics. This session will provide end users with valuable tips to efficiently and effectively find just what they need!

Topics to include:

  • Maximizing Views
  • Charts and how they interact with Views
  • Effective Use of Global Search and Quick Search
  • Creating Advanced Find Queries

Date: Thursday September 27, 2018
Time: 11:00AM - 11:30AM EST

CLICK HERE TO SIGN UP FOR THE WEBINAR TODAY!

 

  4822 Hits

Great Power BI Reporting Ideas for Dynamics GP

Learn how to read the data from Microsoft Dynamics GP in Power BI. In this webinar, we’ll be sharing great reporting ideas for Dynamics GP and demo our favorite dashboards. The dashboards that will be presented in this webinar are:

  • Financials Dashboard
  • Sales Dashboard
  • Project Accounting Dashboard

Date: Wednesday September 26, 2018
Time: 2:30PM - 3:00PM EST

CLICK HERE TO SIGN UP FOR THE WEBINAR TODAY!

 

  5196 Hits

POWER BI 101 WEBINAR

This Power BI 101 webinar will go more into detail than a simple introduction. This webinar will provide all the fundamentals needed in building a Power BI dashboard for your business. Join our webinar and learn the following:

  • Connecting to Data Sources
  • Creating Reports using Visualizations
  • Some Examples of Popular Power BI Reports

Date: Wednesday September 26, 2018
Time: 1:00PM - 2:00PM EST

CLICK HERE TO SIGN UP FOR THE WEBINAR TODAY!

 

  4603 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
  6883 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
  15055 Hits

Data visualization tools in Dynamics 365: Dashboards/Views/Charts

Do you find that the data shown in your Dynamics 365 environment is not reflective of the business data which is relevant to you? There are a variety of out of the box tools in Dynamics 365 which can be used to achieve this vital need. Such tools include Views and Charts which can be brought together into Dashboards to give an overview of data components captured in Dynamics 365.

For Dashboards, Views, and Charts there are two definitive types, Personal and System.

Personal Dashboards/Views/Charts

You, and anyone else, who has at least User level access to the system can build their own personal dashboards, views and charts based on their privileges in the system. The system administrator can modify the access level for each action in the security role to control the depth to which people can create, read, write, delete, assign, or share personal views.

All three components are owned by individuals and because of their default User level access, they are visible only to that person or anyone else they choose to share them with.

Continue reading
  10683 Hits

Is Dynamics GP Dead?

Is Microsoft Dynamics GP Dead?

Is Dynamics GP dead? For 20 years Dynamics GP has helped business become digital. Rest assured Microsoft Dynamics GP has made its mark in the Dynamics ecosystem, and it’s here to stay. Join our webinar and find out where Microsoft Dynamics GP is headed.

This webinar will cover

-The future of Dynamics GP
-What it means for your business

Date: Wednesday August 29, 2018
Time: 11:00AM - 11:30AM EST

Continue reading
  5222 Hits

Key Differences and Comparison: Dynamics GP or Dynamics 365 Business Central

Key Differences and Comparison:
Dynamics GP & Dynamics 365 Business Central

Microsoft Dynamics GP has been around for over 20 years and Microsoft Dynamics 365 Business Central is Microsoft’s newest accounting system. Both systems are geared to manage core finances for small and medium-sized businesses, but they also have some key differences. This webinar will be comparing the differences between Business Central and Microsoft GP, topics will include:

-Multicurrency
-Financial Reporting
-G/L Account Structure
-Project Accounting
-Manufacturing

Date:  Wednesday August 22, 2018
Time: 11:00AM - 11:30AM EST

CLICK HERE TO SIGN UP FOR THE WEBINAR TODAY!

  6252 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
  5253 Hits

Streamline your business process with Dynamics 365 Business Process Flows

Microsoft Dynamics 365 offers the ability to streamline your business process through an often overlooked and underutilized feature called Business Process Flows. Business process flows are displayed visually in Dynamics 365 as a heading across the top of an entity form, and can carry from one entity to another, and can be configured for both out of the box and custom entities. Not only that, you are not limited to a single business process flow; you can configure one or more distinct business process flows, allowing different departments to have a flow unique to their daily requirements.

A business process flow is composed of Stages (highlighted in red below), which contain multiple Steps (highlighted in green below). In the business process flow heading, a user can see which stage they are currently working through (which is indicated by the flag), and the steps they need to complete (what fields need to be filled in) before they can advance to the next stage in the process.

Business process flows enable you to require users to complete certain steps before advancing to the next stage of the process. They also allow for branching logic based on data elements collected which may require a different path. There are a couple out of the box business process flows pre-configured for system entities, but you can modify these and create your own business process flows to meet the particular needs identified for your organization.

Create a Business Process Flow:

1. Go to Settings > Processes to create a new Process

Continue reading
  6825 Hits

3 Reasons why O365 is a big part of Digital Transformation

Office 365 is one of the most popular applications to make any business go paperless. Companies that use Microsoft O365 suite don’t have to worry about, documents or files getting misplaced. Here are three ways that any business can leverage Microsoft O365.

Flexibility and Scalability

Microsoft O365 is both flexible and scalable for any business. Microsoft O365 is available on a monthly or annual plan and can be scaled to cater to your business. It is very easy to add and remove users. Here at Websan, it can be done by filling in a form on our support page. Microsoft O365 has customized packages available so the right employees and departments access the best tools.

Moving to the Cloud

Microsoft O365 is in the cloud which means updates are done quickly by Microsoft with little to no interruptions. This will ensure that your business is using the latest versions of O365 and your business email and mailbox will never go offline. When O365 is deployed in the cloud, all the licenses will be active at once, making updating quick and secure by Microsoft.

Continue reading
  8675 Hits

Need to access Dynamics 365 while you are away from a PC? Use the Mobile App!

Dynamics 365 is a sophisticated Microsoft business application, it grants the ability to better manage the relationships of your Sales, Customer Service, Field Service and Operation processes. But how can you access your data while you are out in the field, the internet is down or you are not anywhere near your PC? Dynamics 365 for phones and Dynamics 365 for tablets apps are the solution when you're on the go. These apps give you immediate access to accounts, contacts, opportunities, cases, and so much more!

How to get the App:

Go to the app store on your device and download either Dynamics 365 for phones or Dynamics 365 for tablets, depending on the device you are working with. Both phone and tablet users alike will appreciate the new Unified Interface. The Unified Interface provides an optimized viewing and interaction experience, relative to screen size, device, and orientation.

 Accessing the App:

Once you have the app installed, open the app on your device, enter your Dynamics 365 URL (web address), and click the arrow to continue. Next you will be prompted for your user name and password. If you are unsure of any of these values, contact your Dynamics 365 administrator.

Continue reading
  6109 Hits

WebSan Solutions Inc. recognized as the winner of the 2018 Microsoft Canada Modern Marketing Innovation IMPACT Award for the Second Consecutive Year

WebSan Solutions Inc. is proud to announce that our team has won the 2018 Microsoft Canada Modern Marketing Innovation award.  These annual awards recognize Microsoft partners who demonstrate excellence in innovation and implementation of customer solutions based on Microsoft technology. Microsoft prides on having the largest partner ecosystem in the industry, with over 14,000 partners across Canada. Each of these partners play an integral role in unlocking new opportunities for Canadian companies and Microsoft is committed to helping their partner ecosystem build profitable businesses and successfully take their solutions to market.

Microsoft Canada presented these awards in 16 categories on July 16, 2018 at the Microsoft Inspire conference in Las Vegas, Nevada. Winners were selected based on the outstanding work the companies provided to their customers and community.

“This year’s IMPACT award winners represent the best and most forward-thinking innovators coming out of our partner community in Canada,” said Suzanne Gagliese, Vice President, One Commercial Partner, Microsoft Canada. “Microsoft’s partner ecosystem plays a fundamental role in driving Canada’s innovation agenda forward, and ultimately strengthening our position as a globally competitive and prosperous country. We congratulate all of the winners on this amazing achievement and their continued dedication to bringing cutting-edge solutions to complex business challenges and providing digital transformation opportunities for our shared customers.”

“To be among great company and win the Modern Marketing Innovation award is such a great honour. For me, it validates the hard work and tireless efforts of our marketing team to achieve outstanding results.

Our accomplishment illustrates our ability to stay ahead of the curve and serves as a testament to all our marketing efforts.” stated Andrew King, Managing Director at WebSan Solutions Inc.

Continue reading
  5254 Hits