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
Category: Data management
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 – Integrate D365FO and a third party application using DMF Data Package and REST API
This a good article that describes how to integrate a third party application with D365FO using Data management framework Data Packages and REST API : https://azureintegrations.com/2019/10/15/d365fo-interacting-with-data-management-frame-work-using-rest-api-for-delta-changes-on-entity/
D365FO – AX – Consume a Data Entity throught C# console application using ODATA REST API #d365fo #ax #msdyn365fo
This a good article that describes how to integrate a third party application with D365FO using C# Console application and ODATA REAST API. In this example we'll insert a new record throught a Data Entity : https://shootax.blogspot.com/2019/10/d365fo-data-integration-by-odata-part-1.html
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 – Integration between Finance and Operations apps and third-party services
See Microsoft guideline article : https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/integration-overview
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 – How to solve “The data value violates integrity constraints” while import a Data Entity #d365fo #ax #msdyn365fo
Sometimes error "The data value violates integrity constraints." can occur while importing an excel file through a Data entity. Most of the time it can be caused by blank lines that you cannot see in the excel file. To solve it just delete blank lines. So open the source file and delete them