Data entity for a table without natural key
Data entities have been introduced in Dynamics 365 for Finance and Operations (formally Dynamics AX 7) and can be regarded as an abstraction from the physical implementation of database tables. Implemented as de-normalized views (a data entity is actually stored as a view in SQL Server) with their own set of methods, they are now key elements in data import/export and integration scenarios.
A data entity can be quickly created by adding a new item of type Data entity to the project or by right clicking on a table and selecting Create data entity Addins option. However, if the primary data source of the data entity does not have a unique index (default Rec Id index is not taken into account) you are expected to get the "The natural key not found" error message.
For this post, a simple table TestTable has been created. The table contains three fields and does not have a unique index for now.
Generating a new data entity for it ends up with the error shown below.
The error comes from the system requirement that every data entity must have a primary key defined. So, it is possible to uniquely identify each row of the data that is conveyed through a data entity. For instance, Data Management Framework always evaluates data rows coming in for uniqueness using the data entity primary key. If a data row already exists in the system then it gets selected for update, otherwise the data is inserted.
Most often, changing of an already existing index on a table to being unique cannot be considered as a solution to the problem. This post is aimed at outlining several workarounds of how the issue can be overcome with "little blood" Read MoreIData entity for a table without natural key (Posted on: 09.05.2019 at: 6.30pm) Like Tweet
Add new Inventory dimension to D365FO
This topic provides a high-level overview of how to add new inventory dimensions through extensions. It also includes information about how to access a sample application that contains an actual implementation.
The cornerstone in this solution is that multiple roles participate in the life cycle of adding new inventory dimensions through extensions. The following description simplifies and generalizes this solution, however, in real life there is overlap between the roles, and sometimes it might even be the same person filling several roles. Read MoreAdd new Inventory dimension to D365FO (Posted on: 09.05.2019 at: 6.30pm) Like Tweet
Configure Network Printers for Print Management in D365FO
I faced an issue recently where I was trying to print a report directly to printer but Print Management Settings didn’t show any Printers option.Configure Network Printers for Print Management in D365FO (Posted on: 22.1.2018 at: 6.30am) Like Tweet
In AX 2012 we had to perform setup in AX 2012 Server Configuration to print documents or report to connected printers. In Dynamics 365 for Finance and Operations, Enterprise Edition you need to install and setup Document Routing Agent in your system and activate Network Printers in D3FOE for printing.