Do ad hoc analysis on fixed assets, projects, and services
Important
Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
| Enabled for | Public preview | General availability |
|---|---|---|
| Users, automatically | - | Dec 2024 |
Business value
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.
Feature details
In 2023 release wave 2, we introduced the ability to do data analysis on an AL 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 will be released in 25.0
- The query for service management will be released in 25.1
Many of the first examples are ledger entry tables (such as fixed assets ledger entries or project ledger entries) joined to relevant tables (typically the tables where a code field on the ledger can be joined) where additional fields can enrich the analysis scenarios that people typically do on ledger entry list pages.
Example: fixed assets ad hoc analysis
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.
