Features of Dynamics D365 Finance and Operation and Axapta

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

Greetings, In today's blog post, we will explore some useful tricks for working with Microsoft Excel add-ins. Specifically, we will cover how to create, modify, update, and delete data across multiple legal entities within Microsoft Dynamics 365 Finance and Operations. Scenario: Suppose you need to perform multiple create, delete, and update operations across different legal entities on a specific form. This can be a time-consuming and laborious task if done manually. Fortunately, there is an alternative solution using MS Excel add-ins, which we will demonstrate in this post. Prerequisites: This technique applies to forms that have a corresponding data entity. Microsoft Excel 2016 or a higher version must be installed on your system. Microsoft Dynamics Excel add-ins must be properly configured within Microsoft Excel. Example: To illustrate this process, we will use the Fixed Asset Group form. However, this functionality is not limited to this form alone and can be used in any entit...