Category Archives: Administration

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.

New Features: Non-Sequential numbering

One of the most known problem, especially in systems with many users, is managing DB locking for records, that require many updates. In term of Business Central (and previously NAV too) this problem is mostly known from No. Series.


The new version of the Business Central come with new setting in No. Series called “Non-Blocking No. Series” that could heavily improve the performance of core processes.


To set No. Series as a non-blocking, user has to select “Allow Gaps in Nos.” in the No. Series. This could be used without any problem for series that does not require to be sequential (I definitely to recommend this requirements with users who are responsible for auditing and legal requirements whether the series could have spaces in numbering or not). For example, in the Czech Republic it’s possible to use this setting for Customers, Vendors, and other entity related records, even for Orders, Quotes and any other documents that are not posted into G/L under this number.

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