Here is the latest collection of data entities for 10.0.29 in both en-GB and en-US languages. I have added some new columns which show which countries the data entities are enabled for, and the configuration key path if a configuration key is needed to enable the data entity.
September 11, 2022
July 15, 2022
10.0.28 Data Entities for Finance & Operations
Sorry it’s taken a while to publish an updated version of the spreadsheet containing data entities and related metadata. I fully intend to release the code that I have written that does this in the future, once it has been cleaned up.
In the meantime, you can download the spreadsheet here. Please let me know what you think of this project.
2022-07-22 Update: The spreadsheet is now available in the en-US language. This version can be downloaded here.
March 11, 2022
postTargetProcess not being called on child entities in a composite entity
If you have ever done any testing and development with data entities you may have noticed that the static method postTargetProcess() does not get called for child entities in a composite data entity. For a recent project I needed this method to be called on the SalesOrderHeaderChargeV2Entity and SalesOrderLineV2Entity when data is imported using the SalesOrdersV3 composite data entity is used to import sales orders.
(more…)February 13, 2022
10.0.24 Data Entities for Finance & Operations
This blog post represents a challenge that I set myself a while ago to generate a list of data entities with underlying tables. What I ended up coding was a way to generate a spreadsheet that contains all sorts of data that would be useful for easily finding appropriate data entities for specific tasks. Need to find a data entity for Arrival Groups (ITMArrivalGroupTable) that works with data management? No problem! Need a data entity for Retail Transaction Addresses (RetailTransactionAddressTrans) that can be accessed using ODATA? Piece of cake! How about a list of all data entities that can use multi-threading? You got it!
(more…)January 8, 2022
A look at the SysDa query API
A new query API was introduced in PU22 which enables a database query to be generated and executed through a lightweight framework. This post is not meant to be a comprehensive analysis of all functionality that this framework provides, rather a look at some of the functionality in order to encourage you to look deeper into the code to help you understand what it can and cannot do.
The official Microsoft documentation can be found here: Access data by using the SysDa classes – Finance & Operations | Dynamics 365 | Microsoft Docs. Of course the best documentation is the code itself and I would recommend using the “find references” and metadata search functionality to find examples and check for any best practice violations when writing your own code as there have been subtle changes changes to the API since it has been released.
The API, which is nicknamed SysDa, is reportedly faster at generating TSQL than the current Query api and also supports set based operations. Set based deletes using multiple are possible with this API which is particularly useful since the new “in” keyword that was introduced a while ago only currently supports enums.
Microsoft are looking to replace select statements with this new api since it will make queries easier to extend – macros defining field lists or joins to inventDim will become a thing of the past.
(more…)