Data copy from D365 to Azure Db – Data Export Service Tool
Jun22

Data copy from D365 to Azure Db – Data Export Service Tool

This time I had a chance to work on Data Export Service tool in D365 CE to transfer the data from an entity to Azure Sql Db. Pre-requisite needed to create Data Export Profile in D365CE. Admin privileges in CE to Install the Data Export service App Azure Db Azure portal subscription to create Key Vault I am not covering the installation of Data Export service and Azure Db in this… Continue Reading AnithaEswaran’s Article...

Read More
How to Apply D365FO Extensible Data Security Based on the Current User
Jun21

How to Apply D365FO Extensible Data Security Based on the Current User

I have written in the past about Extensible Data Security (XDS) in D365FO, it has been one of my most popular posts. I often get questions about it, but one that I get quite often is wanting to apply XDS based on the current user. The use case is something along the lines of: ‘I only want a user to see sales orders/vendors/customers they created’ ‘Users should only see records where they are… Continue Reading...

Read More
How To Debug Batch Jobs In D365
Jun21

How To Debug Batch Jobs In D365

Most of the time when debugging x++ code, you can debug the current process. However sometimes code is written in such as way that certain code branches will only be run when the process is running as a batch job. In this article, I will teach you how to debug batch jobs in D365. The… Continue Reading → The post How To Debug Batch Jobs In D365 appeared first on Dynamics 365 Musings. Continue Reading peter.ramer’s...

Read More
Part 13 – Update Performance for Simple Entities
Jun21

Part 13 – Update Performance for Simple Entities

What can we learn about update performance from simple entities? Similar to how we tested insert performance for simple entities, we’re going to run similar tests to see what kind of performance we can expect with an update workload for a “simple” entity. The Tests To draw out values and differences, we’ll be testing with 2 basic test types: “Minimum” and “Maximum”, just like we have in...

Read More
Part 12 – Update Performance for Complicated Entities
Jun21

Part 12 – Update Performance for Complicated Entities

What can we learn about update performance from complicated entities? Similar to how we tested insert performance for complicated entities, we’re going to run similar tests to see what kind of performance we can expect with an update workload. The Tests To draw out values and differences, we’ll be testing with 2 basic test types: “Minimum” and “Maximum”, just like we have in the past. What…...

Read More
Understanding Microsoft Dynamics 365 Product Naming
Jun16

Understanding Microsoft Dynamics 365 Product Naming

< div class=”et_pb_section et_pb_section_0 et_section_regular”> <div class=”et_pb_row et_pb_row_0″> <div class=”et_pb_column et_pb_column_4_4 et_pb_column_0 et_pb_css_mix_blend_mode_passthrough et-last-child”> <div class=”et_pb_module et_pb_text et_pb_text_0 et_pb_text_align_left et_pb_bg_layout_light”> <div class=”et_pb_text_inner”>There is a lot...

Read More
Chain Of Command For Table Methods in D365
Jun14

Chain Of Command For Table Methods in D365

In the previous article, I explained what Chain of Command is, and how to use it in Microsoft Dynamics 365. I provided a basic example of Chain of Command, and explained what pieces are required. In this article we will look at an example of how to implement Chain of Command for Table methods. Objects… Continue Reading → The post Chain Of Command For Table Methods in D365 appeared first on

Read More
Remove $id from Custom Web Service JSON – Dynamics 365 F&O
Jun11

Remove $id from Custom Web Service JSON – Dynamics 365 F&O

Priority-Based Throttling in Microsoft Dynamics 365 Finance and Operations (F&O, SCM) is almost mandatory!  If your solution or integration architecture included the transaction orchestration being done outside of F&O (multiple OData calls within a transaction; rollback means making more OData calls), one of the things you can do to adjust it is to create a custom web service in F&O, which… Continue Reading Dag...

Read More
Export data from all legal entities using DIXF – D365 FO
Jun11

Export data from all legal entities using DIXF – D365 FO

In D365FO, if an export project is created for an entity, it exports the data only from the legal entity for which the user has triggered an export. Setting the property ‘Enable cross-company’ in the base query of the entity doesn`t help here as I observed the same behaviour. The behaviour is decided by one of the property in Data Entity. Check the value of ‘Primary company context‘… Continue Reading...

Read More
Buy Commerce Scale Unit’s, and get Device licenses included
Jun10

Buy Commerce Scale Unit’s, and get Device licenses included

There is a small, but interesting element that retailers should be aware of. If you buy Dynamics 365 Commerce Scale Unit’s you get device licenses included. It is available in the licensing guide. What does this mean? As you scale … Continue reading → Continue Reading Kurt Hatlevik’s Article on their blog Buy Commerce Scale Unit’s, and get Device licenses included There is a small, but interesting element...

Read More
Link to an Azure Logic App Run
Jun09

Link to an Azure Logic App Run

Sometimes my Azure Logic Apps are sending emails internally, both for the happy path and for exceptions.  Toon had a great post, Navigate directly to the Logic Apps run details | Your Azure Coach, explaining how to create a direct link to the Azure Logic App run.  The idea is that you could easily check out the details and correct any issues.  I’d like to add to his post the exact formula… Continue Reading Dag Calafell,...

Read More
“Error importing database : could not load the package ” Error in bacpac import
Jun09

“Error importing database : could not load the package ” Error in bacpac import

I installed a new VM for the latest PU42 and faced the below error when trying to restore the bacpac. I tried the first option on downloading the latest SQL Data tier Application Framework from the link Now , you will be able to see a DAC folder in either ‘Program Files’ or ‘Program Files (x86)Microsoft SQL Server150’ . Now use this path in import command. The command… Continue Reading...

Read More
Append Blob using Http Request trigger in Logic apps
Jun08

Append Blob using Http Request trigger in Logic apps

We use logic apps to execute some process as a recurrence or trigger APIs available in external applications. In this post, we are going to see , how to call logic apps from external application (I have used Postman here) . My example described below is simple. Pass a Customer group from Postman which triggers HttpRequest in Logic apps. Upon getting the value of the Customer group, write… Continue Reading AnithaEswaran’s...

Read More
Part 11 – Insert Performance for "Simple" Entities
Jun07

Part 11 – Insert Performance for "Simple" Entities

What can we learn about insert performance from complicated entities? Simlar to our last entry, what makes a data entity “simple”? Let’s re-run the same tests from Insert Performance For Complicated Entities but with a simple entity. I would define a simple entity as an entity that has 1 or 2 tables, can perform it’s tasks with a small amount of code, and is build to be light weight for a… Continue...

Read More
Part 10 – Insert Performance for Complicated Entities
Jun07

Part 10 – Insert Performance for Complicated Entities

What can we learn about insert performance from complicated entities? What makes a data entity complicated? What makes a data entity slow? Let’s take a look at data entity performance when inserting records and see what we can learn. First, let’s define a “complicated” entity. I would classify a complicated entity has having lots of data sources ( 5 or more ), having lots of code related to it… Continue...

Read More
How To Debug D365 Part 2
Jun04

How To Debug D365 Part 2

In this previous article I explained how to debug D365 by attaching to an existing process. This is useful if you are debugging code on objects that do not exist in your solution. In this article, I will teach you how to debug D365 objects that are in your solution. As well as set the… Continue Reading → The post How To Debug D365 Part 2 appeared first on Dynamics 365 Musings. Continue Reading peter.ramer’s Article...

Read More
How to Fix Broken Security References in D365FO
Jun03

How to Fix Broken Security References in D365FO

If you have used the Security Configuration area within D365FO to remove security layers in the past, you may have noticed that there are certain security features that still show these removed security layers. To demonstrate this we will be utilizing the Security Diagnostics feature for this blog post. For those that may not know, this feature allows you to see all roles, duties, and… Continue Reading Alex’s Article on...

Read More
Upsert the records using Copy Data tool – Data Factory
Jun02

Upsert the records using Copy Data tool – Data Factory

In one of my previous blog, I explained on copying the data from D365 to azure DB using ADF`s Copy Data tool. In that example, The tool copies/appends the data as such if there are no indices defined in the target table and throws error in presence of index. Most of our requirements would expect update if the record exists or insert if it doesnt. I am using the same tool but tweaked… Continue Reading AnithaEswaran’s...

Read More
SocrateX & Application checker
Jun02

SocrateX & Application checker

It’s been a while since I first wrote about the Application Checker in 2019, and here I am again. In this blog post, I’ll talk about SocrateX and XQuery too, and I’ll also show how to generate the files and databases used to analyze the code. If you want to know more about App Checker […] ariste.info SocrateX & Application checker Continue Reading Adrià Ariste Santacreu’s Article on their blog...

Read More
How To Create A Form In D365
Jun01

How To Create A Form In D365

In this article I will show you how to create a form in D365. Users create new forms to allow users to enter data into the system, view existing data, and interact with the system. One of the first tasks needed, is to create a table to store the data. We covered how to create… Continue Reading → The post How To Create A Form In D365 appeared first on Dynamics 365 Musings. Continue Reading peter.ramer’s Article on...

Read More
CRUD OData Entities – Postman – D365FO
May28

CRUD OData Entities – Postman – D365FO

In this post, I will demonstrate CRUD operations for an OData entity in D365FO using postman. Refer to my earlier post to set up postman and now we will proceed to execute these operations using Customer Group Entity. Base syntax for referring this entity in Postman https://D365FOURL/data/CustomerGroups This is not the entity name in FO, but ‘Public Collection Name’ in the… Continue Reading...

Read More
Aggregate function in Azure Data factory
May28

Aggregate function in Azure Data factory

This post is about using Aggregate function in ADF. Most of us are aware about using Group by in Aggregate. But we will be facing the issue of displaying other fields which are not included in the Groupby clauses. Let us see how we can bring rest of the fields as well when using Aggregate function. I have a csv file in my storage account which has a list of Accounts and their… Continue Reading AnithaEswaran’s Article on...

Read More
Batch job not executing – Ax2012
May27

Batch job not executing – Ax2012

Batch jobs can create a problem when the database is restored or refreshed from one environment to other environment. Given below the trouble shooting steps and solution to handle this issue. Check if there are any batch jobs in ‘Executing’ state . If yes, cancel them. These jobs consume most of the threads in the system.Check if the AOS is configured as ‘Batch Server’ . This… Continue Reading AnithaEswaran’s Article on...

Read More
The Impact of Multiplexing on User Licensing in Dynamics 365
May25

The Impact of Multiplexing on User Licensing in Dynamics 365

Blog Post Co-Writer This blog post was written in conjunction with Matthias Leplae. He reached out to me inquiring about my past D365FO licensing blog posts and asked why I hadn’t written about license multiplexing and to be honest it was a topic I knew about but had stayed away from because of the complexity of it. Luckily Matthias helped with this tough topic and helped write/edit the post… Continue Reading Alex’s...

Read More
How To Create A Table in D365
May24

How To Create A Table in D365

One of the first tasks you need to do to create a new form in Microsoft Dynamics 365 F&O is to create a new table. In this article I will show you how to create a table in D365. The minimal number of steps to create a table are quite simple. However, I will also… Continue Reading → The post How To Create A Table in D365 appeared first on Dynamics 365 Musings. Continue Reading peter.ramer’s Article on their blog...

Read More
Connect D365 to Azure DB – Azure Data factory
May19

Connect D365 to Azure DB – Azure Data factory

In this post, I will explain about copying data from CRM to Azure DB . This is done by using COPY DATA TOOL available in Azure Data Factory. Click on ‘Add New Resource’ in ADF. Enter the Pipeline name and description Click on ‘Create New connection’ In the ‘Service and Apps’ tab, select ‘Dynamics 365’ Enter the connection details. In authentication type,… Continue Reading...

Read More
Beta Release of D365FO Security Role Test Workspace
May19

Beta Release of D365FO Security Role Test Workspace

I recently posted a video of a new project I have been working on to help with security testing in D365FO. I am now ready to officially release the D365FO Security Test Workspace solution in a Beta state for testing and feedback so I wanted to give an overview of how it works, how to set it up, and the features it offers. Microsoft’s Answers to Security Testing In AX 2012, the Security… Continue Reading Alex’s...

Read More
Create Azure Data Factory
May19

Create Azure Data Factory

Given below simple way with screenshots to create a new Azure Data Factory(ADF) from azure portal. Go to portal.azure.com. Select Data factory from Search bar. Follow the steps from the below screenshot Click on ‘Git Configuration’ On clicking Review+Create, the system does the basic validation and throws errors if any. But with the 2 step process, there are not much… Continue Reading AnithaEswaran’s Article on...

Read More
The database is in single-user mode, and a user is currently connected to it.
May19

The database is in single-user mode, and a user is currently connected to it.

I had this issue when I tried to swap the databases after bacpac restore. “Could not rename the database ‘DbName’. The database is in single-user mode, and a user is currently connected to it” Given below the steps I followed to address this error SELECT request_session_id FROM sys.dm_tran_locks WHERE resource_database_id = DB_ID(‘DbNameWithQuotes’) On executing this statement,… Continue...

Read More
Build And Deploy A Commerce Scale Unit Package
May17

Build And Deploy A Commerce Scale Unit Package

In the past, in order to build and deploy a commerce scale unit package, we needed to build a retail deployable packaged from the Retail SDK. This has now changed. We now build a commerce scale unit package from a stand alone Visual Studio solution. And we can download that solution from GitHub. In this… Continue Reading → The post Build And Deploy A Commerce Scale Unit Package appeared… Continue Reading...

Read More
Build A Retail Deployable Package
May10

Build A Retail Deployable Package

Users with customizations to Microsoft Dynamics 365 for Commerce need to build a Retail Deployable Package. This package contains the Modern POS, Hardware station, and Self Service installer files. And until version 10.0.16, it also would contain the Retail Server files. However the Retail Server files are not built using another process. In this article… Continue Reading → The post Build A… Continue Reading...

Read More
How do you manage your slides and decks?
May04

How do you manage your slides and decks?

The more I’m involved in sales, pre-sales, and training… the more I desire for a super robust presentation management / slide library.  I have found some solutions, and I’m very interested in hearing what others are doing! PowerPoint capabilities SharePoint slide libraries are gone, but Teams is in, and OneDrive is available as well. PowerPoint has some built-in capabilities to reuse… Continue Reading Dag...

Read More
How to Allow Non Admin Users to Access Security Features in D365FO
May03

How to Allow Non Admin Users to Access Security Features in D365FO

I’ve written in the past about different security features that are native to D365FO, but in most cases these features require elevated privileges or even the System Administrator role to be accessible. But is there a way to grant these security features to normal users? Page Options -> Security Diagnostics The Security Diagnostics feature on a form allows for a user to determine which roles,… Continue Reading...

Read More
Microsoft Teams at Priority Bicycles
Apr26

Microsoft Teams at Priority Bicycles

In January 2020, NRF was hosted in New York City. Everyone involved in Retail and Commerce comes to this Big Show. From software to hardware, lots of technology is show cased. The technology company I work for was in the booth with Microsoft. Meanwhile, 15 minutes away, a group of us implemented all kinds innovative… Continue Reading → The post Microsoft Teams at Priority Bicycles appeared… Continue Reading...

Read More
Deploy Commerce Self-Service Packages
Apr26

Deploy Commerce Self-Service Packages

In Microsoft Dynamics 365 for Commerce, there are three or four installer files that you typically work with. These installers are often referred to as self-service packages. In the past, in order to deploy commerce self-service packages in D365, you needed to apply a retail deployable package in LCS. (Life Cycle Services). This required the… Continue Reading → The post Deploy Commerce… Continue Reading...

Read More
Call FO Runnable classes with dynamic parameter  from URL – D365FO
Apr23

Call FO Runnable classes with dynamic parameter from URL – D365FO

We are already familiar with calling D365FO URL menu items or forms or Runnable class. To recap, I am giving few samples below To call Display menu item from URL, https://D35FO/?cmp=EC&mi=SalesQuotationListPage https://D365FO/?cmp=EC&mi=SalesTableListPage To call a form from URL, https://D365FO/?cmp=EC&f=VendTransOpen https://D365FO/?cmp=EC&f=CustParameters To browse the data… Continue...

Read More
D365 eCommerce sites live and running
Apr19

D365 eCommerce sites live and running

Through search and connections, I have compiled a list of public sites that have implemented the Dynamics 365 eCommerce parts. This is by no means a complete list, and only represents a small subset. I have not been sponsored by any, and I only want to share with the D365 community sites that are live and running. Hopefully more can see the benefits of having a truly integrated omnichannel… Continue Reading Kurt Hatlevik’s...

Read More
How To Load D365 Debug Symbols
Apr19

How To Load D365 Debug Symbols

In a previous article we looked at how to debug in Microsoft Dynamics 365 for Finance and Operations. Now that you are debugging, is Visual Studio not stopping on your breakpoints? This could be that your D365 debug symbols are not loading. There are several settings that need to be set correctly to allow D365… Continue Reading → The post How To Load D365 Debug Symbols appeared first on

Read More

Date Transformations in Derived column – Azure Data Factory

In my Azure Data Factory journey, everyday is a new learning. Defaulting date to current date is common. I had to requirement to default the date to last date of the previous month. Thus, when I import the data in April month, the date to be set as 31.March.2021 , for May month it will have the value as 30.April.2021 and so on. With Derived column in Azure Data factory, converting the field… Continue Reading...

Read More
Tips and tricks about Requests for quotation and vendor collaboration
Apr15

Tips and tricks about Requests for quotation and vendor collaboration

Have you heard how to setup vendor collaboration ? And to be more specific make it work with requests for quotations, so the vendor is able to submit or decline a bid invitation ? Here is some tuto dealing with this topic : Process a Request for Quotation: D365 Finance and Operations | Dynamics-Tips The basic flow of an RFQ is we select our items we want to get bids for, the vendors we want to receive bids from and send the RFQ to the...

Read More
Power Automate & MSDyn365FO: A fondo (IV)
Apr13

Power Automate & MSDyn365FO: A fondo (IV)

Hace unas semanas, preparando la sesión para el Global Power Platform Bootcamp 2021, me di cuenta que la serie de artículos que había escrito sobre Power Automate & MSDyn365FO estaba incompleta…, me había dejado una de las opciones que tiene disponible el conector de Dynamics 365 Finance and Operations apps sin analizar: Ejecutar acción Ejecutar acción Desde la opción de ejecutar… Continue Reading ja.tomas’s...

Read More
How To Debug D365
Apr12

How To Debug D365

Do you need to debug D365? Are you a developer and you are not sure which service to attach to? In Microsoft Dynamics 365 for Finance and Operations there are a couple of different services that you can attach to, depending on how the system is running. In this article I will explain how to… Continue Reading → The post How To Debug D365 appeared first on Dynamics 365 Musings. Continue Reading peter.ramer’s Article on...

Read More
D365 – CustTable – fast – faster – fastest – WOW!
Apr09

D365 – CustTable – fast – faster – fastest – WOW!

I wanted to look deeper into an area that have troubled me for some time. Why are some forms very fast in D365, and some forms do not have the expected start-up time. At the end of this article you can see my finding, and I hope this will have an positive effect on user experienced performance. The form I wanted to take a deeper look into is the custTable form, as this is one of the most… Continue Reading Kurt Hatlevik’s...

Read More
Data Factory integration with D365FO – Import
Apr08

Data Factory integration with D365FO – Import

In this post, I am going to explain about the import of CustGroup using ADF to D365FO. There are many ways to import data, here I chose OData approach to bring the records. It is also possible to use DIXF which I will explain in next post. Let us start with creating a dataset for CustGroup which is in JSon Format. On previewing the data from the dataset, OData always… Continue Reading AnithaEswaran’s Article on their blog...

Read More
Filter expression in Azure Data Factory
Apr08

Filter expression in Azure Data Factory

If you are working on a bulk data, there is always a need to focus only on a particular set of data. We bring this filter in D365FO using WHERE clause in SELECT statement, do-while loop , DELETE statement etc. It is also possible to filter in Data Factory as well. I will explain in the below section. Create a container in Azure Storage Account and upload a JSON file . In my case, I am… Continue Reading AnithaEswaran’s...

Read More
D365FO User Licensing Update April 2021
Apr06

D365FO User Licensing Update April 2021

In the past, I have talked about that there are two separate licensing mechanisms in D365FO: entry point and privilege based. I have recently found that there is a third… the Dynamics 365 Licensing Guide itself. Dynamics 365 Licensing Guide This is an almost 60 page document that Microsoft releases on a semi-regular basis and gives the overview of how to license Dynamics 365, the most current… Continue Reading Alex’s...

Read More
Chain Of Command Data Entity Methods
Apr05

Chain Of Command Data Entity Methods

In the previous article, I explained what Chain Of Command is, and how to use it in Microsoft Dynamics 365. I provided a basic example of Chain of Command, and explained what pieces are required. In this article we will look at an example of how to implement Chain Of Command Data Entity methods. Objects… Continue Reading → The post Chain Of Command Data Entity Methods appeared first on

Read More
Why You Need To Be Careful When Using The MetadataSupport Library For Enums in D365FO
Apr02

Why You Need To Be Careful When Using The MetadataSupport Library For Enums in D365FO

I have used the MetadataSupport library in X++ to help get metadata information for tables, menu items, and data entities in the past. I have also used it for enums but recently found an issue when dealing with enum extensions. I initially wrote the logic to get enum metadata information like this: Which seems to work just fine, until you find an enum that contains a base enum extension, for… Continue Reading Alex’s...

Read More
Default a field value in SQL Server
Apr01

Default a field value in SQL Server

We initialise a field`s value in D365FO / Ax2012 …. (I am saying this as an example since I am from Technical Ax background ) . Similarly, we can also initialise a columns`s value in SQL Server. Use this simple command ALTER TABLE TableName ADD DEFAULT (‘DefaultValue’) FOR FieldName Example : ALTER TABLE workers ADD DEFAULT (‘Ready’) FOR ExportStatus To check if a… Continue Reading...

Read More
Delete Sales Order using Postman – D365 FO
Apr01

Delete Sales Order using Postman – D365 FO

Deleting Sales Order from Postman is pretty simple and can be repeated for multiple SOs just by changing SalesId in the parameter of the request. Let us see how this can be done Create an Authorization token. This is described hereThe output of the token will be used in the new request for Deleting the Sales OrderCreate a new Request in the Postman and name it as ‘Delete Sales Order’…. Continue Reading...

Read More