---
id: video/qCqe8uw8Od4
type: video
title: "What's New: Enhanced Inventory Analytics (2026 release wave 1)"
summary: "Enhanced inventory analytics in Business Central 2026 release wave 1: ABC analysis in Power BI and Excel, an Item Age Composition report, eight reports moved to Excel and Word layouts, four legacy reports to be deprecated, and subtotals and analysis views planned for 28.x."
tier: official
language: en
tags:
  - abc analysis
  - inventory analytics
  - power bi reports
  - excel layouts
  - modernization
  - analysis mode
  - legacy reports deprecation
  - supply chain risk
  - inventory posting groups
  - analysis tabs
system: inventory
review:
  state: reviewed
  by: opus
  at: "2026-10-07T22:49:33.807Z"
  flags: []
generated:
  at: "2026-10-07T22:49:33.854Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: c94436445b26e57eac0720d94a2287da7ad9d999847f61073dfabf95fd0c3303
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=qCqe8uw8Od4&t=379s
    title: "Legacy Inventory Report Deprecation: announced"
    date: "2026-04-01T12:01:02.000Z"
    commit: null
    t: 379
    quote: then we are deprecating four the the four reports will will be removed from the product over the next three release
  - kind: video
    url: https://www.youtube.com/watch?v=qCqe8uw8Od4&t=459s
    title: "Analysis Views for Item Ledger Entries: announced"
    date: "2026-04-01T12:01:02.000Z"
    commit: null
    t: 459
    quote: for item ledger entries in version 28.x we will add these four new um pre-built analysis views
  - kind: video
    url: https://www.youtube.com/watch?v=qCqe8uw8Od4&t=16s
    title: "What's New: Enhanced Inventory Analytics (2026 release wave 1)"
    date: "2026-04-01T12:01:02.000Z"
    commit: null
    t: 16
    quote: inventory analytics is actually one of the key investment areas in the analytics analytics content for this release wave
  - kind: video
    url: https://www.youtube.com/watch?v=qCqe8uw8Od4&t=51s
    title: "What's New: Enhanced Inventory Analytics (2026 release wave 1)"
    date: "2026-04-01T12:01:02.000Z"
    commit: null
    t: 51
    quote: Everything you could do back 6 12 months ago with legacy reports in IDE you can now do either with Power BI with Excel
  - kind: video
    url: https://www.youtube.com/watch?v=qCqe8uw8Od4&t=112s
    title: "What's New: Enhanced Inventory Analytics (2026 release wave 1)"
    date: "2026-04-01T12:01:02.000Z"
    commit: null
    t: 112
    quote: you are categorizing your inventory in three A B and C types. You define what's the percentage of your sales that should be class
  - kind: video
    url: https://www.youtube.com/watch?v=qCqe8uw8Od4&t=165s
    title: "What's New: Enhanced Inventory Analytics (2026 release wave 1)"
    date: "2026-04-01T12:01:02.000Z"
    commit: null
    t: 165
    quote: in the German and Swiss version of Business Central it actually had ABC analysis already whereas other localizations did not
  - kind: video
    url: https://www.youtube.com/watch?v=qCqe8uw8Od4&t=399s
    title: "What's New: Enhanced Inventory Analytics (2026 release wave 1)"
    date: "2026-04-01T12:01:02.000Z"
    commit: null
    t: 399
    quote: All of this is available in 28.0. Um And then we got some feedback
  - kind: video
    url: https://www.youtube.com/watch?v=qCqe8uw8Od4&t=413s
    title: "What's New: Enhanced Inventory Analytics (2026 release wave 1)"
    date: "2026-04-01T12:01:02.000Z"
    commit: null
    t: 413
    quote: in 28.0 versions the inventory reports do not have subsections or subtotals
  - kind: video
    url: https://www.youtube.com/watch?v=qCqe8uw8Od4&t=459s
    title: "What's New: Enhanced Inventory Analytics (2026 release wave 1)"
    date: "2026-04-01T12:01:02.000Z"
    commit: null
    t: 459
    quote: for item ledger entries in version 28.x we will add these four new um pre-built analysis views so that when you open that in
links:
  learn: []
  objects:
    - object/page/7160
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: qCqe8uw8Od4
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=qCqe8uw8Od4
published_at: "2026-04-01T12:01:02.000Z"
duration_s: 788
captions: full
audience:
  - functional consultant
  - administrator
  - partner
  - decision maker
chapters:
  - t: 0
    title: Introduction to Enhanced Inventory Analytics
  - t: 90
    title: ABC Analysis Feature
  - t: 262
    title: Modernizing Inventory Reports
  - t: 399
    title: Subtotals and Analysis Views
  - t: 477
    title: Resources and Related Topics
  - t: 538
    title: General Business Central Resources
features:
  - name: ABC Analysis in Power BI
    status: unclear
    t: 90
    verified: false
    status_source: video
  - name: ABC Analysis Excel Layout
    status: unclear
    t: 165
    verified: false
    status_source: video
  - name: ABC Analysis Setup Page
    status: unclear
    t: 239
    verified: false
    status_source: video
  - name: Item Age Composition Report
    status: unclear
    t: 314
    verified: false
    status_source: video
  - name: Excel and Word Layout Modernization
    status: unclear
    t: 360
    verified: false
    status_source: video
  - name: Legacy Inventory Report Deprecation
    status: announced
    t: 379
    verified: true
    status_source: video
  - name: Inventory Report Subtotals
    status: unclear
    t: 413
    verified: false
    status_source: video
  - name: Analysis Views for Item Ledger Entries
    status: announced
    t: 447
    verified: true
    status_source: video
  - name: Inventory Analytics Help and Discoverability
    status: unclear
    t: 273
    verified: false
    status_source: video
objects_mentioned:
  - page ABC Analysis Setup
  - table Item Ledger Entries
quotes:
  - t: 16
    text: inventory analytics is actually one of the key investment areas in the analytics analytics content for this release wave
    check: exact
  - t: 51
    text: Everything you could do back 6 12 months ago with legacy reports in IDE you can now do either with Power BI with Excel
    check: exact
  - t: 112
    text: you are categorizing your inventory in three A B and C types. You define what's the percentage of your sales that should be class
    check: exact
  - t: 165
    text: in the German and Swiss version of Business Central it actually had ABC analysis already whereas other localizations did not
    check: exact
  - t: 399
    text: All of this is available in 28.0. Um And then we got some feedback
    check: exact
  - t: 413
    text: in 28.0 versions the inventory reports do not have subsections or subtotals
    check: exact
  - t: 459
    text: for item ledger entries in version 28.x we will add these four new um pre-built analysis views so that when you open that in
    check: exact
---

# What's New: Enhanced Inventory Analytics (2026 release wave 1)

> Enhanced inventory analytics in Business Central 2026 release wave 1: ABC analysis in Power BI and Excel, an Item Age Composition report, eight reports moved to Excel and Word layouts, four legacy reports to be deprecated, and subtotals and analysis views planned for 28.x.

[Watch on YouTube](https://www.youtube.com/watch?v=qCqe8uw8Od4) · Microsoft Dynamics 365 Business Central (YouTube) · 2026-04-01 · 13:08 · tier official · reviewed (checked by Opus)

## Overview

The video presents inventory analytics as a key investment area for the release wave. It demos ABC analysis in a new Power BI app and in an Excel layout, both driven by a new ABC Analysis Setup page where threshold percentages must sum to 100 percent. The Excel layout was originally only in the German and Swiss versions and is now available in all regions.

It also covers modernizing inventory reports. Eight reports get Excel and Word layouts to replace legacy layouts, and a new Item Age Composition report shows quantity and value together. Four legacy reports will be removed over the next three release waves. Subtotals are not in 28.0 and are planned for 28.x, along with four pre-built analysis views for item ledger entries.

## Key points

- ABC analysis classifies items as A, B or C by sales percentage thresholds, defined on the ABC Analysis Setup page; the percentages must sum to 100 percent.
- The same setup serves both the Power BI app and the Excel layout for ABC analysis.
- The ABC Excel layout has a printable worksheet and an analysis worksheet sliced by ABC class and inventory posting groups; it was previously only in German and Swiss versions and is now delocalised to all regions.
- Eight reports get Excel and Word layouts replacing legacy layouts; four legacy inventory reports will be removed over the next three release waves.
- The new Item Age Composition report shows item age by quantity and value in one report.
- Inventory reports in 28.0 have no subtotals; subtotals for all new reports are planned for 28.x.
- Four pre-built analysis views for item ledger entries are planned for 28.x and can be customized or hidden through personalization.

## Chapters

- [0:00](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=0s) Introduction to Enhanced Inventory Analytics
- [1:30](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=90s) ABC Analysis Feature
- [4:22](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=262s) Modernizing Inventory Reports
- [6:39](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=399s) Subtotals and Analysis Views
- [7:57](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=477s) Resources and Related Topics
- [8:58](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=538s) General Business Central Resources

## Features

| Feature | Status | At | Evidence |
|---|---|---|---|
| ABC Analysis in Power BI | status not stated, demoed | [1:30](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=90s) |  |
| ABC Analysis Excel Layout | status not stated, demoed | [2:45](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=165s) |  |
| ABC Analysis Setup Page | status not stated | [3:59](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=239s) |  |
| Item Age Composition Report | status not stated, demoed | [5:14](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=314s) |  |
| Excel and Word Layout Modernization | status not stated, demoed | [6:00](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=360s) |  |
| Legacy Inventory Report Deprecation | announced | [6:19](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=379s) | "then we are deprecating four the the four reports will will be removed from the product over the next three release" ([6:19](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=379s)) |
| Inventory Report Subtotals | status not stated | [6:53](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=413s) |  |
| Analysis Views for Item Ledger Entries | announced | [7:27](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=447s) | "for item ledger entries in version 28.x we will add these four new um pre-built analysis views" ([7:39](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=459s)) |
| Inventory Analytics Help and Discoverability | status not stated | [4:33](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=273s) |  |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- [page 7160 "ABC Analysis Setup"](../objects/page/7160.md) at [3:59](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=239s)
- table "Item Ledger Entries" at [7:39](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=459s)

Not found in BC28-30: table "Item Ledger Entries".

## Quotes

- [0:16](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=16s) "inventory analytics is actually one of the key investment areas in the analytics analytics content for this release wave"
- [0:51](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=51s) "Everything you could do back 6 12 months ago with legacy reports in IDE you can now do either with Power BI with Excel"
- [1:52](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=112s) "you are categorizing your inventory in three A B and C types. You define what's the percentage of your sales that should be class"
- [2:45](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=165s) "in the German and Swiss version of Business Central it actually had ABC analysis already whereas other localizations did not"
- [6:39](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=399s) "All of this is available in 28.0. Um And then we got some feedback"
- [6:53](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=413s) "in 28.0 versions the inventory reports do not have subsections or subtotals"
- [7:39](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=459s) "for item ledger entries in version 28.x we will add these four new um pre-built analysis views so that when you open that in"

## Disclaimers in the video

- [6:39](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=399s) not-in-this-release: inventory reports do not have subsections or subtotals in 28.0
- [7:14](https://www.youtube.com/watch?v=qCqe8uw8Od4&t=434s) coming-later: for version 28 hopefully .1 we are adding subtotals to all the new reports