{Quick Tip} Why is my workflow not showing up in Workflow Profiler in Plugin Registration Tool

Why is my workflow not showing up in Workflow Profiler in Plugin Registration Tool

Recently I was conducting a training where I was demoing on how to debug a Custom Workflow activity step using the profiler in plugin registration tool. So here I was explaining to them to first click on “Profile Workflow” button on the plugin registration tool. For starters, here it is in the screenshot below



And as I said – “Select your workflow”, I suddenly see a hand raised informing me that he is not able to view the workflow created by him.

Verified with all other’s and they are able to see the their respective workflows.

I just thought – “Must be some silly error.” But I was soon to be proved wrong.

Situations like this could be tough when asked all of a sudden. But my memory didn’t reach came to my rescue this time. I realized that while playing with the workflow, he has changed the owner of the workflow to someone else. And hence the workflow is not showing up in the workflow profiler.

So remember, if you are profiling a workflow, make sure the user with whom you have logged in to Plugin Registration Tool and the the owner of the workflow, should be the same person. Otherwise the workflow won’t simply appear in the ‘Profile Workflow’ list.

Hope this helps and saves you some time before you waste couple of hours in this.

-Debajit Dutta (Dynamics MVP)

For corporate training/ consulting, visit www.xrmforyou.com or write to us at info@xrmforyou.com


Published at Wed, 11 Apr 2018 04:58:37 +0000

[unable to retrieve full-text content]

Published at

Dynamics 365 Security tips – Can a user work with only team roles in Dynamics 365

Can a user work with only team roles in Dynamics 365

Recently I was conducting a training in Dynamics 365 where I got the same question. Just a quick thought and the answer that comes to mind is “Yes”. After all,

a user’s security role is the sum of the security roles directly assigned to the user + sum of the roles the user derives through it’s association with the Teams (provided teams are given security role)

And here I was, where a user is belonging to a team and the team has a security with all the right privileges assigned to make the user work in Dynamics.

When I assigned the role directly to the user and the user is not part of the team, it just worked fine. Now comes the other way round. I remove the user’s security role, assign the same security role to a team and add the user to the team.


As you can see, the security role is having pretty much everything to access this account.

Login screen below after the user logged in.


Looks awesome isn’t it. The user can see accounts as expected. Just when you think that you have won the hearts of participants heart with your awesome understanding of Dynamics, Dynamics would throw a stick or two at you.

So I clicked on Account and this is what I get below.


That facepalm moment where you are just thinking, what just happened?

Now time for some recovery. When I click on Advanced find and try to access accounts, I could see them just fine.


You can even create/ read/ write and do all the fancy stuffs as per the role privilege.

Now I just did this trick. I just created a dummy role with absolutely no privilege to any entity and added it to the user. And this time when I click on Sales –> accounts, it just works fine.

So next time when you are up to this, this can save you some awkward moments. Not sure if this a bug or expected behavior but it seems the problem is only with the Home Page grid. Even if I try to read/ write accounts with the user credentials programmatically using SDK.

For the home page grid to work, it requires a role to be assigned directly to the user.

Debajit Dutta (Dynamics MVP)


Dynamics 365 Tip Hiding Navigation Pane in forms exposed on Mobile (including Owner relationship)

Hiding Navigation Pane in forms exposed on Mobile (including Owner relationship)

Dynamics have evolved over the years and with time it has become a really vast tool. So many features are in there that we may not have used till now in all our projects. They are there though, sitting quietly and can do some pretty cool stuffs. But you remember them when you need them the most. Once such scenario, I am going to describe here.

So here I was working for a customer who wants to expose their CRM on mobile. We created separate forms for mobile, light-weight than the web versions and exposed them on mobile. However with the mobile real-estate being really less, customer wanted the navigation options to be hidden.

So it started, developers removed all the links in the navigation pane using form editor. And published the form.

Wouldn’t it be perfect. It should just work right. Sadly no. You may end up removing all but the nagging owner relationship (for user owned entities). And in mobile, it would just occupy the first tab.


Well, it won’t go, no matter how much hard you try, until you go to the Form Properties –> Display Tab –> Uncheck “Show Navigation”


Save and publish the form. And voila, it just works!

Hope this helps

Debajit Dutta (Dynamics MVP)

Error The user does not have read permissions to a secured field. while configuring Field Security

Error while configuring Field Security – The user does not have read permissions to a secured field.

Dynamics CRM never ceases to throw surprises to me and this even applies to the functionalities which were introduced way back in CRM 2011.

Recently in a session I was demoing field security and strangely one participant informed me that he is getting the below error while setting the field security profile for a user.


Cross checked whether he enabled field security for the field. And it was obvious he was doing with admin login. And strangely enough the error says “the user does have read permissions to the secured field”. Downloaded the error log but that didn’t help much as well.


This put me in a situation. Don’t know where to look into.

Suddenly I just published the entity again in frustration and after that when I tried, the error was gone. As it turned if you don’t publish the entity after enabling field security for a field and try to configure profile for the field, you get this error.

Publish is obvious but this kind of error message can throw you completely in a wrong direction.

Hope this tip may save you from some time and awkward moments.

-Debajit Dutta (Dynamics MVP)


Addons – Microsoft Dynamics 365

Addons – Microsoft Dynamics 365

PowerObjects PowerPack add-on, PowerGrid, enables users to consolidate their editing processes by selecting an entity and a pre-defined view from that entity, system or personal, and edit those records from the grid without needing to open each individual record.

One great feature of PowerGrid, is the ability to configure colors within the selected list view for an entity. This feature can be used to increase user readability and consequently boost productivity for users who use the system in their day-to-day work. Using the Express Configuration, a user or administrator can configure color-coding for certain criteria.

Below is an example list of tasks that are auto-generated for a specific case. The tasks are performed by different roles that manage the case. Each role is a different color with the past due tasks showing in red.


You configure the color-coding directly within PowerGrid by using the Express Configuration.


This configuration option is aimed at making the user’s work easier and more manageable by being easy on the eye and helping teams stay organized.

My favorite features from July 2017 update of Microsoft Dynamics 365 For Finance and Operations – Enterprise Edition

My favorite features from July 2017 update of Microsoft Dynamics 365 For Finance and Operations – Enterprise Edition

One of the most awaited releases of Dynamics 365 For Finance and Operations is now available (The July 2017 and Platform Update 8). Lot of new capabilities and exciting new features across all the functional modules and quite a few technology stack improvements!!In this post, I will highlight some of the most important new features that are my favorites so far, that I think are going to helpful for customers in big time.

First thing first! Starting with the July release, there is a change in the naming of the Dynamics 365 apps . Earlier we had “Dynamics 365 For Operations”, which basically represented the Enterprise edition of Dynamics 365 and “Dynamics 365 For Financials’ which represented the Business edition targeted for SMB customers.

Starting with the July release, the naming will be as below.

Dynamics 365 For Operations => Dynamics 365 For Finance and Operations – Enterprise Edition (For Enterprise Customers)

Dynamics 365 For Financials => Dynamics 365 For Finance and Operations – Business Edition  (Suitable For SMB Customers)

You should notice this name changes, when you login to the new version.

Default Landing Page

Here are some of my personal favorite features and functionality fro this latest update of Dynamics 365 For Finance and Operations.

Embedded PowerBI and Analytical Workspaces for all D365FO licensed users:

Microsoft Power BI is the backbone of Dynamics 365 for delivering critical business intelligence to all users of an organization with rich interactive visuals, dashboards and reports, with appropriate drill downs, data filter options etc. When Dynamics 365 was first released, users had the option of consuming preconfigured or customized Power BI dashboards and reports from their PowerBI online workspaces right into their workspaces within Dynamics 365. This is a great capability and allowed users to mash up data from Dynamics 365 or even from external data sources and then see them all together right on their workspaces. However, this required every users to have at least a free PowerBI.com subscription to be able to do this.

With the July 2017 update, Power BI Embedded services are integrated into Dynamics 365. Embedded Power BI is a Microsoft Azure Service that allows to embed the dashboards and reports directly into Operations workspaces of Dynamics 365. Embedded Power BI is an ideal way of presenting near real time data insights, with Direct Query to the Entity Story (Data warehouse for Dynamics 365). These embedded dashboards and reports are available for all users with the base license of Dynamics 365 for Finance and Operations and does not necessarily require the user to have a PowerBI.com subscription.

The diagram below shows the key difference between the PowerBI Online and PowerBI Embedded services.


The good news is, Microsoft has already shipped several out of the box PowerBI asset files within Life Cycle Service starting with the July 2017 release, which can be simply included in the Dynamics 365 deployment options to get instant access to readily available dashboards and reports across all major business areas. Below are some of the sample examples of these embedded Power BI dashboards and workspaces in Dynamics 365.

This slideshow requires JavaScript.

Prospect to Cash Integration between Dynamics 365 for Sales and Dynamics 365 for Finance and Operations using Common Data Services:

This one is a HUGE step forward!! Since Dynamics 365 launched back in February 2016, the Primary objective and goal for Microsoft was to combine the best of Dynamics CRM and ERP worlds and provide a unified experience to end users, so that they can advantage of best of breed functionalities within the Modular apps for Sales and Financials & Operations and still be able to integrate the data flow between these apps seamlessly to get a 360 degree view of their business. We have seen steps Microsoft has taken in last several months to get the Common Data Service (Azure Public Cloud data storage) Platform ready for prime time along with the supporting surrounding services such as Microsoft Flow and PowerApps. With the July release, these all are coming together as a first significant step towards truly unifying the CRM and ERP worlds. This is the beginning of the departure from the traditional custom 3rd party integrations between CRM and ERP.

The following key scenarios are supported currently with this integrations, primarily in the Supply Chain side. More to come in future. I have not got chance to test this end to end yet. Will share some details when I am able to test it in coming weeks.

  • Maintain accounts in Dynamics 365 for Sales and sync them to Finance and Operations as customers.
  • Maintain contacts in Dynamics 365 for Sales and sync them to Finance and Operations.
  • Maintain products in Finance and Operations and sync them to Dynamics 365 for Sales.
  • Create quotes in Dynamics 365 for Sales and sync them to Finance and Operations.
  • Generate sales orders in Dynamics 365 for Sales for existing products and sync them to Finance and Operations.
  • Generate invoices in Finance and Operations and sync them to Dynamics 365 for Sales.

Mobile Apps/Workspaces:

Mobile workspaces/apps were introduced with the Update 3 release of Dynamics 365. Since then, these workspaces have been evolving and Microsoft continues to deliver more and more mobile workspaces covering various mobile business process scenarios. Some of the key mobile workspaces that were released in the July 2017 update are as below.

This slideshow requires JavaScript.

The highlight of these workspaces is the mobile app for Project Timesheet Entry and the Expense Management app. I provided my views on the preview version of these mobile workspaces in my earlier post. These workspaces have added significant amount of new features with the July 2017 release. The Expense management workspace now support end to end expense management from receipt capture, new expense report creation, submission, expense approvals and expense status inquiry and so on. Below are some screenshots of the mobile workspaces released in the July Update.

Employee Expenses Management and Reimbursement related enhancements:

There are several new features and usability enhancements that are introduced for Employee Expenses management in the July Update. From all these features and enhancement, my favorites are as below.

  • Dedicated Expense management workspace

Expense Workspace

  • Grouping of vendor invoices for different expense lines of an expense report, as opposed to create separate vendor invoices for each expense line, for reimbursement. This was one of the most talked about concerns in the earlier version (AX 2012), since it was causing problems creating individual invoices for each expense lines and there by causing issues in Check printing etc. Now with this release, you can optionally group all expense lines with the same method of payment to post as grouped vendor invoice instead of individual invoices. If you enable the grouping of vendor invoices, this functionality basically posts all the expenses of the expense report with same payment method on the recent transaction date from the list of expense lines.
  • Several usability enhancements in some key screens. Also, Employees can now track payment information for their expense reimbursements. Nice and very useful functionality, as this is one point that customers usually ask and they used to customize it in AX 2012.

This slideshow requires JavaScript.

OCR interface for capturing vendor invoices automatically:

One of the most common asks from customers in the AP invoicing area is the functionality of OCR and vendor invoice automation. Organizations often offload the paper invoice processing to 3rd party OCR reader service providers. These service providers provide machine readable metadata for the invoice along with scanned imaged the invoice headers and lines. In the July 2017 release, the solution/standard interface to read these invoice metadata and invoice scanned attachments is in-built into the AP invoice process of Dynamics 365. 3rd party OCR service provider systems will be able to send metadata feed for invoices directly to D365FO.

This new functionality basically provides the following.

  • Out of the data entities invoice header, invoice lines, and invoice attachments.
  • Exception processing for invoices. A frontend UI for users to make it easy to track failed invoice imports.
  • A side by side invoice attachment viewer to imported invoices and exceptions.

Vendor Invoice

PowerBI reporting with Financial Dimensions:

This feature will be available with July 2017 Update and you will also need to have the most recent Platform update of Dynamics 365, which is Platform Update 8. This features let’s the power users or the BI report creators to add financials dimensions to the readily available aggregated measurements or custom built aggregated measurements in the Entity store.

With that, when the Entity store is periodically updated/refreshed, the financial dimension information of all the General ledger transactions will automatically be included in it. Then you can use those aggregated measurements to write joins, queries within Power BI to create any sort of financial report/dashboard within Power BI itself. Screenshot below shows just an example.

Publish financial reports from Dynamics 365 to SharePoint:

In the earlier versions/releases, you could generate financials reports and export/save it to your local computer. With the July 2017 release, you can now save financial reports directly to a SharePoint document library. The benefit of this is, you can setup alerts within SharePoint to notify you when new reports are available.

Note: I don’t have SharePoint configured in the demo environment, so not able to show the full experience.

FInancials Statement to Sharepoint

You could also extend this further and write a Microsoft Flow, to automatically send the reports directly to your inbox from SharePoint. Endless possibilities !!

Tools for upgrade from AX 2012 or AX 2009 to Dynamics 365:

You can upgrade from Dynamics AX 2012 to Dynamics 365 for Finance and Operations, Enterprise edition. The complete Dynamics AX 2012 database can be brought forward, and your AX 2012 codebase can be upgraded to Finance and Operations. You can migrate from Dynamics AX 2009 to Finance and Operations via a migration toolset to bring forward master data and opening balances. It would be interesting to test these upgrade experiences and tools as opportunity comes !! 

The Upgrade is now more predictable, which reduces the overall cost of the upgrade process. Upgrade starts with an automated analysis phase, which defines the preparation tasks required to reduce the time and cost to upgrade, as well as the ongoing future cost of Finance and Operations. Post upgrade, an automated validation phase provides statistics and metrics on the success of the upgrade process. The validation details can be used to quickly assess the state of the upgrade, so you can continue with functional testing and sign off.

In Finance and Operations there are no expensive upgrades needed to stay current and take advantage of continuous innovation. You can update to the latest versions of the product with a click of a button.

Support for Hybrid Cloud (Cloud + Edge) and Op-premise (Local Business Data) Deployment scenarios:

In one of my earlier posts, I explained some details about the 3 different deployment options that Dynamics 365 is going to provide. Starting with the July 2017 Update, both these deployment options are available. Customers who are keen on having an On-premise deployment of Dynamics 365 for Finance and Operations to capitalize on their existing infrastructure investments or due to data security and compliance requirements, will have the option to deploy D365FO in Hybrid as well as On-Premise model.


Microsoft published system requirements documentation explaining the detailed system requirements for an On-premise deployment of D365FO. You can find the information at this URL

There was system requirements document also that Microsoft published. See URL below.


I will share more info about this in future as we move with some testing and some actual deployments for customers.

That was a long enough post :). There are several other features and functionalities across technology stack, Retail and manufacturing modules, that I have not highlighted here in this post. There is a lot to explore and learn!!!

Stay tuned and stay current !! Till next time..

Regards, Sandeep

Published at Mon, 17 Jul 2017 07:08:27 +0000

[unable to retrieve full-text content]

Published at

Advanced Vendor Collaboration and Vendor Onboarding in Dynamics 365 For Finance and Operations, Enterprise edition

Advanced Vendor Collaboration and Vendor Onboarding in Dynamics 365 For Finance and Operations, Enterprise edition

Hello Everyone,

It has been quite sometime i have not written here. Last few months were very busy with several things and that did not allow any time to spend on blogging. I finally managed to get some time here!!

In one of my earlier posts, I elaborated some of the functionalities of the Vendor collaboration/Vendor self-service feature of Microsoft Dynamics 365 for Finance and Operations – Enterprise Edition and what was coming in future releases. With the Fall release (Version 7.3), Dynamics 365 for Finance and Operations has much more to offer to automate vendor self-service and collaboration, specifically around the vendor user and organization onboarding aspects.

In this post, lets take a look at some of those new features, specifically in the vendor onboarding area.

The diagram  below shows an overall representation of how the data flows from a Prospective Vendor to an Approved vendor in D365FO.

Vendor Onboarding

Let’s now dig into some of the finer details of the processes and steps underneath each of these steps in the vendor onboarding process.

ProspectiveVendor shows interest to become a potential vendor: Before an organization or individual wants to become a vendor for your organization, they are referred as “Prospective Vendors”. They can apply to be a vendor for your organization either via a website you may have, with anonymous access, or they can apply via a contact at your organization. If they come in through your website, you can have an OData integration with D365FO, to send the prospective vendor’s data into D365FO. Alternately, you can also use Data Management Framework to import the prospective vendor data periodically into D365FO.

Prospective Vendors DMF Upload

Prospective Vendors Import

After the initial basic data for the perspective vendor comes into D365, it will appear in Prospective Vendors registration under Procurement & Sourcing > Vendor collaboration requests.

Prospective Vendor User requests

Procurement Personnel from your organization reviews the details and initiates the vendor invitation process:

Before a procurement personnel from your organization reviews these requests to initiate the vendor invitation process, lets take a look at the workflow that is set up behind the scenes to do all the heavy lifting.

Under System Administration > Workflow > User Workflows, you can set up workflows for adding, modifying or inactivation of a new prospective vendor/existing vendor user. For a new prospective vendor user, the workflow provides your various options to fully control the new user provisioning in Azure AD and new user creation in D365FO.

Take a look at the screenshot below which shows this workflow.

User request workflow Create

Vendor User request workflowTo initiate the invitation process for the new prospective vendor, the procurement personnel will select the required user and review the details. If they decide to proceed with initiating the invitation process, they click the Invite User button.

At this point, the Processing status of the vendor registration request changes to “User requested“. This means a request for setting up a new user account in Azure AD and in D365FO has been initiated in the workflow.

Invite Vendor User

As soon as the user creation request is creation, the personnel setup in the workflow for this will get notified and will process the request further. If you notice the screenshot of the workflow above, the first step in our workflow is to review and approve the user request even before the Azure AD and D365FO user accounts are created.

The Personnel responsible goes into the user request and reviews the details to approve it.

Approve User request

The next step in the workflow is to set up the B2B user account in Azure AD. You can use the manual task within the workflow and assign it to the required person, who then can download the external user setup CSV file for import within Azure AD.

Manually Export User Invitatio File

Alternately, you can use the automated task for provisioning the Azure AD B2B user account.If you chose to use the automated task, you need to make sure to complete the below setups.

  • Register the D365FO app within Azure AD in Azure portal.
  • Complete the required setup for the API permissions for Microsoft Graph for the D365FO app. The automated task of the user setup workflow will invoke this to provision the user account in Azure AD.
  • Setup the Client ID, Application Keys within D365FO B2B invitation configuration page of D365FO.

App Registration

With the above setup done, the automated task will provision the Azure AD user for the vendor user automatically. In the next step of the user setup workflow, you can set up automated tasks for provisioning the user account within D365FO and also send the email notification to the vendor with a URL link to D365 for signup and registration. You can set up an email template and use (%portalURL%) placeholder in the email message, which will automatically include the URL of D365FO, when it sends the email notification to the vendor.

In this demo, the prospective vendor i added was John Smith whose email id was schaudhury@velosio.com. Since i had done all the setups above, ( (John Smith, the vendor) got the email notification with a URL for sign up.

Email Invite

Prospective vendor signs up to D365 and completes registration Wizard:

Now, it is time for the prospective vendor to sign up and complete the registration wizard and provide additional information about their organization.

When the vendor logs in to D365 by clicking the URL in the email invite, they are directly taken to a registration wizard, which appears as shown in screenshot below.

John Smith Vendor logs in to Portal for registration

The vendor selects the Country/region first in which they operate in. In this case , i selected USA.

Vendor Selects Country

On the next few screens, vendor enters their business information and all necessary details as shown in screenshots below.

Vendor Enters their information

Vendor Enters more info about contact person

Vendor Enters business information6

You can also configure and assign predefined questionnaire and assign it to the vendor to answer and you also let them select procurement catalog.

New Vendor request created in D365 for review and approval:When done, the vendor submits all the information at the end of the wizard. Registration submitted

This create the new vendor request in D365FO, which will then be reviewed and approved by a procurement or AP person of your organization. Procurement personnel can navigate to Procurement and Sourcing > Vendor collaboration > Vendor requests to see these.

New Vendor Request Created

New Vendor Details

New Vendor Details1

New vendor details reviewed and approved:

The Procurement personnel then completes the review process of the new vendor request and upon confirmation, the new vendor record is automatically setup in the Vendor master. After that, the vendor can have full access to the vendor collaboration portal and they can communicate with your organization in real time on purchase orders, invoices, consignment inventory, RFQs and responses, bidding and more.

vendor Review completed

That essentially completes the overall vendor onboarding process in D365FO. Stay tuned for more on this.



Published at Fri, 16 Mar 2018 02:11:21 +0000

Take advantage of configuration data templates for seamless data import and export management in your Dynamics 365 For finance and operations implementation

The Data Management Framework of Dynamics 365 For Finance and Operations – Enterprise Edition provides advanced data management capabilities, which makes the overall data export and import really seamless easy, for both standard Dynamics 365 data entities, as well as any custom entities that you might have developed for your business requirements. This framework provides an easy to use front end interface for data export and import management, so that regular pro-users of Dynamics 365 can interact with it, without requiring advanced knowledge of development and database.

In this post today, let us discuss about one of the features of this Data Management framework called the “Data Templates“, which will help you accelerate the data configuration and export/import management in your Dynamics 365 Implementation.

Data Config Templates

So, what are these data configuration templates ? One of the things you would have always done in every D365FO (Dynamics AX earlier) implementation, is probably use an excel spreadsheet to keep track of setup and master data configuration checklist and their sequence of import. While this works, it also requires extensive manual tracking, supervision and may lead to lot of human errors and mistakes.

Data configuration templates in D365FO are basically a predefined list of data entities for each module area, which are sequenced , so the data import will be processed in correct order automatically. This reduces human error in the data import sequence, save a huge amount of time in data import/export.

The templates are sequenced using Units, levels and sequence numbers and predefined dependencies between data entities. For example, before you import/upload your customer master data, you need to make sure all the number sequences formats, customer groups, payment terms etc. are imported prior to that. The data configuration templates addresses this and takes care of sequencing.

Let us now understand what is underneath these data templates and how these are managed in D365FO.

  • Microsoft started releasing these predefined data templates with the July 2017 update and these are right now made available directly within D365FO. From home page of D365FO, Navigate to System Administration > Data Management Workspace > Click Templates tile and click the Load default templates button. This will load all the default templates which are made available by Microsoft.

Load Default Templates

Note: In future, these will be made available in the shared asset library of LCS(Lifecycle Services), just like other assets such as the Power BI report models, Software deployable packages etc. 

  • You can use these out of the box templates, modify them to meet your business requirement, or you can even create your own templates and define the entities under it. For example you might have customized D365FO to meet your business needs and you might have created various custom data entities for this. So you can create your own templates and include those entities.

Custom Data Template

  • How are these entities sequences within a data template for processing? The “Execution unit”, “Level in execution unit” and “Sequence” fields under the Entities tab of the templates defines how the entities are sequences for processing.
    • Execution Unit: Entities that have different units are processed in parallel.
    • Level in execution unit: Entities that have the same level within an unit are processed in parallel.
    • Sequence number: With the same level, entities are processed according to their sequence numbers.

Note: At some point in future, Microsoft will make it possible for the sequencing to happen automatically when you add entities to a template and will they will try to provide templates for every standard D365FO configuration and setup.

Unit Level and Sequence Numbers

  • The Module, category and Tags represent the entity category or classification for better understanding. Module represents the actual module name of D365 to which the entity belongs, Entity category shows if the entity is related to setup data, reference data or master data and the tags shows additional information tags.

Module Tag And Category

  • There are other miscellaneous features on this templates so that you can export and import templates, Open the list of entities within a data template in Excel to make changes to Units, levels, sequences, module, tag etc., or you can even create the templates from a data project.

Other Misc Features

Now, let us see how we can use these data templates (Predefined or custom created) in an actual Data project for export or import.

  • Navigate to System Administration > Data Management > Click Import tile.

Demo Template Import Data Project

  • Enter a name for the project and click Save. Now click “Apply Template” button. You will see all your data templates that you can select and add them to the data project. You can add more than one data template. Let us say I want to use the GL-Shared data template to load all the data for the GL shared area. I can select that and select preferred source type (EXCEL, CSV etc.) and click OK button.

Select Data Template on Data Project

  • Notice here that all the data entities that were part of the General Ledger-Shared data template are automatically loaded and all the level and sequencing of these entities is also inherited from the template setup. Now, you can just upload the excel/source data files for all these entities and schedule the data project to run. It will run and automatically process the entities in the correct sequence as per the definition in the template.

This is certainly a huge time saver and you don’t have to select individual entities and import them one by one remembering their sequence.

Data Entities loaded in DP

  • Similarly, you can use the templates for exporting too, so that system will automatically provide all the source files for each module, depending on the data template you selected in the project.

Export Using Template

  • As an example, I have exported the same GL Shared template in a data project and it exported all my relevant data entities with more than 500 records within few seconds.

Data Entities Exported

  • I can now download these packages and see the data on the files. See screenshot below.

Data Package Export

Exported Data.png

I find this feature very useful and this will help save significant time in data export/import and will also enable users who are not experts of the system to seamlessly export and import data for all required modules by leveraging these templates. This is also a great step towards standardizing data configs as much as possible, so that customers don’t have to reinvent the wheel in every implementation.

That’s it for this post. Stay tuned !!

Sandeep Chaudhury

Published at Sun, 05 Nov 2017 02:19:57 +0000

Using Color in PowerGrid to Improve User Experience and Productivity (Custom Grid on Dynamics365)

Using Color in PowerGrid to Improve User Experience and Productivity

PowerObjects PowerPack add-on, PowerGrid, enables users to consolidate their editing processes by selecting an entity and a pre-defined view from that entity, system or personal, and edit those records from the grid without needing to open each individual record.

One great feature of PowerGrid, is the ability to configure colors within the selected list view for an entity. This feature can be used to increase user readability and consequently boost productivity for users who use the system in their day-to-day work. Using the Express Configuration, a user or administrator can configure color-coding for certain criteria.

Below is an example list of tasks that are auto-generated for a specific case. The tasks are performed by different roles that manage the case. Each role is a different color with the past due tasks showing in red.


You configure the color-coding directly within PowerGrid by using the Express Configuration.


This configuration option is aimed at making the user’s work easier and more manageable by being easy on the eye and helping teams stay organized.

PowerGrid is a great add-on to extend the functionality of your CRM system. Start a free 30-day trial today!




What Is Microsoft Dynamics 365 ?

Microsoft Dynamics 365 combines two categories of solutions


Dynamics 365 CRM & ERP

Customer relationship management (CRM) is what you need for your daily business operations. Customer information databases and sales team tools, along with service and marketing automation tools are all parts of a standard CRM solution. Any tool meant for facilitating interactions with customers and growing sales falls into this category.

Enterprise resource management (ERP) solutions are tools that help you to keep track of financial data, along with powerful tools for accounting, field service tracking, and project resource management. ERP tools allow established businesses and larger organizations to manage extensive networks of resources and information in real time.

Dynamics 365 unifies your CRM and ERP business solutions

Dynamics 365 gives your team the tools to take in new clients efficiently, to maintain existing relationships, and to cut down on time wasted jumping between different platforms to find the right information to empower every member of your team.

Breaking ground with the Dynamics 365 Business

Made for small and medium sized businesses

Dynamics 365 Business Plan

The Dynamics 365Business Plan offers a focused CRM solution with financial tools at an affordable price. You get all the great functionality of the Dynamics 365 Financials, Sales, and CRM solutions that you need to keep your business running smoothly. Do you run a business that needs Dynamics 365 Field Services? With Dynamics 365 you’re not locked into a year-long billing cycle, as you are with traditional CRM solutions. That means that you can try out solutions you’re interested in with the flexibility of a monthly billing cycle.

*Until Spring 2017, the business plan gives you all the features of Dynamics 365 Sales and Customer service enterprise at a price model that fits the budget of a growing SMB.

Learn more about Dynamics 365 Pricing for SMB >


Setting your foundation with the Dynamics 365 Enterprise

Made for companies looking for advanced service solutions

The Enterprise Plan provides all of the most advanced business solutions Microsoft has to offer. With standard CRM software, full field service, and marketing tool integration, you can take any client or lead and draw all the available information from the start of that customer relationship to the most up-to-date software.

With all customer information available to you in one seamless experience you’ll be able to shorten down time among all your teams. Marketing can populate information about clients and provide a wide range of statistics, thus giving your sales team the focus to sell the right product to the right people without wasting time.

This plan lets you view and control your resources as you would with a traditional ERP solution, and it also gives you powerful CRM tools to keep your team up-to-date.

Dynamics 365 Sales aka the New Dynamics CRM Online

Your customers are increasingly educated about the products and services they need. Because they have nearly 57% of the decision-making process done before they ever talk to a provider, you need to cut down on the time your sales team spends getting the relevant info for the next deal.

This allows you to manage and prioritize your leads so you can push the right cases to your sales team. They will be able to view important details, such as the strength of your relationship with each customer and how they interact with you. Sales will be able to take this info and tailor their interactions to your customer base.

Your sales team’s job is to sell, not waste time dealing with a cumbersome service platform. Give them Dynamics 365 and they’ll have the tools to build meaningful profiles and real relationships with your customers.

YouTube Preview Image

Dynamics 365 Field Service

A single bad experience can push a customer away from your brand, not only hurting your image but also creating the risk of losing that customer. That’s why it’s important to empower your team to be flexible at every step of the client’s relationship. Dynamics 365 Field Services give them the tools to control every aspect of that relationship.

Dynamics 365 Field Service Connectivity and Mobility

You’ll be able to schedule meetings manually or set up systems to do it automatically for your field agents and track them in real time as they go through their day. Have a client with an urgent case? You’ll be able to track down the closest field agent and get them to that client.

Because Dynamics 365 Field Services integrates your inventory and agreements, your agent won’t be going in a meeting blind. You and your agents will see in real time whether they have the right parts and whether they’re covered under your agreements.

Dynamics 365 Field Service Resources Management

Dynamics 365 Customer Service

Dynamics 365 Customer Service is your agent’s portal to a 360-degree view of your client’s information. You’ll be able to empower agents with a unified service platform so they can know, quickly and efficiently, the  exact needs of every client.

Dynamics 365 Customer Support Center

When interacting with your customers, context is everything; it sets the foundation for a great service experience. Customer service unifies your knowledge base and lets you pick the relevant data to display to your agents, while also giving them an easy way to add and contribute information themselves.
As customer information comes in, you’ll be able to use powerful, interactive visual tools to analyze trends in customer behavior, your client interaction, and your marketing presence.

Seamless Integration between Dynamics 365 & Office 365

Dynamics 365 connects to and seamlessly integrates with all other Microsoft Office 365 software, cutting through downtime and the hassle of integration. It integrates with Excel, Word, Outlook and more to instantly provide your team with the most relevant data.

Dynamics 365 Integrations

Image credit : https://www.randgroup.com/software/dynamics-365/ 


Whether you’re in the office or out on a call, accessing Dynamics 365 from your mobile device is just as easy as using the desktop app. Dynamics 365 and most other 365 programs are available in both the iOS and Android app stores or they can simply be accessed through your web browser.

Dynamics represents the evolution of CRM and ERP: In the cloud, on demand, customizable and flexible.

Error: Could not load type ‘Xrm.XrmServiceContext’

Problem Introduction

It is very often to see this error, especially when you are developing a custom app/website connecting to CRM using Portal Extension method or Simplified Connection.

And actually, I learn it from mistake, I realized my mistake, small mistake that making my example not working.

So here is the step to resolve:

Have you followed this step?

When I say ‘have you’, are you really really comfortable to say yes? Have you really-really followed the instruction?
Well, if you think you ‘have’, it is not your fault, because I also did the same thing.
Now, I still face the error…What should I do?

1. Are you using the correct framework?

If you are using CRM 2015, then you should use .NET 4.5.2.
For CRM 2013, you should use .NET 4.5
And for CRM 4.0 is .NET 4.0

2. Try to check whether you have inserted the generated code

Please check again in your Project, have you inserted the generated code you generated from CrmSvcUtil?

3. Check again your web.config and ContextTypeName (in the ASPX) vs CRMScvUtil Parameters

This is very important, because this was the root of failure I did not realize before.
Here, you need to check first the CrmSvcUtil..
In fact..I generate this:

CrmSvcUtil Parameters

CrmSvcUtil.exe /codeCustomization:"Microsoft.Xrm.Client.CodeGeneration.CodeCustomization,Microsoft.Xrm.Client.CodeGeneration" /url:"https://aileenexample.api.crm5.dynamics.com/XRMServices/2011/Organization.svc" /out:"XrmContext.cs" /username:admin@aileenexample.onmicrosoft.com /password:passwordme /namespace:Xrm /serviceContextName:"XrmContext"

You seem my parameter for serviceContextname is “XrmContext”, not the “XrmServiceContext”!!

While I check my web.config:


      <add name="Xrm" type="Xrm.XrmServiceContext, Xrm.CRM.2015.WebExample" />

And also I check my .ASPX code

<asp:LinqDataSource ID="Contacts" ContextTypeName="Xrm.XrmServiceContext" TableName="ContactSet" runat="server" />

Well, I use both in my code :


While, I generate the code using servicecontext parameter to this:


Of course, it wont be able to load the type.

Then, what I do is, I change my web.config and my ASPX from




Or you can re-generate the file and change the the /serviceContextName param from

“XrmContext” to “XrmServiceContext”

It is common mistake and sometimes is hard to realize!

Tips: Since you can have many changes in your CRM Metadata, you might need to re-generate your generated code very often, then I recommend you to consider the batch execution approach.

See this for detail:


Hope this saves your day!