Find Unused Labels – Dynamics 365 Finance & Operations
How many of your labels do you maintain, and yet are not being displayed in any way to a user? I set out to answer this question on one of my projects, and found 10%, over 100 labels, were created and abandoned as functionality was changed over time. These [...]
Push notification if early meeting tomorrow morning
As a consultant I have meetings at all times of the day. One of my first steps in my day is to check my calendar to understand just how much time I have before I need to join my first meeting, and to review my meetings to make sure [...]
Automated Unit Tests for Intercompany Transactions – Dynamics 365 Supply Chain Management
Background Creating unit tests (SysTest + ATL) and automating their running in an Azure pipeline is part of a good continuous update strategy which reduces the risk of taking frequent product updates for Dynamics 365 Supply Chain Management from Microsoft. The guidance on Docs is fairly good, when combined [...]
How to Combine Multiple D365SCM OneBoxes into One Environment
In Dynamics AX 2012 I commonly added AOSs to the data migration environment to speed up data migration. On one project I had an environment with twelve 2.6 GHz physical cores (24 threads when hyper-threading) which I would add up to five additional "underutilized" development servers as AOSs when [...]
Monitor Deprecated Features or Release Schedule
Microsoft has committed to giving 12 months notice before making a potentially breaking change. Read more. They will post the breaking changes to the Removed or deprecated features for Finance and Operations page on Docs. I encourage you to read the introduction on that page so you understand exactly [...]
The Utility of Query Range Functions – Dynamics 365 for Finance Operations Supply Chain Management
Query range functions are a feature of F&O which enables specifying a criteria without knowing the exact value or having to do the calculation yourself. This could be used to filter a form, or when specifying 'records to include' on a scheduled batch (very handy). Examples: (currentDate()) (anyUserIdNotCurrent()) (day(-2)) (greaterThanDate(-2)) [...]
A Tale of Updating 28 Environments – Dynamics 365 for Operations
Scenario I had a customer implementing Microsoft Dynamics 365 for Finance and Supply Chain Management who had to postpone an update because an ISV solution needed an update. The upgraded solution came, so I planned out the environment update roll out strategy: which environments would get updated? When? How [...]
Static IP not guaranteed for Dynamics 365 for Finance and Operations
Microsoft Dynamics 365 for Finance and Operations offers a lot of flexibility and significantly reduced maintenance effort than the previous versions (AX). Along with being a cloud-hosted SaaS solution, we had to modify our approach to making modifications, interfacing with the system, licensing and more. One change which can [...]
Searching Code in Dynamics 365 Finance and Operations Using PowerShell
You can search the Finance and Operations XML files (the X++ source code) using regular expressions by using PowerShell's Select-String command. This is a strategy that I've used many times and I wonder if others have realized the ease of approaching code searches this way. For some background, we'll be [...]
F&O Data Expansion Tool: Error Tracing Not Started
Tracing not started error? Perhaps, like me, you recently rebooted the environment and it had not fully initialized before you tried to start recording on a new Data Expansion project. 1. Reboot the environment. 2. Create and build a runnable class ("job") to call DataExpansionTraceControl::clear(true). 3. Run [...]
F&O Data Expansion Tool: Recording Data Creation
The Data Expansion Tool is a tool which will generate data in the current Microsoft Dynamics 365 for Finance and Operations environment. The tool itself is not documented and the video which demonstrated it has been lost because the Office Mix web site was retired. It enables you to [...]
F&O Data Expansion Tool: The Execution Traces event publisher is not installed
The Data Expansion Tool is a tool which will generate data in the current Microsoft Dynamics 365 for Finance and Operations environment. The tool itself is not documented and the video which demonstrated it has been lost because the Office Mix web site was retired. It enables you to [...]
What F&O Tables do not have Data Entities?
If you are like me sometimes it can be hard to translate from technical name to the actual data entity name. As a Microsoft Dynamics 365 for Finance and Operations developer it is sometimes useful to use the cross reference to identify the proper entity to use, however some [...]
Call an Azure Function from Dynamics 365 for Finance and Operations
In this example, F&O will directly call an Azure Function which can do some processing (usually integrating with other services). 1. Create a new Azure Function App in the Azure portal. Once created, add an Azure Function with an HTTP trigger. (Psst: Application Insights should be deployed to [...]
Reminders When Meeting Scheduled Outside of Business Hours – Flow
When working on global implementations, meetings outside of typical business hours are very common. The following describes a Flow which reminds me of off-hours meetings before bedtime so that I can set my alarm appropriately. Start with a Flow trigger on a schedule. The trigger is called "Recurrence." [...]
Using the LogicApps and Flow Connector for Dynamics 365 for Finance and Operations
Finding the Right Data Entity Let's say you know you want to read data from F&O and OData endpoints are appropriate. LogicApps is a great way to pull that data and push it to another service. Or perhaps you subscribed to an F&O Business Event and want additional [...]