Computed Column/Fields in Data Entity in Microsoft Dynamics 365 For Finance and Operations Without X++ code(only SQL Statement)
Hello Friends, I am Vikas Vaish and I am back with a new topic of discussion i.e. Computed column in the data entity for D365 for Finance and Operation. Scenario: 1) We have to add any system-generated fields to our data entities like "Created By", "Created Date Time", "RecId" etc. 2) We need to create a computed field that displays data from some other table that is not part of the Data Source in our current Data entity. We can achieve the above requirement by creating computed columns and writing simple SQL statements (Without x++ code). The SQL statement can be simple or complex as per our business requirements. We can even write SQL Case, Subqueries in our SQL statement. So let have a look at how we can proceed. Solution Scenario 1: For this example let create one Data entity for the Customers (CustTable) Here we can see CustTable as the main table for the Data entity. So when the system compiles this data entity, It creates a belo...
