This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2022 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2022 Wave 2.
The second of the new functionality in the Productive with Microsoft 365 section is delegated admins can edit in Excel.
Customers often delegate support and administration to their supporting partner. When these delegated administrators need to bulk correct or insert data, Excel is the tool of choice. The add-in now empowers admins to refresh and publish to Business Central, making this a powerful tool for data manipulation.
Enabled for: users, automatically
General Availability: October 2022
Delegated administrators can now use the Excel add-in like any other user in the customer’s Azure Active Directory organization. The Edit in Excel system action in the client opens the add-in, but admins can also create new datasets in Excel directly. Use this to provide bulk data support, such as correcting data entry mistakes, importing tables from legacy systems, and making data adjustments that cannot be done via data upgrade scripts.