What I learned from community members in the Fall of 2024 (and a few of my own posts)
Kennie Nybo Pontoppidan
Principal Program Manager at Microsoft. | Helping small and medium sized companies run their business with ERP and analytics | Supporting Ukraine
I love the LinkedIn social media. Not so much for the new "AI innovations" that allow users to post AI generated content with little or no value. But for the knowledge sharing that is happening every single day within the Business Central community. I learn so much from all of you and in this post, I will highlight some of the things that I think can be of value for you too.
I have a broad taste of topics, so some of the tips below might not be relevant to you. So, I suggest you doom scroll on topics you don't care for, and CTRL+click on things that you want to explore further.
Here we go...
Excel: SUBTOTAL function
When there's a table and you need to sum your data to align with your filters, SUBTOTAL should be your go-to. Unlike SUM, SUBTOTAL dynamically adjusts to filtered data. This means your calculations update automatically when you apply filters.
Want to learn more? Check out this post https://www.dhirubhai.net/posts/amandalwalls_exceltips-dataanalysis-productivityhacks-activity-7274789202561585152-ZMVT
Click-through demo of how to install and configure the new Power BI apps
I've created a???????????-?????????????? demo?that lets you follow step-by-step instructions to set up the Power BI Finance app yourself and see it in action within Business Central.
Want to learn more? Check out this post
by Tony Q.
New newsletter for Sustainability features
New newsletter for following #Sustainability features in #MSDyn365BC.
Want to learn more? Check out this post
Filter totals in analysis mode
?Did you know that you can filter totals in analysis mode?
Want to learn more? Check out this post
by... me (I feel that I am also part of the community... :)
Need to calculate the start time for an event in telemetry?
Just had a troubleshooting call with a Business Central partner where we needed to calculate the start time for an event, given the timestamp (which is the end time for the event).Seems like this could be useful for others, so we will update this documentation article with a KQL example.
Want to learn more? Check out this post
by... myself
How to use Power BI reports in Microsoft Dynamics 365 Business Central 2024 Release Wave 2 (video)
In this [7 min] video, we'll go over the Power BI Reports in Microsoft Dynamic 365 Business Central.
Want to learn more? Check out this video
by Microsoft partner Technology Management Concepts (TMC).
How to do ad-hoc analysis on fixed assets, projects, and services
Business Central 2024 wave 2 (BC25.1): Do ad hoc analysis on fixed assets, projects, and services (New Out-of-the-box queries)
Want to learn more? Check out this post
by YUN ZHU
Reporting in Dynamics GP vs Business Central
How does all of the REPORTING compare between GP and Business Central? Check out my newest Dynamics Mindset post which covers all the angles of reporting comparison between the two systems, so you can see what is similar, what is different, and how awesome the reporting and analytics has really become in BC!
Want to learn more? Check out this post
by David Laster
Video series on migrating from Microsoft Dynamics GP to Business Central.
From the official Dynamics 365 Business Central Youtube account: An enablement video series on migrating from Microsoft Dynamics GP to Business Central.
Want to learn more? Check out this post
by Microsoft partner Mount Evans Consulting.
How to add snowflakes and reindeers to the outgoing documents from Business Central
???? It's snowing and the good people in the marketing department are dreaming big...
?? They want to add snowflakes and reindeers to the outgoing documents from Business Central. And in the 2024 release wave 2, it takes them a few minutes without the need for a developer.
Want to learn more? Check out this post
by... me
Strengths and weaknesses of Business Central (analyst report)
Microsoft Business Central has established itself as one of the most popular ERP systems for small and mid-market businesses. But what exactly is Microsoft Business Central, and how does it stack up in terms of its strengths and weaknesses?
Want to learn more? Check out this post
40 Tips and Tricks for Business Central Finance (online meetup in January)
Join Us for Our First Virtual BC Canadian Meetup! We're excited to invite you to our inaugural virtual educational session. This is a fantastic opportunity to connect, learn, and grow with fellow professionals from Microsoft Business Central and beyond. Don't miss out on this chance to expand your knowledge and network! See you on the 15th of January 2024
Want to learn more? Check out this post
Excel: Create an amount field in a pivot table rather than showing debits and credits.
In the accounting world, including data analysis with exported Business Central data, I often create an amount field in a pivot table rather than showing debits and credits. In this video, I demonstrate how to 1. Create a pivot table, 2. Add a calculated field to display the amount, and 3. Format the amount column to add commas for readability.
Want to learn more? Check out this post
Easily search for user-related entries in telemetry
Quick tip: Did you know you can easily search for user-related entries in telemetry? Just head over to the Help & Support page and request the "User telemetry ID", or copy the Telemetry ID directly from the User Card. Then, filter based on "user_Id" to get the insights you need.
Want to learn more? Check out this post
Not a Pickle Blog advent calendar (with awesome community content creators)
The holiday season is all about connection, joy, and giving—and that’s exactly what the Pathways Content Crawl is here to deliver! We’re celebrating the incredible creators who have shared their gifts with our community so far.
Want to learn more? Check out this post
RSS bot that posts to a WhatsApp community when there is a new article about Business Central
How do you keep on top of all the important Dynamics 365 BC news & new features? To help with that, I created an RSS bot that posts to a WhatsApp community when there is a new article.
Want to learn more? Check out this post
Sneak peek into Sustainability Scope 3 in Business Central
A little sneak peek into what we’re planning for automating Sustainability Scope 3 in #MSDyn365BC.
Want to learn more? Check out this post
Keynote decks and recordings of Directions EMEA 2024 (Microsoft partners only)
You can find all keynote decks and recordings of Directions EMEA (Nov 2024) here...
Want to learn more? Check out this post
by YUN ZHU
Tooltips on queries in the base app
First examples of tooltips on queries (implemented as moving page tooltips down from page fields to table fields) coming into the Business Central base app now.
Want to learn more? Check out this post
by... me me me
Video on new Power BI reports (in Danish)
[17 min video with] Fokus p? Microsoft Power BI i Dynamics 365 Business Central 2024 Release Wave 2 On-Cloud
Want to learn more? Check out this post
by Microsoft partner BDL
Inventory Accounting in Business Central
Inventory Accounting in Business Central is a passion of mine! I recently viewed a recording and heard some comments that caused me to be compelled to prepare a response. For what's is worth, here are my thoughts....
Want to learn more? Check out this post
Use Word Layouts in Business Central AL programming (video)
Did you know you can use Word Layouts in Business Central AL programming to group and organize data effectively? ??In my latest video, I explore how to:? Use tables within tables to structure your data.? Create organized, professional reports that are easy to read.
Want to learn more? Check out this post
New ad-hoc analysis query for Projects (video)
?? Excited about the new ad-hoc analysis query for Projects in #BusinessCentral 2024 Wave 2?I've got you covered! ?? Watch my latest YouTube video for a quick 0-to-60 walkthrough and see this great feature in action.
Want to learn more? Check out this post
领英推荐
Use What-If-Analysis in Excel together with Business Central data
How can you use What-If-Analysis together with Business Central data? Very useful if you want to try your scenario's on your data and share your standard scenario's with other users.
Want to learn more? Check out this post
by Bert Verbeek
New "Report Management Helper" (codeunit 9657)
?? 2024 Wave 2 (v25): New "Report Management Helper" (codeunit 9657)??
? procedure IsProcessingOnly(ReportID: Integer): Boolean
? procedure SelectedLayoutType(ReportId: Integer): ReportLayoutType
Want to learn more? Check out this post
New documentation on project reports
?? Check our new documentation on project reports. Maybe you'll discover things you did not know/use == more value for your license.
Want to learn more? Check out this post
by... myself
Updates to Excel Report Layouts within Business Central 2024 wave 2 (TenantEntraId and Named Formulas)
I finally had some time to gather together the updates that have been made to Excel Report Layouts within Business Central 2024 wave 2 release (BC25). The most impactful changes: The addition of the TenantEntraId and Named Formulas
Want to learn more? Check out this post
by Excel layouts Queen and (not crazy) cat lady Tonya Bricco-Meske
Performance in Business Central 2024 W2
What's New related to #Performance in #MSDyn365BC 2024 W2? These are my gold, silver and bronze medals. Again another super cool, fast, modern - and mature - release.
Want to learn more? Check out this post
Enhancing Security in Microsoft Dynamics 365 Business Central
?? Enhancing Security in Microsoft Dynamics 365 Business Central! ?? Do you have Dynamics 365 Business Central clients that want to tighten security and use just-in-time access for partner users? Are you a user of D365 BC and want to improve your security posture around external access?
Want to learn more? Check out this post
New documentation for manufacturing reports in Business Central
?? Just live: Updated documentation for manufacturing reports in Business Central.
Want to learn more? Check out this post
by.. me
Get audit help with Microsoft Purview
?? ???? Are you being audited? Business Central information is required. Microsoft Purview helps you. ??
Want to learn more? Check out this post
Need a Word Layout for a base report that only has RDLC layout? (video)
Do you need a Word Layout for a base report that only has RDLC layout? Easy-peasy with #msdyn365bc 2024 wave 2, and after watching my video.
Want to learn more? Check out this post
New documentation for Fixed Assets (insurance and maintenance) reports
?? Just live: Updated documentation for Fixed Assets (insurance and maintenance) reports in Business Central.
Want to learn more? Check out this post
by... me
Podcast on Analytics and reporting in Business Central? Both new features in 2024 release wave 2 and what is to come?
?? Want to learn more about analytics and reporting in Business Central? Both new features in 2024 release wave 2 and what is to come? Then check out this new episode of In the Dynamics Corner Chair pod cast
Want to learn more? Check out this video
New documentation for CRM reports in Business Central
?? Just live: Updated documentation for CRM reports in Business Central.
Want to learn more? Check out this post
by Stella (where are the snacks that smell of fish????)
Flexible and easy-to-use Financial Reports tool (video)
I know more than a few finance professionals who would love to be able to create their own financial reports. If you're one of them, check out the flexible and easy-to-use Financial Reports tool.
Want to learn more? Check out this post
How to create a blank layout for a report (video)
How to create a blank layout for a report within BC
Want to learn more? Check out this post
by YUN ZHU
Utilize a Query to gather your data from multiple tables when building out a report dataset
When we talk about reporting and analytics it’s no longer just the world of RDL and Word Report layouts or Power BI. My latest blog post focuses on how you can utilize a Query to gather your data from multiple tables when building out your report dataset. It's actually pretty easy - let me know if you have tried it out!
Want to learn more? Check out this post
by Query Queen Tonya Bricco-Meske
?? How to troubleshoot Connectivity (video)
Allow users to diagnose and resolve connection issues, such as those related to firewall settings, DNS configurations, or user authentication.
Want to learn more? Check out this post
Learn about star schemas for Power BI
We've updated a popular article introducing star schemas for Power BI in Microsoft Learn: there's also ~20 new diagrams to help explain concepts or use in your presentations. If you have not read it before, this is a great article for people who are new to data modelling in Power BI.
Want to learn more? Check out this post
by Kurt Buhler
Updated documentation for Assembly reports
?? Just live: Updated documentation for Assembly reports in Business Central.
Want to learn more? Check out this post
by... Stella, the assemby expert (does also know a thing or two about snacks that smell of fish)
Python in Excel. What has this to do with Business Central? Can you combine it?
Python in Excel. What has this to do with Business Central? Can you combine it? Read that in my newest blog!
Want to learn more? Check out this post
by Bert Verbeek
Business Central Youtube channel
?? Business Central developer, partner, or user? Get the popcorn ready... ??? Do you follow our Youtube channel for tips and tricks, news on upcoming releases, and background stories?
Want to learn more? Check out this post
by... me
Report layout lifecycle telemetry
Forgot to mention this in my post about Business Central reporting improvements yesterday...Coming in 2024 release wave 2 (25.1). KQL sample ready here if you want to test it
Want to learn more? Check out this post
by Kennie
Pheew, that was a lot of interesting posts. I hope you dived into one or two of them and learned something new.
PS.
If you liked the newsletter and think that others might benefit from it as well, please send them the signup link here:
Microsoft Dynamics 365 Business Central Consultant at Intellitec Solutions
2 个月Thank you for the mentions! I always enjoy seeing the incredible contributions from you and everyone else. Looking forward to sharing more content in 2025!
CEO/Senior BC Consultant @ Dallefeld Consulting LLC | BC/NAV Expert
2 个月WOW! I treasure trove of excellent resources. Thanks Kennie for sharing!
Microsoft MVP | ERP Solution Architect | Senior Consultant MsDyn365BC | Business Analytics
2 个月Very well said, I have always learned from the publications of great professionals and people, and we currently have a lot of shared knowledge of Business Central. Thank you very much for the mention. ?? Feliz Navidad y un próspero a?o entrante. ??
This is an excellent post with a great list of knowledge shared within the community for 2024. I, too, have learned so much from many community members and am thankful to be part of such a passionate and sharing group. Thank you for the mention. I wish you and your family a Happy Holiday season and a Healthy 2025. I look forward to seeing what you reflect upon for 2025!
Microsoft MVP ?????? Business Central Developer, Supervisor @ RSM US LLP
2 个月This is an amazing collection of community contributions! There were a few I managed to miss, so it will be great to follow up on a few of these posts! Thank you for the kind words, and sharing my content. #TogetherWeWin - The Excel Layout & Query Queen, and (not crazy) BC Cat Lady ??