D365 new year.  Let’s take the trash out.
Jan10

D365 new year.  Let’s take the trash out.

Exciting news from Microsoft has just landed a new preview feature, and it’s all about making our Dynamics 365 environment cleaner, more efficient, and compliant. In a recent Yammer post, Microsoft announced a significant upgrade to the storage capacity experience in the Power Platform Admin Center (PPAC) for Finance and Operations. This new (preview) feature … Continue reading D365 new… Continue Reading Kurt...

Read More
D365FO bacpac import – Unable to connect to target server localhost – Error occurred during the login process
Jan08

D365FO bacpac import – Unable to connect to target server localhost – Error occurred during the login process

My team had an issue today when importing the bacpac in their devVM. Though the first issue was resolved with this fix , the import again ended up in the error . Unable to connect to target server ‘localhost’. Please verify the connection information such as the server name, login credentials, and firewall rules for the target server. A connection was successfully established with… Continue Reading...

Read More
How To Use D365 Try Catch Statements
Jan08

How To Use D365 Try Catch Statements

In this article, learn how to add exception handling by using D365 try catch statements. Unexpected errors and exceptions can occur in any program. Without exception handling, when an error occurs the system will stop the process entirely. However, with the right code, you can ensure the system skips past invalid records and continues to… Continue Reading → The post How To Use D365 Try Catch… Continue Reading...

Read More
Secure inputs / outputs in Logic apps
Jan03

Secure inputs / outputs in Logic apps

Logic apps is best in orchestrating the workflow integrations and it has close to 200+ connectors .With its simple UI designer , it has become the favourite middleware for any integration scenarios. Data plays a major role in today`s transactions and it is important to secure it. For instance, if the auth token which consists of secret / client id / tenant should be secured as these… Continue Reading AnithaEswaran’s...

Read More
CoPilot in Dynamics 365 implementation portal
Jan03

CoPilot in Dynamics 365 implementation portal

Have you explored the Dynamics 365 implementation portal (https://experience.dynamics.com/FTimplementationportal )? You should! Lot’s of value and checklists available there. The Dynamics 365 Implementation Portal is designed to assist both customers and partners in guiding their Dynamics 365 projects to a successful completion. This portal offers detailed implementation advice and strategies… Continue Reading Kurt...

Read More
OData query options with D365F&O (Part 2)
Dec25

OData query options with D365F&O (Part 2)

In the previous post, I have explained about the various options of quering F&O using OData. Let us continue the ARITHEMATIC queries in this post. Less than – Applicable for numeric fields . Retrives the records that have the value mentioned in the lt clause and includes zero values in the result. For instance, to fetch the products whose Salesprice is lessthan 150 . The query is… Continue Reading AnithaEswaran’s...

Read More
D365 eCommerce and Relevance search – When life gives you lemons, make lemonade
Dec21

D365 eCommerce and Relevance search – When life gives you lemons, make lemonade

Dynamics 365 Commerce utilizes cloud-powered search to enhance product discoverability. This feature is crucial for customer interaction across various channels like e-commerce and point of sale (POS), ensuring customers can quickly find products. This search experience includes advanced capabilities like faceted navigation, immersive autosuggest, and sorting options for better product… Continue Reading Kurt Hatlevik’s...

Read More
Microsoft Dev Box and Dynamics 365 F&O local development
Dec14

Microsoft Dev Box and Dynamics 365 F&O local development

After a long, long, long, long, long time waiting for it, the Dynamics 365 F&O local development feature is finally here… in public preview. It’s a bit different since the first time we heard about this at the MBAS in 2019… but it opens up a new scenario for developers. I won’t go into much… Continue Reading Microsoft Dev Box and Dynamics 365 F&O local… Continue Reading Adrià Ariste...

Read More
Add Logging to SysAdmin Role Assignments in D365FO
Dec13

Add Logging to SysAdmin Role Assignments in D365FO

This is a follow up blog post to one I had a few weeks ago about being able to grant/revoke the SysAdmin role for testing purposes. One of the things I called out there was that before implementing this solution there needed to be a logging functionality to be able to audit when a user was granted or revoked this access. Here’s how I added this functionality. Design The first thing I needed… Continue Reading Alex’s...

Read More

Multithreading in D365 Batch Jobs

There are times when you need Microsoft Dynamics 365 for Finance and Operations to process records as a background process. SysOperation Framework batch jobs were created for this. However, sometimes even one instance of these jobs do not process records fast enough. Learn how to create multithreading in D365 batch jobs and process records in… Continue Reading → The post Multithreading in… Continue Reading...

Read More
Dynamics 365 eCommerce, search and no hype
Dec08

Dynamics 365 eCommerce, search and no hype

Hey there, eCommerce enthusiasts! Get ready for some exciting news from the Dynamics 365 universe. Microsoft’s hitting pause on Product recommendations for newbies, but hey, who says we can’t have a little fun in the meantime? Enter the world of ChatGPT for Excel – think of it as your personal eCommerce wizard! This nifty tool … Continue reading Dynamics 365 eCommerce, search and… Continue Reading Kurt...

Read More
Azure Logic Apps Community Day: D365 FinOps and Data Integration with Azure Logic Apps
Dec07

Azure Logic Apps Community Day: D365 FinOps and Data Integration with Azure Logic Apps

In this session we will talk about the importance of having a Data integration strategy and how Azure Logic Apps can play major role in the data integration processes with D365 FinOps. Continue Reading adalhix’s Article on their blog Azure Logic Apps Community Day: D365 FinOps and Data Integration with Azure Logic Apps In this session we will talk about the importance of having a Data integration strategy and how Azure Logic...

Read More
Lifecycle Management of Azure blob
Dec05

Lifecycle Management of Azure blob

Every data set has a unique lifecycle. Early in the lifecycle, users tend to access some of the data in the set, but not all of the data. As the data set ages, access to all of the data in the set tends to dramatically reduce. Some data set stays idle in the cloud and is rarely accessed after it’s stored. Some data expires within a few days or months after it’s created. Other data is… Continue Reading...

Read More
Resubmitting from an Action in Logic Apps Workflows
Dec04

Resubmitting from an Action in Logic Apps Workflows

Resubmitting feature seeks to provide customers with more control over how they resubmit failed transactions and avoiding data duplication or increasing new operational friction. Earlier, if we need to reprocess the failed execution, we only had an option to select the execution and click ‘Resubmit’ . But this could potentially create duplication in the action calls that were successfully… Continue Reading...

Read More
Workflow Assistant – Standard Logic apps
Nov30

Workflow Assistant – Standard Logic apps

The workflow assistant is a chat interface to answer any questions about Azure Logic Apps, from directly within designer. You can also use it to describe existing workflow or prompt for specific answers in the context of your workflow. The chat interface provides access to Azure Logic Apps documentation and best practices without requiring you to navigate documentation or search online… Continue Reading AnithaEswaran’s...

Read More

Entre páginas y aprendizajes: Nuestro viaje escribiendo sobre Gestión de la Cadena de Suministro

Hoy les traigo una historia muy personal: nuestra travesía escribiendo “Becoming a Dynamics Supply Chain Management Functional Consultant Associate”, una obra que ya pueden encontrar en Amazon. La idea de escribir un libro siempre estuvo en mi mente, pero se hizo realidad cuando comprendí la necesidad de un material integral sobre la Gestión de la Cadena de Suministro. Junto a Mariano… Continue Reading Juan...

Read More
Loop-de-for-loop and Transaction Review
Nov30

Loop-de-for-loop and Transaction Review

Submitted by Nathan Clouse on 11/29/23. Last modified: 11/30/23 Tags:  AI Insert For What’s in a For Loop? In this article, we’ll delve into a specifics of using a For loop, inserting data into the database, and use of transaction plus some error handling too. for(int i = 0; i <=… Continue Reading Nathan Clouse’s Article on their blog Loop-de-for-loop and Transaction Review What’s in a For...

Read More
How to Test Role Access Without a Test Account in D365FO
Nov29

How to Test Role Access Without a Test Account in D365FO

For a recent project, I needed the ability to test custom role access within a D365FO environment but was having a difficult time getting a test account created to assign this access to. My personal user had SysAdmin access, was there anyway for me to be able to test role access with just my user account? Here is the solution I came up with! Solution The idea that I had was to have a simple… Continue Reading Alex’s Article...

Read More
Deploy A D365 Environment
Nov27

Deploy A D365 Environment

In order to debug or develop new custom code you need to deploy a D365 environment. There are multiple different types of environments with different capabilities. In this article, learn how to deploy a cloud-hosted environment and how it is used. First, this environment is hosted in Azure. Next, users can access the front end… Continue Reading → The post Deploy A D365 Environment appeared… Continue Reading...

Read More
Field Level Security for Custom Field Extensions in D365FO
Nov20

Field Level Security for Custom Field Extensions in D365FO

This blog post was co-authored by Sarah Guthrie a Senior Consultant at Protiviti Have you ever wondered how you can utilize security to restrict sensitive access in Dynamic 365FO? One way to accomplish this is by using field level security. This can serve as a valuable gatekeeper, ensuring that a highly sensitive pages are restricted to only necessary editable fields. For out of the box… Continue Reading Alex’s Article on...

Read More
Using ATL with Local Telemetry
Nov19

Using ATL with Local Telemetry

Submitted by Nathan Clouse on 11/19/23. Last modified: 11/19/23 Let’s collect some telemetry when using ATL in batch. Following on up this article, I thought it would be interesting to collect some telemetry on what happens when we use ATL to create a bunch of activity. First, let’s review what we were doing with ATL in the referenced article: Create a Sales Order with 1 line Adjust in… Continue Reading Nathan...

Read More
OData query options with D365F&O (Part 1)
Nov14

OData query options with D365F&O (Part 1)

As we all know, OData provides a standardized way for applications like D365F&O to expose their data, making it easier for developers and IT pros to work with, integrate, and leverage the data for a wide range of purposes. Though Odata querying is familiar to us, I will give a brief walkthrough of various CRUD operations with D365F&O. FILTER and COUNT Below query filters the Customer… Continue Reading...

Read More
X++ Development: Boost your Development Skills with Proven Tips and Tricks
Nov13

X++ Development: Boost your Development Skills with Proven Tips and Tricks

Are you ready to take your X++ development skills to the extreme? In this high-energy session explore advanced techniques and proven tips and tricks to help you turbocharge your productivity and take your development game to the next level. Nathan Clouse and I share our insider knowledge and experience, showcasing a range of practical tips… Continue Reading → The post X++ Development: Boost… Continue Reading...

Read More
Database Inserts and Performance
Nov12

Database Inserts and Performance

Submitted by Nathan Clouse on 11/11/23. Last modified: 11/11/23 Tags:  performance Insert Preamble There are several different ways to create records using X++. First, the most common will be to use a record buffer. By far and away the most common but we’re in how we’re inserting data in X++. I’d list the ways of… Continue Reading Nathan Clouse’s Article on their blog Database Inserts and...

Read More
Hidden Feature Flag Changing How User Licensing is Performed in D365FO
Nov06

Hidden Feature Flag Changing How User Licensing is Performed in D365FO

In the past I written and presented on the topic of user licensing in D365FO, the methodology used has not really changed since October 2019 when Microsoft released their new ‘privilege based licensing’. Recently though I was contacted about some interesting behavior on how D365FO was reporting particular licenses. I did a deeper dive into why this was and wanted to share my findings. The… Continue Reading...

Read More
D365 TTSBegin and TTSCommit
Nov06

D365 TTSBegin and TTSCommit

Whenever you are changing data it is important to make changes in a consistent and safe manner. D365 ttsBegin and ttsCommit statements in x++ are the key to doing this in Microsoft Dynamics 365 for Finance and Operations. They mark the beginning and end of a transaction block of code, containing changes to data that… Continue Reading → The post D365 TTSBegin and TTSCommit appeared first on

Read More
Users can extract the tables list from Data entity – D365F&O
Nov02

Users can extract the tables list from Data entity – D365F&O

We are aware that Data Entities in D365F&O represent a specific data object, typically corresponding to a table or view in the underlying database. They define the structure and attributes of the data they represent. From a technical background , I have fair idea on the tables referred in a data entity. But for an external user who needs this information and without a developer help,… Continue Reading AnithaEswaran’s...

Read More
Azure Logic Apps and Azure API Management: A Symphony of Integration
Nov01

Azure Logic Apps and Azure API Management: A Symphony of Integration

Hello, integration maestros! welcome to another symphony of integration that will harmonize your understanding of Azure Logic Apps and Azure API Management (APIM). In this orchestration of data and API, i invite you to take a front-row seat in the theater of API connectivity. Data flows like a cosmic symphony, and the harmony of information is the secret of unlocking success, Azure logic… Continue Reading adalhix’s Article...

Read More
Data entity Export/Import for Feature Management
Nov01

Data entity Export/Import for Feature Management

A data entity that is named Feature management lets you export the Feature management settings from one environment and then import them into another environment. This entity updates only existing features. The business logic in the entity also helps guarantee that the same rules that are used on the Feature management workspace will be applied when the import is done. For example, you… Continue Reading AnithaEswaran’s...

Read More
End of mainstream support for Microsoft Dynamics AX 2009, Dynamics AX 2012, Dynamics AX 2012 R2, and Dynamics AX 2012 R3
Oct31

End of mainstream support for Microsoft Dynamics AX 2009, Dynamics AX 2012, Dynamics AX 2012 R2, and Dynamics AX 2012 R3

Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended on October 9, 2018. Security hotfixes were provided for those three versions through the extended support period, which ended on April 12, 2022 Mainstream support for Dynamics AX 2012 R3 ended on October 12, 2021. Only security hotfixes will continue to be provided through the… Continue Reading AnithaEswaran’s...

Read More
D365 – Overriding code with a hack(100% meaningless)
Oct30

D365 – Overriding code with a hack(100% meaningless)

The following blogpost is 100% meaningless and can in no circumstances be used for anything other than better understanding Dynamics 365 code and playing around. What I’m about to show will NOT help you in any way, or make you more happy. When developing in Visual Studio you are restricted to make overrides to any … Continue reading D365 – Overriding code with a… Continue Reading Kurt Hatlevik’s Article...

Read More
My Experience at Dynamics Communities North America Summit 2023
Oct26

My Experience at Dynamics Communities North America Summit 2023

Last week was one of my favorite weeks of the year professionally with the Dynamics Communities North America Summit conference this year hosted in Charlotte, North Carolina. I wanted to share the sights of the conference from my experience! Dynamics 365 Finance & Operations Security Overview Academy Class My Summit week started off with teaching a pre-conference academy class where we… Continue Reading Alex’s Article...

Read More
DDMRP calculation
Oct23

DDMRP calculation

Now it’s time ! After introducting DDMRP and Inventory positioning, followed by Buffer Level Definition and Calculation, it’s time to run the DDMRP after having understood and use the previous buffers and inventory positioning. How it works ? Well, basically, nothing changes regarding the run of Master Plan. It’s exactly the same from a functional setup. The DDMRP will apply only for… Continue Reading Yohann ROLLAND’s...

Read More
Dynamics 365 : Performance benefits of Omnichannel media management
Oct21

Dynamics 365 : Performance benefits of Omnichannel media management

Scheduled for release on Monday, October 23, 2023, Microsoft’s Omnichannel Media Management feature promises significant performance gains, particularly in eCommerce and POS. Beyond merely optimizing digital asset performance, this feature offers a range of functionalities: Key Features: Integrated Product Image Management: Dynamics 365 now includes an iframe that links directly to the site… Continue Reading Kurt...

Read More
D365FO Business event for cloud hosted environments – Error Response Status code does not indicate success : 400
Oct20

D365FO Business event for cloud hosted environments – Error Response Status code does not indicate success : 400

As we are aware Business events are used to send messages to third party applications when the active event is triggered. When you set up business events or virtual entities in a cloud-hosted environment, you might receive the following error message: Response Status code does not indicate success : 400 ({“error”:”invalid_client”,”error_description”;”Expected aud… Continue Reading...

Read More

Adiós “Export to Data Lake”

Bienvienido “Synapse Link para Dataverse” El Gran Cambio:Si has estado utilizando la funcionalidad de “exportar a Data Lake” dentro de las aplicaciones de Finance and Operations, hay una emocionante transición. Microsoft está introduciendo “Synapse Link para Dataverse”, con el objetivo de proporcionar a los usuarios una experiencia unificada y sin interrupciones directamente dentro del…...

Read More
‘Update a record’ action using FinOps connector in Logic apps
Oct18

‘Update a record’ action using FinOps connector in Logic apps

If you want to updates a single record in an entity using Logic apps, we have two options Use Odata URL directly in the POST method like below PATCH URL/data/SalesOrderPools(PoolId=’04’,dataAreaId=’usmf’) BODY { “PoolName”: “Updated text” } Second option is via logic apps connector. It is tricky to understand the field notation. But once we get the grip, it is easy If the… Continue...

Read More
Number sequence set up for SmmContactPersonId – D365F&O
Oct10

Number sequence set up for SmmContactPersonId – D365F&O

There are many changes occuring with the latest updates in D365F&O. Few of them, though minor takes our time during troubleshooting. One such challenge was finding Number sequence set up for SmmContactPersonId. Earlier it was present in ‘Sales and Marketing -> Set up -> Parameters -> Number sequence’. We had to spend an hour to hunt for this set up as it is not seen in the above path…. Continue Reading...

Read More
Setting the correct time zone for service accounts in Microsoft Dynamics 365
Oct09

Setting the correct time zone for service accounts in Microsoft Dynamics 365

The setting of the correct time zone for service accounts in Microsoft Dynamics 365 is crucial for accurate business logic execution, particularly when dealing with time-sensitive functionalities like order deadlines. Given your interest in Dynamics 365, eCommerce, and Supply Chain, this topic is indeed pertinent. Hidden within the user accounts in Dynamics 365, you’ll find … Continue reading <span… Continue...

Read More
Dynamics Communities Summit North America 2023 Speaking Activities
Oct09

Dynamics Communities Summit North America 2023 Speaking Activities

We are officially one week out from Dynamics Communities Summit North America 2023 conference and looking forward to a great event, here is a listing of my speaking engagements during the conference. Security Overview of D365FO – Academy Monday Oct 16th 8:00 AM – 5:00 PM Location: E212CD D365FO Telemetry Data Overview Tuesday Oct 17th 4:15 PM – 5:15 PM Location: W209B D365FO General Session –… Continue...

Read More
Easy identification of D365FO Environments – Chrome extension
Oct06

Easy identification of D365FO Environments – Chrome extension

While working on multiple projects or environments, we will always have various windows left open . Rather than checking the Address bar every time , if we have some extension which highlights the environment name in the active window, that would be a life saver. I am using the chrome extension ‘Environment tagger’ which helps me to identify the active window tagged with a label.

Read More
SSMS – Color pattern to differentiate various environments
Oct06

SSMS – Color pattern to differentiate various environments

Being a technical, my SSMS window will have multiple active connections , thus at times it will be perplexful to identify the correct environment. I found the below solution long back , but thought of sharing to the community which would surely benefit people like me. SSMS has the option of choosing colors in the option ‘Connection Properties’. This option would highlight the SSMS… Continue Reading...

Read More
Using Telemetry Data for Read Auditing in D365FO
Oct03

Using Telemetry Data for Read Auditing in D365FO

One question I get quite often in D365FO revolves around the ability to capture when a record is read or viewed within D365FO. The ‘read auditing’ feature is standard in other Dynamics 365 offerings but does not exist natively in D365FO, so what can we use to achieve this outcome? One possible solution is to use the telemetry framework available within D365FO, let’s look at how this can be… Continue Reading...

Read More

Dynamics 365 Finance & Operations: ¡Entendiendo las Nuevas Actualizaciones de Servicio!

Hola a todos los entusiastas de Dynamics 365. Hoy, vamos a sumergirnos en las últimas actualizaciones de servicio de Dynamics 365 Finance & Operations. Si eres un usuario regular o un administrador de este sistema, es esencial que estés al tanto de estos cambios. ¡Vamos allá! ¿Qué está cambiando en Dynamics 365 F&O? Microsoft ha introducido cambios significativos en el calendario… Continue Reading Juan Bravo’s...

Read More
Dynamics 365 CSU – Cache is king
Oct01

Dynamics 365 CSU – Cache is king

In the Dynamics 365 eCommerce project we where implementing a pricing logic that was quite complex and required many steps to calculate a price. The prices are unique for each customer, product, and other aspects, and the prices had to be calculated each time and in real-time. But calculating prices are a time- and compute … Continue reading Dynamics 365 CSU – Cache is king Continue Reading Kurt Hatlevik’s Article on...

Read More
Latest update on Preview release of D365F&O
Sep30

Latest update on Preview release of D365F&O

Customers can take up to four service updates per year and are required to take a minimum of two service updates per year. Customers can choose to pause one update at a time. Pausing a service update can apply to the designated user acceptance testing (UAT) sandbox, production, or both environments. After the pause window ends, and if the customer hasn’t self-updated to a supported service… Continue Reading...

Read More
DDMRP : Buffer value calculation and dynamic adjustments
Sep27

DDMRP : Buffer value calculation and dynamic adjustments

After the first posts regarding the DDMRP and Inventory Positioning and buffer level calculation, let’s see how we can automatize the buffer calculations and adjust them afterwards. From the Item Coverage, let’s tick the Buffer values over time (this will blank defaulted the Min, Max and Reorder point) and move on. We will let the system calculate the buffer values. Under the Buffer… Continue Reading Yohann ROLLAND’s...

Read More
Decrypt PGP Files Seamlessly with Azure Function and Azure Logic Apps
Sep21

Decrypt PGP Files Seamlessly with Azure Function and Azure Logic Apps

Pretty Good Privacy (PGP) encryption is widely used to secure sensitive information and maintain data privacy. If you’re looking to decrypt PGP files using an Azure Function App, you’re in the right place. Objective of this article : We will explore how to decrypt PGP files using an Azure Function App. Azure Function App allows you to execute your code in a serverless environment,… Continue Reading adalhix’s...

Read More
DDMRP and buffer level definition
Sep11

DDMRP and buffer level definition

This second post (see the introduction regarding DDMRP) will describe the way buffer level are calculated. Indeed, we will here deep dive into some variables and setup mandatory to provide the correct level of buffer for each DDMRP item. You may be aware of the Min/Max approach used with the traditional MRP. When the coverage code used is Min/Max, the MRP generate planned order any time the… Continue Reading Yohann...

Read More
D365FO Data Entity Metadata
Sep07

D365FO Data Entity Metadata

I’ve written about D365FO data entities in the past and have had the opportunity to use them extensively from a ISV and consulting perspective. While working with them I have found myself at different times wanting to have a centralized source of information surrounding their metadata, the data sources used (both root data source and all data sources), and if there was a way to see… Continue Reading Alex’s Article on...

Read More