When you create a recurring data job in Dynamics 365 (AX7) you will be asked for an application id in the "Setup authorization policy" tab. This post explains how to do the right setup : https://axbloggerblog.blogspot.com/2017/02/d365-recurring-integration-application.html
Category: Data Entities
AX / D365FO : Error : Natural key was not found for a custom table during entity creation
I am creating a new entity from a newly created custom table then i am getting an error " Natural key for the table TestEntityTable was not found". The problem is that the table uses RecId as its primary index, and the Data Entity Wizard doesn’t support tables with a RecId-based primary key. To solve I … Continue reading AX / D365FO : Error : Natural key was not found for a custom table during entity creation
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 – 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
AX – D365FO – Check execution log of a Data Entity
If something is going wrong on your Data Entity import you can check the execution log Go into your Data Entity import project anc click on "View Execution log" Here you can see a generic import error, but if you want to go deeper in detail click on "Staging log details" Here you can see … Continue reading AX – D365FO – Check execution log of a Data Entity
AX – D365FO – How to solve “Cannot generate chain of command subscription inialization code for ” error when build a data entity
Sometimes when you build a Data entity this error occur "Cannot generate chain of command subscription inialization code for...". To solve just build entire model and its referenced packages
AX / Dynamics 365 For Finance and Operations blog 