D365 Business Central : Using Excel Layout for Reporting

Since Business Central 2022 Wave 1 (BC20), we have the ability to use Excel Layout for reporting. Excel layouts work the same way as Word and RDLC layouts in that they can be edited and saved back again into Business Central. With Excel layouts for Business Central reports, users can now create and edit report layouts simply by using the full capabilities in Excel such as sliders, diagrams, charts, and pivot tables. Let’s try to create one using Inventory Order Details.

Source : That NAV Guy
Read more…

Dynamics 365 Business Central: How to disable “Edit in Excel” on a specific page

With pages in Business Central that display a list of records in rows and columns, like a list of items, sale orders, or invoices, you can export the list to Microsoft Excel, and view it there. Depending on the page, you have two options for viewing in Excel.

Source : Dynamics 365 Lab
Read more…

Dynamics 365 Business Central 2022 Wave 1: introducing Excel Layouts for reporting

How many times in real world projects a customer asked you to create custom exports in Excel in order to fill a pre-defined and pre-formatted Excel report (with formulas, charts, macros and more) or to create an Excel report exactly like in a given model? Personally, I’ve lost the count…

Now with the new Excel Layout feature, this is possible directly at customer’s fingertips.

Source : Stefano Demiliani
Read more…

How to Use Data from Microsoft Dynamics 365 Business Central In Excel Using OData Feeds

Connecting to Excel with OData fields can be very powerful, not only for Power BI, but also for Microsoft Dynamics 365 Business Central. By simply connecting to a Business Central page as an OData feed, you can pull data into Excel to create pivot tables and more, opening the door to many benefits. In this How-To blog post, we demonstrate how to use Business Central OData feeds with Excel.

Source : Archerpoint
Read more…