15

Add a data management option to delete records

Sometimes we need to bulk delete records and using data management would be a very convenient utility for this.  Another application I've worked with had an additional column that could be added to the import file (e.g. CSV, etc) that was called DELETE.  If the column had a cert...

Read more...

4 Comments

Read more... 4 Comments

Category: Data Management (127)

STATUS DETAILS
Declined
Ideas Administrator
Thank you for sharing this scenario. As of now, we are focussing on working on next gen import/export capability using data feeds. Also, when we work on archival and purging, deletion of mass data will be addressed. 
14

Efficiently identify all tables with data and associated entities in a gold data environment

Currently there is no way of listing all tables with data in them through the D365 front-end. This is needed in gold data environments as a critical checklist, and to identify missing entities. This would take the form of a listing (form, report) that shows all tables with records as follows: - ...

Read more...

1 Comments

Read more... 1 Comments

Category: Data Management (127)

STATUS DETAILS
Under Review
13

Export All Legal entities to Azure (BYOD)

Currently, the Export to Azure functionality in Data Management only allows you to export the "current" company/Legal Entity. I want to be able to select multiple (or even ALL) legal entities for export in one batch job, instead of running the job once per company.

Read more...

0 Comments

Read more... 0 Comments

Category: Data Management (127)

STATUS DETAILS
Completed
Ideas Administrator
Thanks for sharing this idea. This is now available since PU18 as a flighted feature. Please enable DMFEnableAllCompanyExport flight and there will be a new check box to indicate all companies on an entity when adding to a data project.

Thanks.
12

Change start time and end time in Data Management to real running time

Currently, Start time and End time which was show up when we import and export data entities are the time of internal import/export process, not the time where customer are truly experience. In example, Customer start an import project and it's take about one hour, but follow Start time and En...

Read more...

0 Comments

Read more... 0 Comments

Category: Data Management (127)

STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for your feedback.

We are not considering the suggestion at this time due to the following reason:

We are currently working on data feeds as the new design for import/export. We will take your feedback into account in the new design and ensure the job execution times are calculated properly. 

Sincerely,

Sunil Garg

Microsoft.

12

Add Created and Modify fields to all Data Entities

This information is extremely useful for audit reporting.  Where available the following fields should be included on all data entities:

CREATEDDATETIME

CREATEDBY

MODIFIEDDATETIME
MODIFIEDBY

Read more...

1 Comments

Read more... 1 Comments

Category: Data Management (127)

STATUS DETAILS
Under Review
12

Import General Journal does not support intercompany entries

Idea- allow intercompany general journals to be imported using the general journal entity in data management.

Prior versions of AX permitted the import via DIEF of intercompany general journals. D365 does not. I submitted a case and MS says they are 'considering to expand the scenarios...

Read more...

1 Comments

Read more... 1 Comments

Category: Data Management (127)

STATUS DETAILS
Needs Votes
11

Make cells in exported Excel files "Text" formatted

When Excel files are exported using data management, cells are in General format, which mean when we click into them, and they contain a number, they loose their formatting. This is particularly troublesome for strings with mandatory leading zeros, such as for GTIN14 barcodes, or for any text th...

Read more...

0 Comments

Read more... 0 Comments

Category: Data Management (127)

STATUS DETAILS
Declined
Ideas Administrator
Thanks for sharing this idea. Based on the title of this idea (since detailed description is not available) we are assuming this is about cell formatting for excel based exports in data management. Since we are working on data feeds, this will be a good use case to consider in the new work. We will take this into account in the context of data feeds.

Thanks
10

Create a Data Management Security role that does not give access to Master Data Entities

Accountants love Excel and always will. So they like to use ODATA and excel to import things like GL journals using the Microsoft Office Add-In.

This is fine when publishing back to D365 when you have tens or hundreds of lines.

When you have a journal of thousands of lines...

Read more...

0 Comments

Read more... 0 Comments

Category: Data Management (127)

STATUS DETAILS
Needs Votes
10

Allow to specify a new file for an import without having to specify the entity again

 When testing, or developing, you often need to load a new version of a sourcefile in Data Management.

Right now, you cannot just replace the existing file, you need to re-specify the entity, then browse to the file, step through 2 dialogs and then you can rerun the import.

<...

Read more...

1 Comments

Read more... 1 Comments

Category: Data Management (127)

STATUS DETAILS
Needs Votes
10

OData - Aggregation support as per the OData standards

Aggregation support such as Sum as per defined in the OData standards would be really help...

Read more...

0 Comments

Read more... 0 Comments

Category: Data Management (127)

STATUS DETAILS
Declined
Ideas Administrator

Thanks for asking for this. Once we have F&O data in Azure Data Lake (ADL) as part of the work for October 2019 release, such scenarios should be handled by lake. We can revisit this topic if ADL will not meet this requirement.

Thanks.