Writing walkthrough guides and technical documentation is more about the flow that you are describing rather than the actual writing itself because you are wanting to explain the process, not to write the next best seller on the NY Times book list.

But there is still a little creativity that you need to make the walkthrough interesting to the reader.

Although I have noticed that there are a number of different variations of the way that people want to have walkthrough guides structured depending on the audience.

In this walkthrough I will show a new Compose feature within the Author Tools template that may help a little with this problem.

I usually use a pretty simple structure while writing my walkthroughs. For example, here is an example blurb that I write for one of my guides that explains how to assign a Customer record a Type:

The first thing that we will want to do is set the type of customer record that we want to create.

Customers are configured either as a Person or as an Organization with their own specific naming format.

To do this, click on the Type dropdown list and select the Organization Type from the list

In this example we will set the Type to Organization.

Now we have set the Customer Type.

For example, here is the storyboard slide that I used for that example


And this works pretty well in most cases.

But there are some cases where you may not want to show all of the information that I have in the text of the slide.

For example, if I wanted to create a version of the walkthrough that shows just the step description and the sample data that I need to enter then I would have to create a new version of the storyboard and then cut up each of the text blocks and change the detail.

If you dissect it then you will see that it has these components:

Introduction: The first thing that we will want to do is set the type of customer record that we want to create.

Detail: Customers are configured either as a Person or as an Organization with their own specific naming format.

Action: To do this, click on the Type dropdown list and select the Organization Type from the list

Example: In this example we will set the Type to Organization.

End: Now we have set the Customer Type.

And within that structure there are also subcomponents that are useful, like:

Action Shorthand: Select the Customer Type

Example Data: Type: Organization

Not all storyboard slides are this detailed, or have all of these components in them, but it is a good example of a structured step with a lot of detail.

What I need to do though is extract all of these components out and then pick and choose when to use them.

To solve this problem I created an Advanced Storyboard template that I can use to extract out the different parts of the text block broken out into the different components.


This allows me to move the Text content into its corresponding text block and also create some additional variations of the instructions for the Shorthand and Data blocks.


Now that I have broken out all of the text into its component blocks, now want to use these to create my new variations of the final slide text that I will be using to create my documents from.

To do this I have added a new function to the Author Tools called Compose.

This allows me to select from a number of different composition templates that then specify how I want to build up each of the text elements in the storyboard – Subtitle, Caption, Text and Notes.


If I select the Guide template then this will copy the Shorthand to the Subtitle, the Data to the Caption, build up the Text from multiple different blocks and then also add a few more of the blocks to the Notes section.


If I change the Composition Template to the Lab template and then recompose the slide then you will see that only the Shorthand and the Data is added to the Text, but a lot of the description is added to the Notes section.

This is the perfect format for Presentations because the notes will show up in the Speaker Notes section.


If I change the Composition Template to the Exercise template and then recompose the slide then you will see that only the Shorthand is added to the Text, and the Data is added to the Notes.

This is the perfect format for hands on exercises because it is short and concise.


To see this in action, I have expanded out the Storyboard from that one slide to the full walkthrough with all of the different steps broken out to use the composition blocks rather than having all of the data in the text and then built the content of the text so that it has the Guide format.


If I switch to the Write tab and then select the Recipe template, then I can create my output document using this version of the content.


This will create my Recipe style document with all of the text giving me an instructional document that everyone is able to follow.


Now I will return back to the Storyboard and recompose the storyboard text using the Lab format.


When I recreate the Recipe document based on this version of the content then all of the steps are listed out for me showing the Shorthand and Data components, but no detail.

This is a great summary document for the expert users.


Finally, if I will return back to the Storyboard and recompose the storyboard text using the Exercise format then it is even more concise.


Bit one thing that I can also do here is update the template details and change the components that are being used to build the slide. Here I added the Shorthand to the Subtitle, and the detailed text to the Notes.


Now when I create the Recipe document it has each of the Steps listed out with the data from the step as detail. This is an even better version of the Exercise in this case.


Review

The decomposition of the Storyboard steps may seem like a little bit more work as you are writing your walkthrough guides, but it is worth it.

It makes you think a little more about the structure of the content that you are creating, and also then allows you to create variations of the walkthroughs for different purposes.

If you want to create a Presentation then you may just want to have the key information showing on the slides and not have the detailed text.

If you are creating a detailed Walkthrough guide then you may want to have more explanations for the screen shots than you would normally have to help the reader guide themselves.

If you are creating Hands on Labs then you may want to skip the detail, but have the steps and shortcuts in the document for easy reference.

If you are creating Student Exercises then you may want to have the step but no data so that you can provide that as a separate document.

And now we can do that through the Compose function.

How cool is that?

PowerApps is definitely one of the coolest tools that we have in our back pockets for extending out Dynamics 365, because it allows non developers to quickly and easily create new apps for Dynamics 365 without doing a lot of coding. It’s almost so easy you will feel like you are cheating.

In this walkthrough we will show you how easy this is by creating a sample application that will allow you to browse customers, orders and order lines directly from a phone, and we can probably do this in about 5 minutes.

Topics Covered

  • Creating your first PowerApp
  • Connecting the PowerApp to your Dynamics 365 data
  • Creating a Customer browser form
  • Adding a Sub Form
  • Filtering the sub form Detail
  • Creating a drill through action from the parent to the child form
  • Adding additional drill through forms

Creating your first PowerApp

The first thing that we need to do is create a new PowerApp using the PowerApp designer.

How to do it…

Start off by opening up the PowerApp desktop app and then click on the New menu item on the left.


This will open up the Create an app form where you can create apps directly from some of the common services. But in this example we will want to create a Blank app. We have two different options here, we can create a Phone layout or a Tablet layout.

We will click in on the Phone layout option.


This will open up the PowerApp designer page.

On the left you will see the one page that is automatically created.

In the center is the canvas for the design.

On the right is our configuration panel.

And along the top is the Action/Ribbon bar.


Connecting the PowerApp to your Dynamics 365 data

Now that we have an app to work with we will want to connect it to our data within Dynamics 365.

How to do it…

To do this, switch to the Content action menu and then click on the Data sources button.


On the right hand panel a Data sources option will show up. To connect to the data, click on the Add data source button.


This will then show us a list of different data sources that we can connect to. In this example we will want to click on the Dynamics 365 for Operations connection icon.


This will open up a list of connections to our Dynamics 365 for Operations environments that we can use for the application. All we need to do here is click on the connection.


Now PowerApps will interrogate the Dynamics 365 connection for all of the entities that are published for us to use.


For this example, we will type in customers into the filter box.


This will allow us to see the Customers entity and we can check the box to include it in the connection.


Before we finish though, let’s add in a few more table connections. Filter out the list by typing in salesorder into the filter box.


This will allow you to select the SalesOrderHeaders and SalesOrderLines entities that you can select and then click on the Connect button.


After you have done that you will see that the three data entities are now connected to the PowerApp.


Creating a Customer browser form

Now that we have connected the PowerApp to our data within Dynamics 365 for Operations, let’s start creating a form, and a great place to start is to create a way to browse through the customer data.

How to do it…

To do this we will want to add a control to the form that we can use to view all of the data that we have in the Customers data source. To do this, switch to the Insert action bar and we will see that there are a number of different visual control that we can use.


The form that we want to use here is the Gallery control which gives us a way you browse through multiple records at once. If you click on the Gallery button then you will see that here are a number of different formats for the gallery as well. We will want to select the Vertical Text gallery option.


This will add a new control to the page that we created.


It is connected to dummy data right now, but if we click on the Connection icon on the right hand side and it will show us all of the connections that we added to the app earlier on. Start off by selecting the Customers connection.


This will change the default fields that are connected to the form.


If you click on any of the fields on the right hand panel, you will be able to browse through all of the fields that are available within the connection. In this step we clicked on the Heading1 field and can select the Name field from the Customer connection.


If we click on the Subtitle field we can link that with the CustomerAccount field.


Now select the Body1 field. If you look up in the formula bar, you will notice that there is a formula that links to the fields.


If we want, we can create a function that includes multiple fields. In the formula bar, type in this function to show the Street and City.

ThisItem.AddressStreet & “, ” & ThisItem.AddressCity

If we want to see the form in action, all you need to do is click on the Play button in the form header.


Adding a Sub Form

Now that we have a Customer browser, we will probably want to add a little bit or other functionality. Since we connected the Sales Order Header entity to the data connection, then let’s add a sub form that will show all of the sales order headers.

How to do it…

To do this, we will want to create a new screen by clicking on the New Screen button within the Home action bar.


This will create a new blank screen for us. On the right hand side we will see a few sample layouts that we can use to save us some time in adding data galleries.


We can select a simple gallery browser layout and that will automatically add in a few sample controls.


If we click on any of the fields within the form then we will be able to see the fields and also the data connection.


Here we will want to click on the template data connection and change it to the SalesOrderLines data connection.


Now we will be able to click on the Heading2 field dropdown list and then select the SalesOrderNumber field.

Now we see all of the sales orders are listed in the form.


Filtering the sub form Detail

Seeing all of the sales orders is great, but, we only want to see the orders for the customer that we selected in the previous screen. So we will want to filter out the results just to the ones that are associated with the customer.

How to do it…

To do this click on the Function dropdown list on the left, and select the Items function. Within the function detail we can see that this is linked to the SalesOrderHeaders connection.


To do this, change the filter function to this:

Filter(SalesOrderHeaders, OrderingCustomerAccountNumber = Gallery1.Selected.CustomerAccount)

This command filters the SalesOrderHeaders table, just to show the sales orders where the OrderingCustomerAccountNumber matches the CustomerAccount that is selected form the first screen.


Creating a drill through action from the parent to the child form

Now that we have the sub form, we need to do one last thing before we can see all of this working. And that is to create a link from the parent form so that when we click on the record, it takes us to the child form.

How to do it…

To do this, select the field that we want to trigger the drill through on and then select the OnSelect option from the function bar.


Now we just need to change the function to use the Navigate command. So update the function to:

Navigate(Screen2,ScreenTransition.Cover)

This just says to navigate to the second screen that we created.


The next thing you know you will be taken into the sub form, and only see the sales orders associated with the customer account.


Adding additional drill through forms

Since we also included the Sales Order Lines connection into the application, let’s finish off the application by adding a third form that we can drill through into from the Sales Order Headers form to see all of the products on the order.

How to do it…

To do this, just click on the New Screen button to create a new screen and then select the form layout that you want to use for the form. In this example we got a little fancy and used the tiled view.


Then click on the connection link and point it to the SalesOrderLines connection.


Then set the Body2 field to link to the ItemNumber field.


And then change the Footer1 field to show the SalesPrice field.


Then update the Items function to filter out the data that shows to just the lines that are associated with the Sales Order Header form. You can do this by using this function:

Filter(SalesOrderLines,SalesOrderNumber = BrowseGallery1.Selected.SalesOrderNumber)


Then return to the second screen and change the OnSelect function to navigate to the third form by using the following function:

Navigate(Screen3,ScreenTransition.Cover)


BAM! Now we are seeing the lines as tiles.


Summary

How easy is that. We just created a simple app that browses customers and allows us to see all of the sales orders and lines for the customer as well. Coding this the normal way would take forever, and for this example we created it in just a couple of minutes. All we need to do now is pretty it up a little and add some branding, but that is the fun part.

About the Author

Murray is a Technical Solution Professional at Microsoft and Author of over 25 books on Microsoft Dynamics including the Bare Bones Configuration Guide Series which contains over 15 books that show novice users host to set up Microsoft Dynamics using visual walkthroughs. These guides start off with the Financial modules of Microsoft Dynamics and then progress through the Operational, Distribution, and then the more specialized modules like production, service management, and project accounting. You can find all of his books here on Amazon http://www.amazon.com/author/murrayfife.

Throughout his 30+ years of experience in the software industry he has worked in many different roles, including as a developer, an implementation consultant, a trainer and a demo guy within the partner channel which gives me a great understanding of the requirements from both customers and partners perspective.

Here is all of his contact information:

Email: murray@murrayfife.com
Twitter: @murrayfife
Facebook: facebook.com/murraycfife
Google: google.com/+murrayfife
LinkedIn: linkedin.com/in/murrayfife

Blog: atinkerersnotebook.com
Docs: docs.com/atinkerersnotebook
Amazon: amazon.com/author/murrayfife


Branding Dynamics 365 is something to give the system a little more of a personalized experience for the organization that we are working with, but we can take this one step further if we want by branding the login landing page that we always need to use to get access to the system.

For example, although colorful, the default login page for Dynamics 365 looks a little generic.

In this walkthrough we will show you how you can do this. All you need is make a couple of tweaks to the Azure Active Directory settings.


How to do it…

To do this, open up your Microsoft Azure portal for your tenant by browsing to https://azure.microsoft.com.

When you get there, click on the My Account link in the header of the page.


This will take you to the Manage your Azure account page, and from here we will want to click on the Azure portal link.


After you authenticate into Azure you will be taken into the Microsoft Azure Dashboard. Look on the left hand menu and select the Azure Active Directory item.


This will take you to an area where you can manage all of the different options for Azure Active Directory. The option that we are interested in looking at here is the Company branding options, so click on the Company branding link in the left hand menu.


When the Company branding page is displayed, just click on the Edit company branding link.

Note: The first time that you access this feature you may need to do a little bit of initial configuration and step through a wizard.


This will open up all of the Company branding options for us.

To start off, we can update the login page background image. To do that, just click on the folder icon to the right of the Sign-in page image field.


This will open up a file explorer and we can then select the background image that we want to use and then click on the Open button.


When we return to the Edit company branding form, the only step that is left for us to do is to click on the Save button in the header.


Then we will get a notification that the branding has been applied.


How it works…

To see this in action, we just need to log into Dynamics 365.

Initially, since we have not selected a domain, our login page will show the default background image.


But as soon as we either select, or type in a username that is connected to our domain, the background image that we uploaded will show up.

How cool is that?

But let’s not stop there. There is additional branding that we can perform that allows us to add a smaller branded logo in the login area where it is currently just saying Dynamics 365 Portal.


How to do it…

To do this, return back to the Azure Active Directory Company branding form. There are three more branding components that we can update including a banner image, and also a square logo image.

Start off by clicking on the Banner image file folder icon.


This will open up a File explorer and we will be able to select a small banner image and then click on the Open button.

Note: Pay attention to the size of this image – the recommended size is 60x280px, and also for some images you may need to take down the image depth so that it is led than 10KB.


After you have done that you should be able to see the new Banner image is showing on the form, and you can save the changes if you like.

Now click on the Square logo image file folder icon.


This will allow you to select a square logo image for the company branding.

Note: This is the light background version, so if you don’t want it to stand out too much, then you may want to use a white background for this image. Again, pay attention to the size of this image – the recommended size is 240x240px, and also for some images you may need to take down the image depth so that it is led than 10KB.

After selecting the image, click on the Open button.


After you have done that you should be able to see the new Square logo image is showing on the form.

Now click on the Square logo image, dark theme file folder icon.


This will allow you to select a square logo image for the company branding.

Note: This is the dark background version, you may want to use a dark, or black background for this image. And remember, pay attention to the size of this image – the recommended size is 240x240px, and also for some images you may need to take down the image depth so that it is led than 10KB.

After selecting the image, click on the Open button.


Now, all that is left is to click on the Save icon and save the changes.


How it works…

Now when you log into your organization, the smaller logo will show up as well.

This is useful for logins on smaller form factor devices like smart phones, because the background image will not be shown, but the logo image will.


Review

Branding the Azure Active Directory login page is a great way to add that extra little bit of personalization to your environment and also gives people something to look at each time you log into your environment.

And it only takes a couple of minutes to do which is a bonus.

About the Author

Murray is a Technical Solution Professional at Microsoft and Author of over 25 books on Microsoft Dynamics including the Bare Bones Configuration Guide Series which contains over 15 books that show novice users host to set up Microsoft Dynamics using visual walkthroughs. These guides start off with the Financial modules of Microsoft Dynamics and then progress through the Operational, Distribution, and then the more specialized modules like production, service management, and project accounting. You can find all of his books here on Amazon http://www.amazon.com/author/murrayfife.

Throughout his 30+ years of experience in the software industry he has worked in many different roles, including as a developer, an implementation consultant, a trainer and a demo guy within the partner channel which gives me a great understanding of the requirements from both customers and partners perspective.

Here is all of his contact information:

Email: murray@murrayfife.com
Twitter: @murrayfife
Facebook: facebook.com/murraycfife
Google: google.com/+murrayfife
LinkedIn: linkedin.com/in/murrayfife

Blog: atinkerersnotebook.com
Docs: docs.com/atinkerersnotebook
Amazon: amazon.com/author/murrayfife

Flow is great, and just being able to point and click to build integrations is the thing that makes it so usable. But sometimes you want to be a little bit cleverer with your data and even use functions that remodel the data.

For example, when creating a new Customer within Dynamics 365 for Operations through Flow when a new Account is created in the Common Data Service, if you are like me, then maybe you will want to have a consistent naming convention, and you don’t want to use the standard Account ID that is created in the entity.

My customer naming convention is the first two letters of the Organization Name and then 4 digits, but I cannot change the default numbering format for the Account Id in the Accounts entity.

If I were doing this through Excel, then I would use this formula: 

Upper(Left(OrganizationName)) & Right(AccountId,4)

But how do you do this in Flow?

The good news is that there is a special Data Operations service within Flow that allows you to create a function using data from the previous steps in the flow, and then you can use the output in subsequent steps.

Here is how you do it.

How to do it…

To start off open Flow and then create a new Flow by clicking on the + Create from blank link.

When the trigger event is displayed, search for the Common Data Service actions and select the When a record is created trigger event.

This will then create a trigger for you that needs to be configured.

Click on the The database dropdown list and select the default database.

Then click on the The entity dropdown list and select the Account entity from the list.

Now that we have the trigger which will fire when a new Account is created within the Common Data Service we want to add a step that will create our new account name from the data. To do this, click on the + New Step button and then select the Add an action button.

When the action browser is opened, search for the Data Operations service and then select the Compose action.

This will open a simple action that just has an Input field. This is where we need to create our function that will create our new Customer Number.

The function will be written in the Azure Workflow Definition Language and if you want to find all the documentation on it then here is the link:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

To create the new customer number that is the first two letters of the Organization Name and the last 4 digits of the Account Id (since this is a sequential number) then just paste in this function:

“@concat(toUpper(substring(triggerBody()[‘OrganizationName’],1,2)),substring(triggerBody()[‘AccountId’], sub(length(triggerBody()[‘AccountId’]),4), 4))”

After you have done that just give the Flow a Flow name and then click on the Create flow button.

After the record has been published then you will see that the Account ID is created for the Account.

When you return to you Flow you will see that is has been triggered and if you expand out the Compose action then the Output is now set to the format that we want for our Customer Numbers.

Summary

Now that we have composed our new field we can now use it in future steps within the Flow. For example if you continue on and add another action that created the Customer within Dynamics 365 for Operations, but when populating the Customer Number field, we can now use the output of the Compose action.

How cool is that? (Rhetorical question)

Power BI is a great tool for visualizing your data from Dynamics 365, but wouldn’t it be great if all of your reports and dashboards that you create were embedded directly into your dashboards. Don’t fret, you can do this without writing a single line of code.

Let’s see how to do this and how it works.

Topics Covered

  • Enabling Power BI
  • Adding Power BI Dashboards as Sales Dashboards
  • Drilling through the Data within Power BI

Enabling Power BI

Before we start adding Power BI to our dashboards within Dynamics 365 for Sales we need to first make sure that it is enabled.

How to do it…

To do this, start off by opening the Dynamics 365 for Sales app.

Then click on the Sales tile in the header and click on the Settings tile. Then click on the Administration menu item within the System menu group.

When the Administration page is shown, click on the System Settings menu link.

This will open the System Settings options panel. Click on the Reporting tab within the options and you will be able to see an option called Allow Power BI visualization embedding.

All you need to do here is make sure that this is set to Yes.

After you have turned on Power BI then you can exit out of the options.

Adding Power BI Dashboards as Sales Dashboards

Now that Power BI is enabled, you can start adding Power BI visualizations directly within Dynamics 365 for Sales as their own embedded dashboards.

How to do it…

To do this, all you need to do is open the main Sales Dashboards by clicking on the Sales button in the menu bar and then click on the Dashboards menu item within the My Work menu group.

To add a Power BI Dashboard, just click on the New menu item and then select the Power BI Dashboard menu item.

This will open the Add Power BI Dashboard dialog box and if you click on the Dashboard dropdown list then you will see that all of the dashboards that you have access to within Power BI will show in the list.

All you need to do here is select the dashboard that you want to use as a dashboard and then click on the Save button.

After you have done that you will see the dashboard is now embedded within Dynamics 365 for Sales as one of your personal Dashboards.

Drilling through the Data within Power BI

Now that that you have Power BI dashboards embedded directly within the dashboards, let’s see what you can do with the data that is there.

This will take you over to Power BI Online.

But there’s more. If you click on the … in the top right of the Power BI Workspace, then you will see an option that allows you to Analyze in Excel.

If you click on this, you will be taken over to Excel and all the data that you had within the Power BI workspace will be available as a Pivot Table.

If you want to be a little retro, then you can then create your very own analysis through Excel using the same data that you have within Power BI.

Summary

Power BI is a great reporting tool to take advantage, and as you can see it’s super easy to get the dashboards embedded directly within Dynamics 365 for Sales and then act upon it right from there.

All you need to do now is create the dashboards that you want to include and then start embedding them.

In May I will be helping out with the Microsoft Dynamics 365 Operations (Dynamics AX) boot camp in West Palm Beach at Palm Beach Atlantic University to train new graduates.  So I thought that I would forward on the information about that and also the other boot camps that are being held this year in conjunction with the Microsoft Academic Alliance.

All classes/courses/boot camps to be held in West Palm Beach at Palm Beach Atlantic University and the classes for 2017 are:

May 22-26th – Microsoft Dynamics 365 Operations (AX-Axapta) Bootcamp
May 22-25th – Microsoft Dynamics 365 CRM Bootcamp
July 2017 – Microsoft Dynamics 365 Financials Faculty/Professional Bootcamp

May Microsoft Dynamics 365 Operations or CRM Bootcamp

    • Bootcamp $495
    • Dorm Lodging $150 (for the week) Luxury dorms, many overlooking the Ocean
    • Conference hotel rates also available
    • Some scholarships available

July Microsoft Dynamics 365 Financials Bootcamp

    • Bootcamp $595
    • Low cost conference hotel rates available
    • Family outings for participants interested in bringing their family
    • Faculty receive coursework and outlines to jump start classroom learning

They are also looking for partners to participate, and is also a great place to find new talent.

If you are interested in helping here are the boot camps offered this Spring/Summer for

  • Microsoft Dynamics 365 Operations (Dynamics AX)
  • Microsoft Dynamics 365 Financials (Dynamics NAV)
  • Microsoft Dynamics 365 CRM (Sales and Service)

There is more information at www.aadynamicstraining.com

If you also want to complete the following 2 question survey then they will keep you updated on opportunities and details.

http://survey.constantcontact.com/survey/a07edrotzxriykvxzmv/start

You can pass this link onto others that may be interested as well.

Maybe I will see some of you all there 😊

 

Introduction

Dynamics 365 for Operations allows you to configure your own Vendor Evaluation Criteria and then track the vendor performance against any or all the criteria that you have defined.

In this worked example we will show how to configure the Vendor Evaluations groups and criteria and how you can record evaluation results against vendors.

Creating Vendor Evaluation Criteria Groups

The first step in configuring the Vendor Ratings within Dynamics 365 for Operations is to create some Vendor Evaluation Criteria Groups. These will be used to group common sets of evaluation criteria together and allow you to get summary results on the evaluations at the criteria group level.

In this worked example we will show how to set up a set of new Vendor Evaluation Criteria Groups.

How to do it…

To do this, open the navigation panel, expand out the Modules group, and click on the Procurement and Sourcing module to see all the menu items that are available. Then click on the Vendor evaluation criteria group menu item within the Vendor folder within the Setup menu group.


Alternatively, you can search for the Vendor evaluation criteria group form by clicking on the search icon in the header of the form (or press ALT+G) and then type in vendor eval into the search box. Then you will be able to select the Vendor evaluation criteria group maintenance form from the dropdown list.


This will open the Vendor evaluation criteria groups maintenance form, and we will see that we don’t have any records yet.


To add your first Vendor evaluation criteria group record, just click on the New button on the menu bar.


Now enter your Criteria Group code in the Name field.

For example, here we set the Name to QUALITY.


Next, give your Criteria Group a more detailed Description.

For example, here we set the Description to Quality Ratings.


Now we can continue and add a few more Vendor Evaluation Criteria Groups.

When we are done, we can just exit from the form.


Sample Data

Name Description
OVERALL Overall Evaluation Criteria
SERVICE Service Evaluation
PRICING Pricing Criteria
DELIVERY Delivery Performance
QUALITY Quality Ratings

Creating Vendor Evaluation Criteria

Once you have set up your Vendor Evaluation Criteria Groups, you will need to set up some Vendor Evaluation Criteria codes that you will use to rate your vendors.

In this example, we will show how to set up some Vendor Evaluation Criteria.

How to do it…

To do this, open the navigation panel, expand out the Modules group, and click on the Procurement and Sourcing module to see all of the menu items that are available. Then click on the Vendor evaluation criteria menu item within the Vendor folder within the Setup menu group.


Alternatively, you can search for the Vendor evaluation criteria form by clicking on the search icon in the header of the form (or press ALT+G) and then type in vendor eval into the search box. Then you will be able to select the Vendor evaluation criteria maintenance form from the dropdown list.


This will open the Vendor evaluation criteria maintenance form, and we will see that we don’t have any records yet.


To add your first Vendor evaluation criteria record, just click on the New button on the menu bar.


Now enter your Criteria code in the Name field.

For example, here we set the Name to Competitive pricing.


Next, give your Criteria a more detailed Description.

For example, here we set the Description to “The prices paid should be comparable to those of vendors“.


Finally, we will want to assign the Criteria to a Vendor evaluation criteria group.

For example, here we set the Vendor evaluation criteria group to “PRICING“.


Now we can continue and add a few more Vendor Evaluation Criteria records.

When we are done, we can just exit from the form.


Sample Data

Name Description Vendor evaluation criterion group
Sensitive to costs The vendor should demonstrate respect for the customer firm PRICING
Consistency Supplier’s ability to exhibit quality and reliability OVERALL
Cost Total acquisition cost, not just price OVERALL
Cash resources Financial resources and stability of the supplier. Profit OVERALL
Control Effective management control and information systems OVERALL
Commitment Supplier’s willingness to commit physical, intellectual OVERALL
Capacity Supplier’s ability to meet physical, intellectual OVERALL
Competency Managerial, technical, administrative, and professional OVERALL
Problem resolution The vendor should respond in a timely manner to resolve SERVICE
Emergency support Does the vendor provide emergency support for repair SERVICE
Good vendor representatives have sincere desire to serve Vendor reps display courteous and professional approach, and SERVICE
Emergency delivery Does the vendor demonstrate extra effort to meet requirement DELIVERY
Documentation Does the vendor furnish proper documents DELIVERY
Packaging Packaging should be sturdy, suitable, properly marked DELIVERY
Lead time Is the average time for delivery comparable to that of other DELIVERY
Quantity Does the vendor deliver the correct items or services DELIVERY
Technical support Does the vendor provide technical support for maintenance SERVICE
Inside sales Inside sales should display knowledge of buying firms needs SERVICE
Time Does the vendor deliver products and services on time DELIVERY
State-of-the-art product/service Does the vendor offer products and services that are consist QUALITY
Warranty The length and provisions of warranty protection offered QUALITY
Support Is quality support available from the vendor? QUALITY
Durability Is the time until replacement is necessary reasonable? QUALITY
Reliability of repairs Is all repair and rework acceptable? QUALITY
Reliability Is the rate of product failure within reasonable limits? QUALITY
Conformity to specifications The product or service must conform to the specifications id QUALITY
Compliance with purchase order The vendor should comply with terms and conditions as stated QUALITY
Billing Are vendor invoices are accurate? PRICING
Advance notice of price changes The vendor should provide adequate advance notice of price PRICING
Price accuracy There should be a low number of variances from PO’s PRICING
Price stability Prices should be reasonably stable over time PRICING
Competitive pricing The prices paid should be comparable to those of vendors. PRICING

Configuring Vendors for Evaluation

The final step in the setup process is to link the Evaluation Criteria with the Vendors within Dynamics 365 for Operations. This is done through the Procurement Categories.

In this example, we will show how to setup the Evaluation Criteria within the Procurement Categories and how to select the Vendors that you want to evaluate.

How to do it…

To do this, open the navigation panel, expand out the Modules group, and click on the Procurement and Sourcing module to see all the menu items that are available. Then click on the Procurement categories menu item within the Vendors menu group.


Alternatively, you can search for the Procurement categories form by clicking on the search icon in the header of the form (or press ALT+G) and then type in procurement cate into the search box. Then you will be able to select the Procurement categories maintenance form from the dropdown list.


This will open the Procurement categories maintenance form. Here we will see that we have several categories already configured.


Within the Procurement categories maintenance form select the top-level node of your Categories and then open up the Vendor evaluation criteria groups tab within the detail area. Here we will see that there are no evaluation criteria associated with this procurement node.

To associate your Vendor Evaluation criteria groups, click on the Add button in the tabs menu bar.


Select all the Evaluation Criteria Groups that you want the vendors to be measured on, and click on the -> button to add them to the selection box.


After we have done that we can just click on the OK button to return to the main form.


When we return to the Vendor Evaluation Criteria Groups we will be able to see the groups are associated with the procurement category.


Now we will want to associate the vendors that we want to evaluate at this procurement category.

To do this open the Vendors tab within the detail panel and click on the Add button within the tabs menu bar.


This will open an Add vendor dialog panel where we will be able to see all the vendors that we can add to this node.


All we need to do here is select all the vendors that you want to include in the evaluations, and click on the -> button.


This will add the vendors to the procurement category.

When you are finished, just click on the OK button to return to the main form.


You can continue this process for any of the leaf nodes in the Procurement Hierarchy.


Recording Vendor Evaluations

Once the evaluation criteria have been configured, you can start recording the vendor ratings.

In this example, we will show you how you can add Evaluation Ratings to your Vendors.

How to do it…

To do this, return to the Procurement Categories form, select the Procurement category that we have associated the vendors to.

Then select the vendor that you want to record the evaluations against and click on the Evaluations button within the tabs menu bar.


This will open the Vendor evaluation maintenance form with all the Evaluation Criteria Groups listed on the left, and all the Evaluation Criteria for that group on the right.


To update any of the vendor ratings, just select the rating for the criteria that you want to update and select the rating that you would like to apply.


Continue this process for all the evaluation criteria that you want to report on.


Repeat this for all the Criteria Evaluation Groups.

Notice that the Average Rating for the Evaluation Criteria Group will change as you enter in the results.

Once we have finished, we can just exit out of the form.


Conclusion

The Vendor Evaluation Criteria is a little hidden gem within Dynamics 365 for Operations. It allows you to start recording subjective ratings against the vendors and track the overall rating for the vendor based on performance.


There are times where you want to create alerts or notifications triggered off the data within Dynamics 365 for Operations. There are a number of different ways that you can do this, but one of the simplest ways to do this is through Flow which allows you to create simple integration points that trigger other events that you may want to chain off the data. All of this can be done without even having to resort to a single line of code, and also without touching the base Dynamics 365 for Operations functionality.

In this walkthrough we will show an example of how you can take advantage of Flow to create a simple email alert that is triggered off the creation of a new customer within the system.

Topics Covered

  • Create a new Entity within the Common Data Service
  • Creating a Flow to Add Operations Customers to the Customer Accounts Entity
  • Submitting the Flow to the Template Gallery
  • Viewing the Customer Accounts Entity Data
  • Creating an Email Notification Flow triggered on New Customers Being Added
  • Seeing it in Action

Read More

Recently I came across a problem where I realized that all of the e-mail addresses within my system were incorrect. The default email addresses that come with the demo environment are @contoso.com, and my demo tenant has the domain name of @contosoeastfoxtrot.onmicrosoft.com.

I wanted to change them all so that when I try to skype any of the other employees in the demo system, that all of them would work. I could have been minimalistic and just change one of the users, but if you are going to do a job, then you should do it right.

But editing each of the 500+ user accounts seemed a little bit daunting,

Luckily Dynamics 365 for Operations allows me to update the database through Excel, and if there isn’t a default template that I can get my hands on right away, that’s not a problem because we can make a new one on the fly.

In this article we will show how you can do this and make updating mass amounts of data a breeze.

How to do it…

So here is the problem – I don’t want to open up each and every worker record in order to make a quick change to their email account.


So we will want to create an Excel template that allows us to perform a mass update.

To do this open up the Organization administration menu and click on the Excel workbook designer menu item within the Office Integration menu group.


This will open up the Excel workbook designer utility and we will be able to see all of the different entities that we can create templates for.


To find the right entity we can just filter them out by typing in a search term into the filter box. The contact information is associated with the Party entities so we just type in party and we will be able to find the PartyContact entity which stores all of the phone numbers and email addresses for the contacts.


We will just select all of the fields from the Available fields list and put them in the Selected fields column.


Then all we need to do is click on the Create workbook link within the menu bar. This will allow us to choose where we want to save the file. For this example we will just create a local copy and select the Download option.


Within a couple of seconds Excel will open and we will see all of the fields that we selected from the entity. To make this live we just need to click on the Enable Editing button.


Next thing you know we will have access to all of the contact information that is stored within Dynamics. Since this is Excel we can just do a global search and replace for the domain name that we want to change and after updating the records within Excel we can click on the Publish link in the Microsoft Dynamics Excel Connector panel and all of the changed records will be pushed back to the Dynamics system.


Review

This is a super useful tool to have in your back pocket. There are always times that you want to make mass updates to data within Dynamics and being able to have a direct link through Excel is a great way to do this. You can save a lot of time, and also reduce your chances of getting an RSI through repetitive updates to records.

How cool is that!


As we have started to upgrade all of the Bare Cones Configuration Guide series to Dynamics 365 for Operations, we forgot that you all might want to know how to deploy out a new training environment through Lifecycle Service so that you can start this new journey of learning as well.

So as a result we sat down and created that guide just for you all. If you want to check it out here are all of the details.

BBCG.01.01.D365.1.D: Configuring a new Dynamics 365 for Operations Training Environment
Module 1: Creating a new Environment through Lifecycle Services

Creating a new demonstration or training environment for Dynamics 365 for Operations depends on you having an Office 365 tenant for authentication, and also for managing users etc.

Once you have your new Office 365 tenant you can then access Lifecycle Services, create a Dynamics 365 project and then deploy out a new Dynamics 365 for Operations environment that is linked to your Azure account.

In this walkthrough we will show you how to do this so that you can start your demonstration and training environments out the right way.

Topics Covered

  • Creating a new Lifecycle Services project
  • Link your Azure Subscription
  • Deploying a Dynamics 365 Environment
  • Logging into Dynamics 365 for Operations

If you are interesting in checking this guide out then here is the link to the digital version of the guide: http://bit.ly/2gMcZmU

If you are a premium subscriber then remember, you can download this guide for free.

Additionally, we have made this guide available as a PowerPoint which the industrious ones of this group can use as the basis for your own training and education programs. The PowerPoint version contains the same content as the guide except you can edit any of the content and also update any of the formatting to private brand it to your own organization.

To check out the PowerPoint version of the training guide, then click on this link: http://bit.ly/2gbEGoa

If you want to see all of the guides that show you how to set up a training environment for Dynamics 365 for Operations, and also Dynamics AX 2012 then just click here and you will be taken to the resource page with all of the different content including sample data to help you with the project: http://bit.ly/2gK4nzC

If you are really up for a challenge then you may want to take on the Bare Bones Configuration Challenge. You can start with this guide and as we start releasing out the other 15 guides in the series then you can work through them as well. These guides will teach you how to configure a bare bones installation of Microsoft Dynamics 365 from scratch. If you complete all sixteen modules then you will become a Bare Bones Configuration Privateer and we will send you a badge to prove it.

If you want all of the content on the site and all of the new content that we are delivering then you may want to think about signing up for a Premium Membership. Once you have that you can plunder the entire site and download any of the books at any time. Here is the link: http://bit.ly/2fYMgTW

Watch out for use to release more modules as we get them finished over the next weeks.