Freigeben über


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 create reports and do ad hoc data analysis on transactions from fixed assets, projects, and service management. You can group, summarize, and pivot data to get the insights you need without running 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 that make ad hoc analysis easier for fixed assets, projects, and services.

  • The query for fixed assets is available in version 25.0.
  • The query for service management is available in version 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, these relevant tables are the tables where a code field on the ledger connects to other tables. By adding extra fields, you enrich the analysis scenarios that people usually do on ledger entry list pages.

Example: fixed assets ad hoc analysis

The fixed assets ad hoc analysis query combines data from fixed asset ledger entries with data from master 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 explore and analyze data about fixed assets in any way you want. The following image shows the available options.

Screenshot showing analysis on fixed assets