excel – Pardaan.com

I have never seen Business Central integrate with Excel like this!

Join me in a hack to explore a different type of integration between Business Central Excel. I spend a few days on a kind of “what if” exercise, check out the result in this video: Source : Hougaard.com Read more...

26 June 2024

Dynamics NAV & BC Tips & tricks

Take Control of Your Data with Excel Report Layouts in Business Central

The 2024 Wave 1 release of Dynamics 365 Business Central made enhancements to Excel report layouts, letting users and developers create their own Excel layouts for reporting. This new feature goes beyond exporting data to Excel, which has been available since the Dynamics NAV days. Instead,…

14 May 2024

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: Switching environments and companies directly in the Edit in Excel file

Today I would like to share another mini tip about Business Central, how to switch environments and companies directly in the Edit in Excel file. Source : Dynamics 365 Lab Read more...

18 July 2023

Dynamics NAV & BC Tips & tricks

7 Excel Tips For Business Central

Excel is one of the most used tools worldwide. In this post, you will learn 7 tips to export data from Business Central to Microsoft Excel. Also, you will learn how to connect OData Feed and Power Automate to Business Central. Source : Business Central Geek…

6 June 2023

Dynamics NAV & BC Tips & tricks

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…

1 September 2022

Dynamics NAV & BC Tips & tricks

Excel Reports – something new in reporting space

Last week I have been exploring the Excel Layouts which are a brand new feature in Business Central version 20 (Wave 1 2022). I did not only watch the video from the Launching Event, but I also developed one of the reports. If you want to…

12 May 2022

Dynamics NAV & BC Tips & tricks

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…

10 May 2022