AX / D365FO – Export Data Entity Enum fields labels in BYOD using Computed columns or Virtual fields

When you export a Data Entity in BYOD the base enums fields values are shown as integer values. This is a big problem because it's very difficult to understrand the real value of the field. To solve this issue you can extend the standard data entity or modify a custom one using a virtual field … Continue reading AX / D365FO – Export Data Entity Enum fields labels in BYOD using Computed columns or Virtual fields

AX / D365FO – Data Entity to extract Invoices and related Payment vouchers

If you need to extract invoices and related payment voucher numbers you can use 2 Data entities : "Customer payment journal line" or alternatively use "Customer payment journal line settled invoice" Access Data management > Export "Customer payment journal line" Data Entity Select "Customer payment journal line" Click "Export now" When completed click on "Download … Continue reading AX / D365FO – Data Entity to extract Invoices and related Payment vouchers

AX / D365FO – How to find data entity from table #ax #d365fo #msdyn365fo

Are you going crazy to find the Data Entities related to a specific table? Unfortunately you cannot do it from D365FO user interface but only from Visual Studio These are the steps to achieve the goal : Open Visual StudioOpen the table you need to search the related Data Entity and click on "Find references" … Continue reading AX / D365FO – How to find data entity from table #ax #d365fo #msdyn365fo

AX / D365FO – Add a subquery computed column in a Data Entity #d365fo #ax #msdyn365fo

I want to add a computed column in a data entity. This computed column is not a simple calculated field but the result of a subquery.This query retrieve a field from a table (VendPackingSlipVersion) which is linked to the main Data Entity Data source table (VendPackingSlipTrans). The relation bewteen Main Table and the child table … Continue reading AX / D365FO – Add a subquery computed column in a Data Entity #d365fo #ax #msdyn365fo

AX – D365FO – Categories of entities

Entities are categorized based on their functions and the type of data that they serve. The following are five categories for data entities. Parameter Functional or behavioral parameters.Required to set up a deployment or a module for a specific build or customer.Can include data that is specific to an industry or business. The data can … Continue reading AX – D365FO – Categories of entities

AX – D365FO – Create a Data Entity to export all Vendor Contact informations (Emails, Phones, etc..)

This example will show how to create a Data Entity to export all Vendor Contact informations like emails and phone numbers. First create a Data Entity (to do this read my article : https://d365ffo.com/2021/06/29/ax-d365fo-create-a-data-entity) Then you have to insert Table Data sources and link them together : Click FInish Synchronize database and Build the solution … Continue reading AX – D365FO – Create a Data Entity to export all Vendor Contact informations (Emails, Phones, etc..)