Monthly Archives: February 2020

New Features: Managing permissions to export data to Excel

With the new version of the Business Central (2020 Wave 1) administrators have a way how to restrict users who could export data to Excel. This is common request across all industries to allow this functionality to only some users.

The permission is under the permission set “D365 Excel Export Action” and for system with own permission sets it could be done by specifying System Permission ID 6110.

Users who don’t have this permission are not able to export any data from any page (“Open in Excel” or “Edit in Excel”).

The specific action (Open or Edit) is dependent on whether the Excel Add-In in installed on the user’s computer. In the Cloud version, if user has Add-In he see both actions; however, in the On-Premise version only one of them is shown (based on whether the Add-In is installed or not). This can’t be unfortunately changed by any setup and we have to hope that it will change in the future.

All released or planned features from Microsoft Dynamics 365 Business Central 2020 Wave 1 could be found on Microsoft Docs.

CU 2020/02 for Microsoft Dynamics NAV 2016 – 2018 and Microsoft Dynamics 365 Business Central on-premises has been released

The cumulative update 2020/02 for Microsoft Dynamics NAV 2016, NAV 2017, NAV2018 and for Microsoft Dynamics 365 Business Central (2018, 2019 wave 1, 2019 wave 2) on-premises has just been released.

VersionLinks
Microsoft Dynamics NAV 2016/CU52DownloadDocumentation
Microsoft Dynamics NAV 2017/CU39DownloadDocumentation
Microsoft Dynamics NAV 2018/CU26DownloadDocumentation
Microsoft Dynamics 365 Business Central on-premises/CU16DownloadDocumentation
Microsoft Dynamics 365 Business Central Spring 2019 on-premises/CU09DownloadDocumentation
Microsoft Dynamics 365 Business Central 2019 Wave 2 on-premises/U15.3DownloadDocumentation