How to create a new number sequence in D365 F&O – Using X++

The main purpose of creating a new number sequence is to be used as a unique identifier, readable alphanumeric number for Master data or can be used as a business Id for transaction details records. In general, there is not any big difference between creating a new number sequence in D365FO and AX2012. To create… Read More How to create a new number sequence in D365 F&O – Using X++

Dynamics 365 FO: Import data from Excel using X++

Scenario:  Sometime consultants don’t want to use the Data Management in D365 due to lack of data structure knowledge,  short timeline or many table relations.  They want to import from an Excel to all related tables in one shot using x++. Solution:  Prepare a batch class for importing master data.  I normally use this template… Read More Dynamics 365 FO: Import data from Excel using X++

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… Read More Difference between RunBase and RunBaseBatch class – AX 2012 Or Dynamics 365 F&O

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 tables TempDB tables 1. Holds data temporarily in the client or server tier 1. Holds data temporarily in the database until the scope is valid 2. These… Read More Difference between InMemory and TempDB tables in D365 F&O