In some cases Dual Write gives you some cryptic error messages. Here are a couple of tips to get or find the errors. Tip 1. If you get an error while mapping or trying to set up a new map. You can get a bit more info from using browser developer tools. In Chrome, just right click and select Inspect. Click on Network and start recording (trace). Hopefully you get a bit more detail with the error. Tip 2 If you are getting an integration error. There is a table that stores all the errors. https://XXXaos.cloudax.dynamics.com/?mi=SysTableBrowser&tableName=DualWriteErrorLog For more troubleshooting…

LCS has some really great tools for checking performance. Its really a matter of trying to get used to them and knowing whats available. Under the Environment monitoring > SQL insights > Performance metrics. You can find some slow queries and how they are affecting the environment over time. I found that SalesLine table was missing an index for Revenue recognition. Warning: Do this at your own risk. You could break the system if you haven't tested this properly. I raised a support ticket but was asked to create a non-unique index on the table via LCS. Go to Environment monitoring > SQL Insights…

Just bringing attention to this docs page. https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entities-report I only saw it today and it has some nice scripts that you can run to generate information. Go to the github project it references and run the scripts. Script Outputs AggregateDataEntitiesReport.ps1 AggregateDataEntities.csv AggregateMeasuresReport.ps1 AggregateMeasures.csv DataEntityFieldReport.ps1 DataEntityFields.csv DataEntityReport.ps1 DataEntities.csv KPIReport.ps1 KPIs.csv LicenseCode-ConfigKeyReport.ps1 LicenseCodes.csv ConfigKeys.csv ConfigKeyGroups…

In the recent updates of Dual Write, Microsoft released a pricing and inventory on hand integration in CE. Real time pricing calculation and inventory on hand as per FinOps business logic. In this post, I wanted to cover how it seems to magically work. As you know by now, Dual Write uses a push architecture. Where either FinOps pushes to CE or CE pushes to FinOps. Both call a web service on the other side to sync data. Any errors that occur are presented to the user in real time. However, the pricing and inventory on-hand feature is different. These two features pull limited calculated data as…

Microsoft has done a really good job with documenting eCommerce development on the Microsoft docs site. Here I am just summarising useful links for those wanting to get started with development. Start by watching some of these videos. Some are repeating content but very useful information in all of them. Accelerate your business with Dynamics 365 Commerce Dynamics 365 Commerce – What’s New Dynamics 365 Commerce: Authoring tools Dynamics 365 Commerce: E-Commerce extensibility Dynamics 365 Commerce: How to Extend Dynamics 365 Commerce How to extend Dynamics 365 Commerce | BRK2366 Dynamics 365 Commerce…

Our team has been doing some development with the new eCommerce . One of the things we had to figure out was how to debug. To debug client side javascript, you can use Chrome Inspect and dig into the javascript. If you want to debug the server side TypeScript code then you need to do that on a development box. Set your self up, as I assume you already know how to get started with development and you got it to run via yarn start . In VS Code, install Debugger for Chrome extension. Call yarn start to run your project Click on Run > Start Debugging If it is the first time debugging, then it will auto…

Sometime last year, I posted about using Business Events with Data Export . The code was shared on Github too. Now, I have updated to introduce a Data Import Business event. This is helpful for a number of scenarios (specially for integration). Long running jobs - you don’t want to constantly call Odata services to get the status of your execution job Trigger data execution alerts for integration - you could trigger alerts based on failures. The argument here could be that you could use alert rules to fire a business event. Alerts rules are flexible but I find that I have to use Odata calls to…

Recently, Microsoft released their eCommerce solution. I got started by looking at how to do a bit of development locally. The guide is here https://docs.microsoft.com/en-us/dynamics365/commerce/e-commerce-extensibility/setup-dev-environment One of the first steps to development is to clone Microsoft github repo . That's fairly easy to do. But, the next question I had was, “how do I do my development in my own private version control and continue to pull Microsoft's latest releases?”. I don't want to manually merge folders and deal with painful files. I am not an expert in git and still have a…

In this post I will share some code on how to embed a Chat bot into the Help pane in #MSDyn365FO. My full code is available on GitHub . Do share any feedback. I won’t go into detail on how to develop the Chat bot as there are a number of ways to do it. Options available in the Microsoft world are: Power Virtual Agent , QnA Maker bot Azure Bot Service bot The point is you might want to surface that bot in FinOps to help users with their queries or support requests. Below is what it looks like. I added a field to embed the URL in the system parameters. Once you have entered the webbot url, you will…

I have been experimenting with getting Metadata information from the AOT from FinOps. There is some discussion on this forum post which helped me. https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/316468/how-to-get-aot-objects I thought I would try to clean it up a bit to make it a bit more readable for future reference. The X++ code below will loop through Display menu items in the AOT and print some info. Menu Item Name Menu Item Label Model Name public static void main (Args _args) { System.Type axMenuItemTypeDisplay = new Microsoft.Dynamics…