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 though publishing is slow and cumbersome and quite often times out. The solution appears to be to use DMF to import the journals.

This is fine but when we give the Data Management Operations User security role to a user this gives access to all data entities including Master Data. It would be extremely useful from an audit and security position if we could either manually pick the Data Entities that the role is allowed to use or if a standard role existed that only allowed access to none Master Data entities for things like entering journals.

It would also be useful to have an export only role.

Kind Regards

Phil