Scenario: Sometimes consultants don't want to use the Data Management in D365 due to a lack of data structure knowledge, a short timeline, or many table relations. They want to import from Excel to all related tables in one shot using x++. Solution: Prepare a batch class for importing master data. I normally use this... Continue Reading →
Display method not found, missing module reference? – D365 FO
Display method not found, missing module reference? - D365 FO I got this error during building a new form in D365FO Errore message display method 'mcrlsMerged' defined on 'CustTable', referenced in data source 'CustTable' of form 'Prefix_CustTableListPage', returns type 'MCRMergeIndicator' which is not recognized. Are you missing a module reference? This clearly points us to... Continue Reading →
OnValidatedField table event handler method in Dynamics 365 F&O
OnValidatedField table event handler method in Dynamics 365 F&O Event handlers can be use to fire up your code without the necessary to customize and interfere on core logic and elements. On the example below i’ll create an event handler that will validate FirstName value of DirPersonName table. Open DirPersonName table and on tab Events... Continue Reading →
Deleted Actions/ OnDelete with Example – Microsoft Dynamics 365 F&O
Deleted Actions/ OnDelete with Example - Microsoft Dynamics 365 F&O Delete Actions and OnDelete property indicates how deletions in the main table are handled in the related tables or child tables. There are 3 types of options are available i.e. Cascade, Restricted & CascadeRestricted. The delete action and OnDelete property (available only for Microsoft D365... Continue Reading →
ODBC Connection in Dynamics 365 F&O
When we create the ODBC Connection in Dynamics 365 F&O? We create an ODBC connection in D365F&O when we need to read and write data on the DB from D365F&O,initially, we need a DB in SQL Server with which will make the connection. The exemple code to create connection: public void initialize() { str... Continue Reading →
Difference between RunBase and RunBaseBatch class – AX 2012 Or Dynamics 365 F&O
Difference between RunBase and RunBaseBatch class - AX 2012 Or Dynamics 365 F&O RunBase: To create a job or an Action class - a program that carries out processes, such as accepting parameters from the user and then updating records in the database - you use the RunBase framework. The framework is implemented by the RunBase... Continue Reading →
Dynamics 365 Finance & Operations – How to use chain of command in X++ (CoC)
Dynamics 365 Finance & Operations - How to use chain of command in X++ (CoC) Chain of Command (CoC) enables strongly typed extension capabilities of public and protected methods. It is an amazing piece of development capability that allows technical consultants to extend the application avoiding over-layering. Microsoft has implemented Chain on command across Classes,... Continue Reading →
How to create a new custom SSRS report in D365 F&O
How to create a new custom SSRS report in D365 F&O In this article, we will explain how to develop a new custom SSRS report from scratch using a Report Data Provider (RDP) approach in Dynamics 365 for Finance and Operations. The objects we are going to create A new SSRS report with a single (Precision) design.A DP... Continue Reading →
Difference between InMemory and TempDB tables in D365 F&O
Difference between InMemory and TempDB tables in D365 F&O There are two types of Temporary tables, TempDB tables, and InMemory tables, and the differences between them are: InMemory tablesTempDB tables1. Holds data temporarily in the client or server tier1. Holds data temporarily in the database until the scope is valid2. These tables can't be stored... Continue Reading →
Fourteen blog | Microsoft Dynamics 365 F&O 