Dynamics 365 Finance & Operations Monitoring and Telemetry using Application Insights

In this post I will share how we can setup the Monitoring and Telemetry using Application Insights for D365 Finance and Operations. (*This feature is in public preview in service update 10.0.30. The setup/behaviour may slightly change/improve by the time it is generally available.)

First lets cover basics of Application Insights from a very high level. Application insights falls under the category of  Application Performance Monitoring (APM) tools. It collects Metrics and application Telemetry data, which can be used to gain insights on application activities and health.

Below is a view of various azure monitoring tools and extensions available and application insights is one of them

Now coming to Microsoft Dynamics 365 Finance and Operations, this feature is a direct, point-to-point integration between an instance of a finance and operations app and the target Application Insights destination. Each application Insight resource has an “Identification Key” which uniquely identifies the resource in Azure portal. This is used in F&O configuration.

Below is step by step process to setup and enable it:

  • Login to Azure portal and create a new resource

  • Select resource of type “Application Insights”

  • Select the resource group and give it a name. It is recommended to have a proper naming convention for ease of use.
  • Once we select review + create and validation is complete, then it takes few minutes for the deployment to complete

  • Once the resource is deployed, copy the instrumentation key
  • Now open the Dynamics 365 F&O feature management workspace and enable the feature named “Monitoring and Telemetery”

  • Navigate to System Administration >> Setup >> Monitoring and telemetery parameters

  • This form has 3 tabs: Configure , Environments & Application Insights Registry. On the configure tab, we can select which types of telemetry we want to capture and send to application insights

  • On the Environments tab, we provide the environment ID and the environment mode . This can be found from LCS environment details page and is unique for each D365 F&O environment.

Copy the environment ID as shown below from LCS

  • Create a record in the environments tab page. This is a nice way to handle scenarios when databases are restored, this setup is preserved in non production environments.

Environment mode is important as the mode ties the environment with application insights in the next tab page. So if you want multiple environments to send the telemetry data to same application insights resource, then it is possible.

  • On the third tab we have to define the mode and link it with the instrumentation key which we copied from the azure portal after creating the rescource.

Now it’s time for action. In my case it took some time for the initial telemetry feed to reflect in the portal but it did captured good information form the environment.

Further analysis and custom dashboards, queries can be written in application insights to derive more targeted information. X++ developers can also log exceptions from custom code to feed into the telemetry. It will be interesting to see how microsoft converges the application monitoring capabilities across Dynamics 365 applications.

Below are some good reference article for more information on this topic:

Thank you for reading the blog.


D365 F&O Azure Hosted Build Error – Process ‘msbuild.exe’ exited with code ‘1’.

Today our azure hosted build pipelines running against TFVC branches stopped working with the error Process ‘msbuild.exe’ exited with code ‘1’.

Resolution which worked for us : Update the solution path with wildcard to find the build solution path. Previously we had full path defined but somehow it started causing error.

It looks like Microsoft updated something under the hood and if you are stuck with the same issue then this might help you to move forward.

D365 F&O Email Setup Troubleshooting Error “D365 F&O Server smtp.office365.com:587 using SSL/TLS supports the following authentication options: LOGIN, XOAUTH2.”

Recently I encountered an error message when trying to test the send email functionality after setting up the email parameters and using SMTP to send out test email “D365 F&O Server smtp.office365.com:587 using SSL/TLS supports the following authentication options: LOGIN, XOAUTH2.

After some researching, I found the below setup was missing in Microsoft 365 Admin Center for the user. To fix this :

Navigate to Office 365 Admin Center >>Open list of users >> Select the user and click on the name

Click on Mail >> Go to Manage Email Apps

Make sure the check box is Turned ON. By default it is turned OFF.

After this come back to Dynamics 365 F&O and send the test email

Troubleshooting Bank Statement import error ” Bank account Not identified in the import file” in Microsoft Dynamics 365 Finance

I recently faced the below error when trying to import a BAI2 format bank statement file in Microsoft Dynamics 365 Finance (Service update 10.0.28) version.

Error upon importing bank statement

The bank statement file had correct bank account. The issue was due to another bank setup in a different legal entity with the same account number.

After correcting the bank account the import process worked fine.

If you are facing the same error when worth checking for the duplicate bank account number in another legal entity.

Microsoft Dynamics 365 F&O 10.0.26 feature: Select tile size via personalization

In Dynamics 365 F&O service update 10.0.26, a new personalization feature is released which allows users to choose and select desired tile size for the workspaces. The feature can be enabled from Feature management workspace

Details of the feature can be found at Microsoft docs

Once the feature is enabled, users can select the desired tile size when personalising a tile as shown below.

To bring the options, right click on the tile >> select Personalise >> Select tile size

Below is how different tile sizes look

Size : 2X4
Size: 2X2
Size : 1X2
Size : 4X4

The same tile size options are available when users add a filtered list to workspaces via personalization.

Steps to do it are go to options pane >> Add to workspace >> Select workspace >> Select tile size as shown below

AI capabilities in Microsoft Dynamics 365 Finance, Supply Chain and Commerce

ERP’s have evolved over time and the people who are in this domain have witnessed how the usage of ERP system has changed – from being just an in-house system to manage operational activities to being modern and intelligent systems which can talk to external systems, provide access to external parties via portals with rich analytics baked into the product to provide actionable insights to improve operational efficiencies and decision making.

Last few years have taken a big leap in adding Data Analytics, Machine learning and Artificial intelligence capabilities in order to make the systems more smart .

In this post I’ll highlight AI/ML based capabilities available out of the box in Microsoft Dynamics 365 Finance , Supply chain and commerce applications. There are links to explore more about these features:

Microsoft Dynamics 365 for Finance:

Finance insights combines functionality from Microsoft Dynamics 365 Finance with Dataverse, Azure, and AI Builder to provide powerful forecasting tools . Announcement of these capabilities were made in Feb 2020 and these features are now generally available.


  • Budget Proposal : By using Finance Insights, intelligent budget proposals can quickly consolidate and analyze years of historical data to predict your budget forecast. By letting the system perform these budgeting tasks for you, you’ll save time and be able to focus on meaningful discussions about how the budget will support your business. https://docs.microsoft.com/en-us/dynamics365/finance/finance-insights/budget-proposals
Adapt quickly with intelligent budget proposals
  • Cash Position : Cash position is the projection of cash flow that is forecast for the near term. It’s based on the projection of cash receipts from customers that pay outstanding invoices and orders, and also on the projection cash disbursements that are paid to vendors for purchase invoices and orders. More details can be found at https://docs.microsoft.com/en-us/dynamics365/finance/finance-insights/cash-position

a screenshot of a cell phone
  • Customer payment predictions : The Manage customer credit and collections workspace includes two new tiles: Transaction payment predictions and Customer payment predictions. On the Transaction payment predictions list page, you can view the probability of payment for open transactions in the On time, Late, and Very late buckets
Graphical indicators for payment predictions in the Related information pane.

The Customer payment predictions list page shows the total open balance, and the amount that is predicted to be paid in the On time, Late, and Very late buckets.

Payment predictions per customer page.

For more details visit:

Webinar for the above financial insights from Microsoft can be viewed from the link:https://go.microsoft.com/fwlink/?LinkId=2160818&clcid=0x409

You tube video having summary of these features is https://www.youtube.com/watch?v=lAYBRdn2oHw

  • Expense receipt processing : Expense entry has been enhanced through the introduction of optical character recognition (OCR) processing for receipts. We need to install expense management service add in from LCS and then enable the below features
    • Expense reports re-imagined
    • Auto-match and create expense from receipt

This feature uses Azure cognitive services Form Recognizer to extract the field information from the the uploaded expense receipts

Sample receipt with extracted information from Form Recognizer’s new prebuilt receipt feature

More details can be found at below link https://docs.microsoft.com/en-us/dynamics365/project-operations/prod-exp/expense-receipt-processing

Microsoft Dynamics 365 for Supply Chain:

  • Demand Forecasting : Demand forecasting is used to predict independent demand from sales orders and dependent demand at any decoupling point for customer orders. To generate the baseline forecast, a summary of historical transactions is passed to Microsoft Azure Machine Learning hosted on Azure. Basic flow is as below. Wecan use Supply Chain Management to visualize the forecast, adjust the forecast, and view key performance indicators (KPIs) about forecast accuracy.
demand forecasting introduction diagram.

A great demo on this feature was given by Andrew Lencsak in DynamicsCon 2020. Below is the link


Below links have more details:



Microsoft Dynamics 365 for Commerce:

Below is high level architecture of the service

Ratings and reviews in Dynamics 365 for Commerce.

  • Commerce analytics (Preview) : This feature is in preview and utilises all modern capabilities of data lake, azure synapse analytics and power BI semantic models to provide the rich analytics from commerce data ganarated from multiple sources. A live demo if this dashboard can be access from https://aka.ms/CommerceAnalyticsDemo

More details can be found at https://docs.microsoft.com/en-us/dynamics365/commerce/commerce-analytics

  • Microsoft clarity in Dynamics 365 commerce : Microsoft Clarity is a user behavior analytics tool that can help site owners understand user interactions with their e-commerce sites. Clarity’s analysis tools enable visibility using session recordings, heatmaps, and machine learning insights to review and study user interactions. Clarity can be integrated into Dynamics 365 commerce sites. More details can be found at https://docs.microsoft.com/en-us/dynamics365/commerce/set-up-clarity
Instant heatmaps

Visit https://clarity.microsoft.com/ to know more about this platform

  • Fraud Protection :Fraud Protection is a service that offers fraud protection solutions to help retailers prevent fraudulent activity and identify places where fraud might be unnoticed.  This has to be purchased in addition to Commerce license altough the integration capabilities exists out of the box . Visit https://dynamics.microsoft.com/en-us/ai/fraud-protection/ to know more about the offering.

The steps to integrate Fraud protection with D365 commerce are available at https://docs.microsoft.com/en-us/dynamics365/commerce/dev-itpro/dfp

  • Product recommendations : The product recommendations service utilizes artificial intelligence and machine learning (AI-ML) technologies in the following way:
    • Data in the format that the Recommendation service requires is extracted from the Commerce operational database and sent to Azure Data Lake Storage or Entity store.
    • The recommendations service uses the stored data to train recommendation models for the People also likeFrequently bought togetherNewBest selling, and Trending lists.
Recommendations on the Product details page.

This service is an add-on to Dynamics 365 Commerce.  Visit https://docs.microsoft.com/en-us/dynamics365/commerce/product-recommendations

  • Personalised product recommendations : In Dynamics 365 Commerce, retailers can make personalized product recommendations (also known as personalization) available. In this way, personalized recommendations can be incorporated into the customer experience online and at the point of sale (POS). When the personalization functionality is turned on, the system can associate a user’s purchase and product information to generate individualized product recommendations.
Applying personalization.

More details can be found at https://docs.microsoft.com/en-us/dynamics365/commerce/personalized-recommendations

  • Shop similar looks recommendations : The “shop similar looks” recommendations feature in Dynamics 365 Commerce uses the power of artificial intelligence and machine learning (AI-ML) to deliver recommendations for visually similar products to customers.

More details can be found at : https://docs.microsoft.com/en-us/dynamics365/commerce/shop-similar-looks

Enable Shop Similar Looks Link check box and Shop similar looks button on a PDP in site builder.

  • Shop similar description recommendations : The functionality for “shop similar description” recommendations uses the product name and description of seed products to find and recommend similar products in a retailer’s product catalog. “Shop similar description” recommendations are available in both the point of sale (POS) and e-commerce experiences.

Enable shop similar description Link check box and Shop similar description button on a PDP in site builder.

More details can be found at : https://docs.microsoft.com/en-us/dynamics365/commerce/shop-similar-description

  • Clienteling with customer insights : In Microsoft Dynamics 365 Commerce, retailers can use the client book functionality to help store associates form long-term relationships with key customers. By using the Dynamics 365 Customer Insights application, retailers can aggregate data from the various systems that customers use to interact with the retailer’s brand. They can then use this data to generate a single view of the customer and derive insights. The integration of Customer Insights with Commerce lets retailers select one or more measures that should be shown on the customer card in the client book. For example, retailers can use the data in Customer Insights to calculate the “churn probability” for a customer and define the “next best action.” If these values are defined as measures, they can be shown on the customer card and can provide crucial information to sales associates
Example of a client book.

For more details and steps to integrate Clinteling features with Customer insights visit https://docs.microsoft.com/en-us/dynamics365/commerce/clienteling-overview

The below AI powered capabilities are available in Dynamics 365 ecosystem which can be added to your existing Dynamics 365 applications to enhance the experience:

  • Dynamics 365 Connected space ( In preview) : With Dynamics 365 Connected Spaces, your organization can harness observational data with ease, use AI-powered models to unlock insights about your environment, and respond in real-time to trends and patterns.

Visit https://cloudblogs.microsoft.com/dynamics365/bdm/2021/11/02/gain-a-new-perspective-with-dynamics-365-connected-spaces/ for more details

Product user interface that shows drawing queue management skill.

Dynamics 365 customer insights : Bring together transactional, behavioral, and demographic data in real time to create a 360-degree view of your customers. . Optimize the customer journey with out-of-the-box and custom interactive reports.

Image for unify data for real-time insights

Understand customer behavior on your website and mobile app for cross-channel journey optimization

Image for Cross channel

Optimize the customer journey with out-of-the-box and custom interactive reports.

Image for Actionable

Predict customer needs by unlocking powerful insights using prebuilt AI models, or use custom models for deeper insights.

Image for AI powered

For mroe details visit https://dynamics.microsoft.com/en-us/ai/customer-insights/

  • Dynamics 365 Supply chain insights : This platform provides below capabilities
    • Improve decision making with a digital-supply-chain twin by performing what-if simulations, advanced analytics powered by AI, and enhancing multi-tier supplier visibility.
    • Seamlessly work with existing planning and execution systems. Invite suppliers and partners to securely receive and share data on one platform.
    • Improve collaboration with suppliers, partners, and team members to identify risks early and plan for supply and resource constraints.

For more details visit https://dynamics.microsoft.com/en-us/supply-chain-insights/

Proactively avoid disruptions
Get operational fast

It does not stops here, power platform provides rich capabilities to build our own AI and ML models and curate your own solutions for Dynamics 365 applications. For more details visit https://docs.microsoft.com/en-us/ai-builder/model-types

Thanks for reading the blog.

Microsoft Ignite 2021 announcements about Dynamics 365

During Microsoft Ignite 2021 held from 3-5 Nov 2021, Microsoft announced about emerging technology trends and innovations happening across the Microsoft Cloud covering Azure, Business Applications, Industry cloud, Microsoft 365 & Windows, Microsoft Edge, Power platform, Security & Identity management.

In this post I’ll highlight 6 key announcements related to Dynamics 365 business applications space and provide references so that you can dive deeper into your area of interest.

  1. Collaborative apps released across Microsoft Dynamics 365, Power Platform, Office and Teams
  2. Microsoft Dynamics 365 Supply Chain Insights now in preview
  3. Microsoft Dynamics 365 Customer Service voice channel now available
  4. Microsoft Dynamics 365 Connected Spaces coming to preview soon
  5. Microsoft Dynamics 365 adds key capabilities for Supply Chain Management
  6. Microsoft Customer Experience Platform puts organizations in control of customer data

Collaborative apps released across Microsoft Dynamics 365, Power Platform, Office and Teams

To allow organizations to to operate as one business, everywhere. New capabilities and features in preview have been release released across Microsoft Dynamics 365, Power Platform, Office 365 and Teams include:

  • Accessible business data: A. Dynamics 365 and Teams are getting closer to each other to allow Organizations quickly find results from business data across Microsoft Search, unfurl that data into actionable cards (Loops) across Outlook and Teams and search valuable business data inline while writing. This new capability is called a Loop component, an element of Microsoft Loop, introduced today at Microsoft Ignite. Learn more about Microsoft Loop on the Microsoft 365 blog
While writing a message in Outlook or Teams, or when creating a document in Microsoft Office, type “@” followed by a keyword, document title, or person’s name for suggested contact cards, documents, or Dynamics 365 records
  • Increased collaboration: Teams can invite anyone across the company to collaborate on Dynamics 365 sales records within the flow of a Teams chat or channel. Other collaborative updates include the ability to have a “chat now” pop out from anywhere in Dynamics 365 and inbound/outbound digital voice with Teams, featuring conversational intelligence.
ontext IQ suggests colleagues relevant to Dynamics 365 records to promote people discovery for faster deal or case resolution.

  • Real-time engagement: Organizations can see who is working with them in the flow of work with live co-presence throughout Dynamics 365 apps. In addition, users can have all the information available on people they are collaborating with and how to engage with them via calls, chats or meetings.
During a Teams meeting, sellers can quickly access and share key sales information from Dynamics 365, reducing the need to switch between apps during the conversation.

For more details https://cloudblogs.microsoft.com/dynamics365/bdm/2021/11/02/meet-context-iq-a-new-way-to-collaborate-in-a-hyperconnected-business/

Watch the ignite session https://myignite.microsoft.com/sessions/f5e561b9-f946-4ba5-b931-7416b0a52c0b?source=sessions

Microsoft Dynamics 365 Supply Chain Insights now in preview

Supply Chain Insights enables organizations to predict and mitigate disruptions and ensure positive customer experiences through fulfilling demand. With this solution, organizations can:

  • Collaborate and unify data in near real-time from third-party data providers, logistics partners, customers and multi-tier suppliers.
  • Enhance visibility by creating a digital twin of the supply chain and then generate actionable insights powered by AI.
  • Further predict and mitigate risk by enriching supply chain signals with external constraints like environmental disasters or geopolitical events that could affect the supply chain.

Proactively avoid disruptions

Read more about capabilites in this area at https://cloudblogs.microsoft.com/dynamics365/bdm/2021/11/02/mitigate-disruptions-with-dynamics-365-supply-chain-insights-now-in-preview/

Watch below ignite sessions



Microsoft Dynamics 365 Customer Service voice channel now available

Organizations can transform their contact center operations with the new Microsoft Dynamics 365 Customer Service voice channel, now generally available. This addition to the existing omnichannel capabilities leverages the power of Microsoft Teams to bring traditional Contact Center as a Service (CCaaS), Unified Communications as a Service (UCaaS) and Customer Engagement Center (CEC) under a single, integrated customer service Software as a Service (SaaS) solution with Dynamics 365 Customer Service.

Now, the automation, intelligence and data insights that were previously only available for digital channels are available in a voice option. Organizations can get up and running quickly, deliver an all-in-one contact center, improve knowledge authoring and management, and transform contract center routing to deliver improved service experiences for customers in both digital and voice channels.

Figure 1: Agents can view a real-time call transcript, see the customer’s details, recent cases, and suggested knowledge articles and similar cases to help resolve customer issues more quickly.
Figure 2: View actionable insights and key performance metrics across channels and drill in for deeper analysis.

Read more about this https://cloudblogs.microsoft.com/dynamics365/bdm/2021/11/02/introducing-voice-channel-for-dynamics-365-customer-service/

Watch session recording here https://myignite.microsoft.com/sessions/e6954ac3-801c-4e3f-9466-ab80a8ce3674

Microsoft Dynamics 365 Connected Spaces coming to preview soon

In today’s environment of both digital and physical spaces, organizations have less visibility into their physical footprint than their digital channels, limiting their potential to optimize operations and improve employee and customer experiences. Microsoft Dynamics 365 Connected Spaces lets organizations harness observational data, use low-code capabilities to control observations and then produce real-time, predictive insights. Connected Spaces, coming to preview next month, is built to be extensible and works with existing hardware.

Connected Spaces product’s user interface that shows camera set-up.
Connected Spaces product’s user interface that shows drawing skills.

Connected Spaces lets organizations gain a new perspective in the way people move and interact in nearly any space, from the retail store to the

Product user interface that shows drawing queue management skill.

factory floor. Maximize safety in high-risk areas, observe queue management and seamlessly manage the connected factory, all in the name of understanding spaces in new and intelligent ways.

Learn more about this at https://cloudblogs.microsoft.com/dynamics365/bdm/2021/11/02/gain-a-new-perspective-with-dynamics-365-connected-spaces/

Microsoft Dynamics 365 adds key capabilities for Supply Chain Management

As manufacturers seek to create an agile and connected factory, Microsoft Dynamics 365 Supply Chain Management can now help customers predict demand shifts, supply constraints and equipment downtime by eliminating siloed Manufacturing Execution Systems (MES) to improve visibility of the production floor. Manufacturers can now work seamlessly with any MES system to unify data and generate predictive insights that can improve quality and optimize production processes.

Additionally, a priority-based enhancement to the planning optimization engine in Dynamics 365 Supply Chain Management helps eliminate zero-stock events. The solution automatically prioritizes replenishment of high-demand items in near real-time based on order priorities, current stock levels and projected inventory, leading to improved supply chain management. These updates are in preview.

Learn more about it https://cloudblogs.microsoft.com/industry-blog/digital-transformation/2021/11/02/build-a-hyperconnected-business/

Microsoft Customer Experience Platform puts organizations in control of customer data

The Microsoft Customer Experience Platform is a complete marketing solution that puts organizations in control of their customer data to personalize, automate and orchestrate customer journeys. It’s designed to deliver personalized and connected experiences from awareness to purchase. With a deep understanding of customers and rich, out-of-the-box insights, organizations can now understand and predict intent to deliver the right content on the right channel and in the right moment.

Microsoft Customer Experience Platform utilizes assets from across the company to create a cohesive Service as a Solution (SaaS) product while also delivering capabilities from Microsoft Customer Insights and Microsoft Dynamics 365 Marketing. Features in this new solution include:

  • Consent-enabled Consumer Data Platform (CDP): This feature, in preview, enables the chief data officer (CDO) to use consent data directly in the CDP as an integrated, first-class capability. Organizations can utilize consent enablement to build complete customer profiles, manage known and pseudonymous aliases, ensure consumer data practices are compliant and protect that data with robust privacy and security controls, all in real-time.
  • Expanded business-to-business (B2B) tools: A business-to-business CDP combines customer data from all sources – CRM, email, websites, point-of-sales, partner systems, social networks and more – and performs identity resolution at the contract and account level to generate unified profiles for individuals and accounts. This feature is now generally available.

Data sources listed in Customer Insights.
A Segment in Customer Insights showing popular drink customers.

Capabilities included as part of customer experience platform are:

Read more about this here : https://cloudblogs.microsoft.com/dynamics365/bdm/2021/11/02/introducing-microsoft-customer-experience-platform-a-solution-for-connected-customer-experiences/

Watch webinar https://info.microsoft.com/ww-landing-MicrosoftCustomerExpPlatform.html?lcid=en-us




Converting Database from Tier 2 ( .bacpac ) to Tier 1 ( .bak ) on new developer VM released with 10.0.21

The path to find SqlPackage.exe on the new developer VM released for Microsoft Dynamics Finance and Operations image is below:

C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\150

Below is the script which is used for conversion

SqlPackage.exe /a:import /sf:J:\UAT\uat.bacpac /tsn:localhost /tdn:AXDB_UAT /p:CommandTimeout=1200

D365 F&O : Dealing with SSRS Serialization version mismatch error

Dealing with SSRS reporting framework in Microsoft Dynamics 365 Finance and Supply chain can be tricky sometimes.

Recently I get the below error after adding a new dataset to an existing SSRS report.

By doing the below steps the error was resolved. If you are facing the same error then you can try the below steps :

  • Build the model under which the report object exists
  • Restart SSRS service
  • Perform IIS Reset

Have a great day.

AI powered PROGRAMMING is reality – power FX got more powerful with GPT-3

Artificial Intelligence is impacting every aspect of our life’s. Not only it uses it’s models to create outputs used by businesses it also has also been leveraged to make life of developers easy  and enable then to quickly build the apps they need and more easily learn advanced concepts in the process.

Microsoft has fine-tuned one of the most advanced natural language AI models on the planet, a model known as OpenAI GPT-3, to automatically generate Power Fx formulas based on natural language input. 

Trained with 175 billion parameters, GPT-3 is an advanced natural language AI model that implements deep learning to be able to both understand and produce human-like text based on a prompt in natural language. Microsoft has a strategic collaboration with OpenAI, the developers of GPT-3, to be able to apply the model in products like Power Apps.

Below is an example of the generated Power FX formula based on the text inputted.

Refer to below links for details on the announcements and the technology under the hood.