One advantage with parquet files is that it keeps history. Run the below script and it will give you the history.  %%sql DESCRIBE HISTORY dirpartytable; Below is an example I have in my environment. Use "VERSION AS OF"  Now that you have the history, you can use the VERSION AS OF statement. This will give you the previous values for the record.  %%sql SELECT partynumber, primarycontactphone, primarycontactemail FROM dirpartytable WHERE partynumber = '000001702'; SELECT partynumber, primarycontactphone, primarycontactemail FROM dirpartytable VERSION AS OF 2 WHERE partyn ..read more

This will be a fairly straightforward blog post covering different ways of copying data from a shortcut delta table into a delta table created automatically via a notebook. Select statement with a join %%sql SELECT     party.recid AS PartyId     ,party.name AS Name     ,COALESCE(party.namealias, '') AS ShortName     ,COALESCE(postal.countryregionid, '') AS Country     ,COALESCE(postal.state, '') AS State     ,COALESCE(postal.city, '') AS City     ,COALESCE(postal.street, '') AS Street     ,COALESCE(postal.zipcode ..read more

I’ve recently been exploring various analytical options within Dynamics 365 Finance and Operations, and one that I’ve delved deeply into is Link to Fabric. There is a walkthrough guide available on the Microsoft Fasttrack Github repo. See Hands-on Lab: Link to Fabric from Dynamics 365 finance and operations apps This guide is an excellent starting point and should be one of the first things you try out. However, it’s important to understand that there are limitations to this approach that may not be suitable for all real-world scenarios. Lets discuss these items and what I have been explo ..read more

When it comes to setting up multiple companies, stream lining the process can save you time and effort. One effective strategy is to establish a template company or select a source company to replicate from.  In this blog post, I won't go through how to use the copy company feature as there are many blogs out there and Microsoft has some good documentation. https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/copy-configuration What I will explain is an issue I faced when using it. I found that the copy number sequence isn't working as expected. It throws a ..read more

Microsoft recently released the new Invoice Capture for Dynamics 365 Finance. I ran through installing and configuring it.  From that experience, below is my brain dump and hopefully it can help with things that are not so obvious. Three type of invoice captures There are three invoice type paths that can be captured. These drive the screen layout and what kind of information is mandatory. PO invoice Header-only Cost invoice When an invoice comes in, you can select one of the three invoice types. Below are the three screen layouts and differences. PO invoice – Invoices of this type ar ..read more

  Microsoft recently released a preview mobile app for Asset Management. The App gives 2 personas that you can use it for: Maintenance worker - You need to be assigned to the security role "Maintenance worker" https://learn.microsoft.com/en-us/dynamics365/supply-chain/asset-management/asset-management-mobile-app/work-orders. It will allow you to give feedback on a work order such updating actual hours, items, checklists and attachments. Maintenance requester - You just need a teams license and can assign "Maintenance requester" security role https://learn.microsoft.co ..read more

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 trou ..read more

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 ..read more

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 ..read more