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++

Create new inventory dimension in D365 F&O.

Short intro of Inventory Dimensions. If we look at the InventDim table, the fields can be split up in 3 groups: Product Dimensions Tracking Dimensions Storage Dimensions Apart those three groups are also 12 unassigned generic dimensions: InventDimension1 to InventDimension12. In the tracking dimensions group, fields InventProfileId_RU and InventOwnerId_RU are specified for Russian localization. those… Read More Create new inventory dimension in D365 F&O.

Dynamics 365 F&O – Apply the latest platform update to environments (LCS)

Dynamics 365 F&O – Apply the latest platform update to environments (LCS) In this post will explain how to apply the latest platform release to your Finance and Operations environment. In our example we have a new release to update (Service Update – 10.0.16), First step is to open LCS and login, after this we… Read More Dynamics 365 F&O – Apply the latest platform update to environments (LCS)

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++

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 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 look for… Read More Display method not found, missing module reference? – D365 FO

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… Read More OnValidatedField table event handler method in Dynamics 365 F&O

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… Read More Deleted Actions/ OnDelete with Example – Microsoft Dynamics 365 F&O

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