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 management
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 – 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