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

Enabled for Public preview General availability
Users, automatically - Dec 1, 2024

Business value

You can do reporting and ad hoc data analysis on transactions from fixed assets, projects, and service management. You can also group, summarize, and pivot data to get the insights you need without having 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.

Screenshot showing analysis on fixed assets