Sunil Garg PRINCIPAL GROUP PROGRAM MANAGE

Currently if new fields are added on a data import or export project you can see if new fields are added. So that the user is informed that the entity is updated since the last mapping date.

We wanted to use an entity InventWarehouseInventoryStatusOnHandEntity to expose data for our EDI solution however the entity exports 0 rows. Upon investigation and a lot of wasted time on customer and Microsoft side it was found/logged by Microsoft that Symptom: When exporting the data entity InventWarehouseInventoryStatusOnHandEntity from the Data Management Workspace, the entity exports 0 rows. Cause: This occurs when "Warehouse and Transportation" or "Catch Weight" keys are disabled. According to the Product group, If a data entity is composed of multiple data sources and one of them is disabled through a config key the entire data entity becomes disabled. The intent around entities is that they be used for integration scenarios with external applications. Those applications have no concept of, or business logic for, what to do when portions of a data entity are missing. Hence the entities are built with restrictions that require the configuration keys to be enabled. Suggestions are a warning or info message is displayed when an entity is exported and one of it's data sources has a configuration key that is disabled (therefore entity is disabled). This will save a lot of time investigating why this is happening/exporting no data. i.e. Configuration keys are disabled for a data source within this entity, no data will be displayed’ something like that. We are not the first people to have come across this, as it's previously logged by another business.

Currently the 'Text qualifier' checkbox need to be marked manually on each entity field. It would be useful to have a 'Select All' option - or something similar - so the user doesn't need to mark them field by field. When working with csv files, we need the text qualifier added to all fields. If it is not in the file, and there is a comma in a field value, the import will fail. Steps: 1. Go to Data management workspace 2. Click Export and create a new export project 3. Add an entity, select CSV as target format 4. On the line click on the View map function 5. Open Mapping details and check Text qualifier field

I would like to see Business Events on Data Management. This would enable event based integration. Rather than doing polling to FinOps to see if there are any changes. We would have FinOps send the changes. Advantage of this are: 1. Enables Event based integration and no polling required 2. Rather than package zip, we send the json and download URL to actual file. Easier to work with integration tools like Flow/Logic Apps 3. Scenarios like customer/vendor integration becomes possible with ease. Business event alone cant do as we need to put the trigger somewhere. Data Management already has change tracking feature. 4. Integration is not as chatty. Happy to discuss. Below are some links. Yammer thread discussing this topic. https://www.yammer.com/dynamicsaxfeedbackprograms/threads/212771033645056 I wrote a blog post: http://dynamicsnavax.blogspot.com/2019/06/event-based-integration-using-business.html Shared on GitHub: https://github.com/munib00/MSDYN365FO-EventBasedIntegration Another blog post which has done something similar. https://ffilardi.wordpress.com/2019/07/01/business-events-for-d365-finops/