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 (115)

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. 
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 (115)

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.
13

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...

0 Comments

Read more... 0 Comments

Category: Data Management (115)

STATUS DETAILS
Under Review
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 (115)

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
11

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 (115)

STATUS DETAILS
Under Review
11

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 (115)

STATUS DETAILS
Needs Votes
10

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 (115)

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.

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 (115)

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.

10

Full support for deep entities in OData

Currently, OData supports atomicity strictly with a single entity or by the use of the $batch service.  The $batch service is great and has it's purpose but is very burdensome to implement.  A very common situation is to post a document (i.e. a sales order) with a header and line str...

Read more...

0 Comments

Read more... 0 Comments

Category: Data Management (115)

STATUS DETAILS
Under Review
9

Entity for project sales orders

Have the ability to upload project sales order via data management. The standard entities come really close: Extend the standard sales order header with Project ID. Extend the sales order line with the project ID, Project Category, Activity number and transaction ID.

Read more...

0 Comments

Read more... 0 Comments

Category: Data Management (115)

STATUS DETAILS
Needs Votes