After adding EDT that extends table we came across this error: “The relation under the extended data type (EDT) ProjId must be migrated to a table relation. Consider using the EDT relation migration tool.”
To use EDT relation migration tool with Dynamics AX 2012 we need to go into:
Before we start migrating it’s good to do refresh relation data:
This might take couple of minutes but we will have latest data, especially if the table is new the tool might not pick it up.
In me scenario I have new table to which I have added ProjId and SalesId and even thou adding SalesId prompt for EDT relation I still got the migration error:
When data is successfully refreshed we can search for the table that showed the error. We can see now that fields we added under “Migration status” have “Not migrated” we need to change “Migration action” from Skip to Migrate(or Mark as ignore EDT relation).
Now we just need to click on “Migrate single table” and our EDT relations will be updated, in our case we already had relation for SalesId and migration tool noticed this and instead of creating new simply updated old relation. Now when we compile we will see that both errors disappeared meaning the relations were migrated, in this scenario the table didn’t need new relations but sometimes after this process we will see that migration tool automatically added relations for specific EDT.
Implementing a new ERP system in an organisation is always a challenge. Users question whether they will be able to cope with analysing the data flow in an integrated system without external support. The accountant wonders whether all the set-up accounts are correct. The chief technologist cannot get rid of troublesome thoughts about whether the routings and boms are set up optimally. This is why it is so important to have a reliable service team to help the company control the system in the post-implementation stage. In this article, we take a look at the issues surrounding the implementation of an ERP system and the benefits of maintaining proactive service support.
328.77 million terabytes of data are generated every day - this is the estimate for the first quarter of 2023 (1). These are massive amounts of data on a global scale. On a smaller scale, such as an enterprise, it's difficult to estimate because it depends on the organisation in question, but one thing is certain - collecting, processing and analysing this data is the key to business success today. Why is the Data Lake service so important for data analysis and reporting in Microsoft Dynamics 365 Finance and Operations? How can you tame the data by integrating Microsoft Power BI analytics with Data Lake? We have drawn up some tips.
The retail industry is still dealing with the effects of the pandemic that lasted almost three years. In addition to this, further global events are causing disruption to the supply chain or financial stability of many retailers globally. As the industry confronts new challenges shaped by economic and geopolitical factors, it also faces trends influenced by changing customer expectations and needs. Here are 5 developments and trends to watch.
An interactive, AI-powered support for sales, customer service, marketing, and supply chain - Microsoft Dynamics 365 Copilot leverages generative AI and natural language processing technology to perform simple, yet time-consuming daily tasks that workload employees but can be automated.