OUR BLOGS

Blog Image 1

Data entity for a table without natural key

Problem definition

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.

Blog Image 1

Generating a new data entity for it ends up with the error shown below.

Blog Image 1
Blog Image 1

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 More

IData entity for a table without natural key (Posted on: 09.05.2019 at: 6.30pm) Like Tweet

Blog Image 1

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.

Solution overview

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 More

Add new Inventory dimension to D365FO (Posted on: 09.05.2019 at: 6.30pm) Like Tweet

Blog Image 1

Configure Network Printers for Print Management in D365FO

Problem definition

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.
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.
Read More

Configure Network Printers for Print Management in D365FO (Posted on: 22.1.2018 at: 6.30am) Like Tweet

D365/Dynamics AX