Microsoft Dynamics 365 F&O

CAR report or Customization Analysis Report is a report generated by running a query in Dynamics 365 F&O Dev server to get the BP issues or warnings in a custom…

To check if the current user has a specific role we will have to write the following code in the appropriate place as per the requirement. UserInfo userInfo; SecurityUserRole securityUserRole;…

First step on How to send email via x++ code D365 FO, we will create a class and a static method in it as shown below /// <summary> /// Send…

OData stands for Open Data protocol is a standard way for creating and consuming APIs. It allows for the easy exposing and updating of data through web technologies, making it…

Split expression is used to extract the part of a string that is divided by a character. Expression: =Split(Fields!EmployeeName.Value.ToString(),“|”).GetValue(0).ToString() This expression is used to extract the first part of a…

update_recordset is used to handle batch updates to database, so that DB calls are not multiple due to bulk data. so it basically updates bulk data in one db call…

Basically, 2 settings we need to keep in mind for this If the above-mentioned checkbox is on and we select only related models, then only items that are in that…

Q1: Why do we prefer TempDB over InMemory tables while using them in queries for reports?Answer: Both are temporary tables but TempDB tables can be used in Joins. Q2: What…