Data management - more detailed error messages at import for Customer postal addresses entity
When importing data from Excel into the Customer postal addresses entity, if the data is not correct or not correctly formatted, the error is not detailed enough as it does not specify the line from the Excel file where the issue is. Currently the error message is only mentioning the column th...
Export Headers in CSV file to Azure data lake
Recently we came to know that while exporting table to data lake, we doesn't get Headers (Column / field name) in csv file, instead is is exported into another metadata json file. If we want to consume data into into any tool, we need to refer both file and use third party paid service. It wil...
When Override default setting is used in default order setting, some data is not output by DIXF (Incremental Push).
1.Set Override default setting to On when two or more data items are set in the default order setting. 2.Update the base data. 3.On the screen, the change is also reflected in the data for which Override default setting is set to On. However, in DIXF (Incremental Push), only the base data is out...
Sequence Column is missing in the View Map Form in D365FO version 10.0.17
When we create a project for Import or Export in Data Management in D365FO, we add the entities and click on View Map to check the mappings of the entity. Prior to version 10.0.17 there was Sequence Column in the View Map Mappings form however from 10.0.17 it is missing and it cannot be added v...
Create a OOB System admin read only role
It would be useful to have a read only role that can see all the data. Essentially a system admin read only role. This would be particularly useful through out implementations where you may have key people that will need to see the configuration settings of the golden environment, but you need ...
Improve DMF status notifications/alerts
Many of our automated imports involve a data project that is specific to a group of people (e.g. accountants in a specific company). On the data project, provide a notification email address (similar to batch jobs) to send an email when imports succeed or fail.
This scenario can be accomplished using business events. Custom business events can be implemented on a job completion (failure and/or success) which can trigger a flow as an example.
Thanks and hope this helps.
Include OData method calls in OData batches to be executed in the same transaction
Status Quo: Currently it is possible to have simple transactions using OData Batch calls. This is currently not possible for the OData methods. Idea: OData method calls should be included into the same transaction as the other OData statements. Example: "Posting product receipt" There is an ...
Full sortable Job List in the DataManagementWorkspaceMenuItem
The Data management menu contains a Job List . This List is sortable by most columns except: Status Company Sort the Job list by company: will ease the usage for a multi company usage of D365 Sort the Job list by Status: will help to see all running jobs on top of the list
This sounds like a bug. Can you share more details with screen shots via email pls? You can reach me at sunilg@microsoft.com
Let's work on this offline.
Sincerely,
Sunil Garg
DMF Entity for Sequence Groups and Sequence Values
An entity that could be used to import data necessary to populate the sequence groups and sequence values for production order sequencing in master planning would be extremely useful. Currently there are two entities (Production order sequencing sequences, Production order sequencing sequence va...
Data export. Dirty reading during export.
Make possible to use NOLOCK hint on entities during data export to BYOD on Azure SQL.
Administrator
Hi Andrew-- the data entities can be secured via role based security. For scenarios where certain users need access to read entities, such users can be granted access to such entities via a custom role. Having said that, I do feel I might be missing something here that I am not understanding the ask. If that is the case, pls drop me a note at sunilg@microsoft.com and we can discuss.
Thanks
Sunil