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 – Data package numbering sequences

Reference article : https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lcs-solutions/process-data-packages-lcs-solutions Microsoft Dynamics Lifecycle Services (LCS) contains multiple base data packages that you can use to reduce the implementation time. These packages contain the elements that are required in each module/area in order to meet the minimum requirements. For advanced business processes, you might have to add more entities to the list … Continue reading AX – D365FO – Data package numbering sequences

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