Business Central 2024 wave 2 (BC25.1): Do ad hoc analysis on fixed assets, projects, and services (New Out-of-the-box queries)

Hi, Readers.
Dynamics 365 Business Central 2024 wave 2 (BC25) is generally available. More details: General availability: Dynamics 365 Business Central 2024 release wave 2 (BC25).

I will continue to test and share some new features that I hope will be helpful.

Do ad hoc analysis on fixed assets, projects, and services:

Do reporting and ad hoc data analysis on transactions from fixed assets, projects, and service management: group, summarize, and pivot data to give you the insights you need without the need to run a report.

https://learn.microsoft.com/en-us/dynamics365/release-plan/2024wave2/smb/dynamics365-business-central/do-ad-hoc-analysis-fixed-assets-projects-services?wt.mc_id=DX-MVP-5004336

In 2023 release wave 2, Microsoft introduced the ability to do data analysis on an AL query. More details: Business Central 2023 wave 2 (BC23): Analyze, group, and pivot data on queries using multiple tabs (In-client Analysis mode in Query)

Now, 2024 release wave 2 has out-of-the-box queries designed to make ad hoc analysis easier for fixed assets, projects, and services.

• The query for fixed assets was released in 25.0
• The query for service management was released in 25.1

PS: Please note that only Fixed Assets Ad-hoc Analysis (123) is included in BC25.0

For Example: Fixed Assets Ad-hoc Analysis (123)

The fixed assets ad hoc analysis query joins data from fixed asset ledger entries to master data tables, such as the Fixed Asset, Fixed Asset Class, Fixed Asset Subclass, Fixed Asset Location, and Depreciation Book tables. When you open the query, you can slice and dice data about fixed assets any way you like. The following image shows the options that are available.

You can easily create the required analysis views through the following Copilot feature.

• Business Central 2024 wave 2 (BC25): Experience enhancements to analysis assist with Copilot
• Business Central 2024 wave 1 (BC24): Get to insights fast with Copilot-created analysis tabs (Analysis mode)

The same is true for the other two new queries.
Project Ad-hoc Analysis (486)

Service Ad-hoc Analysis (5900)

Great. Give it a try!!!😁

PS:
1. Dynamics 365 Business Central: How to make a query searchable (Add Query to Tell me)

2. Business Central 2024 wave 2 (BC25.1): Use embedded Power BI reports out of the box (In-client Power BI reports)

3. Business Central 2024 wave 2 (BC25): Use Excel reports for consolidation and fixed assets

END

Hope this will help.

Thanks for reading.

ZHU