Inventory analytics

Path: Business functionality > Inventory > Inventory analytics · tier official · system inventory · narrative reviewed (checked by Opus)

Overview

Inventory analytics groups the ways to analyze inventory data in Business Central. The hub’s own pages give an introduction to the options (Power BI reports, financial reports, dimensions, ad-hoc analysis and built-in reports) and a guide to ad-hoc analysis. Ad-hoc analysis uses the Data Analysis feature on list pages to look at item ledger entries without running a report.

Subtopics go deeper. The Power BI inventory app covers reports, KPIs, measures and the semantic model. The Power BI inventory valuation app covers inventory value by overview, item and location. Built-in inventory and warehouse reports are the largest group, with 31 pages. Two legacy reports are marked for removal.

Start with the Inventory analytics introduction to see which tools help different roles monitor KPIs and trends. Use the Power BI apps for KPIs and trends, built-in reports for specific inventory and warehouse questions, and ad-hoc analysis to analyze item ledger entries directly from list pages.

Key points

• Ad-hoc analysis uses Data Analysis on list pages to analyze item ledger entries without running reports.
• Ad-hoc scenarios include on-hand inventory, expiring stock, returned items, throughput, and movements.
• The Power BI inventory app (16 pages) covers stock levels, bins, lots and serial numbers, supply and demand, ABC classification, and forecasting.
• The Power BI inventory valuation app (5 pages) shows inventory value by overview, item and location, with balance and variance measures.
• Built-in reports (31 pages) cover availability and planning, valuation and costs, sales and purchase analysis, item analysis, warehouse bin and shipment reports, and barcode/QR labels.
• Item analysis reports include ABC, aging, expiration, and dimensions.
• Inventory Availability Plan and Item Age Composition - Quantity are legacy reports that will be removed.

Subtopics

• Power BI inventory app (16 pages)
• Power BI inventory valuation app (5 pages)
• Built-in inventory and warehouse reports (31 pages)
• Legacy reports (will be removed) (2 pages)

More Learn pages

• Ad-hoc analysis of inventory data: Learn how to use the data analysis mode to analyze inventory data.
• Inventory analytics: Business Central has features that can help you gather, analyze, and share data from your inventory for business intelligence and decision-making in your organization.

Videos and posts

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

• What’s New: Enhanced Inventory Analytics (2026 release wave 1) (video): “abc analysis; inventory analytics; power bi reports”

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 516 “Sales Lines” · on Table 37 “Sales Line”
• Page 5119 “Sales Cycles” · on Table 5090 “Sales Cycle”
• Page 9300 “Sales Quotes” · on Table 36 “Sales Header”
• Page 9301 “Sales Invoice List” · captioned “Sales Invoices” · on Table 36 “Sales Header”
• Page 9305 “Sales Order List” · captioned “Sales Orders” · on Table 36 “Sales Header”
• Page 37022 “Inventory Overview” · captioned “Inventory Overview (Power BI)”
• Page 37023 “Inventory by Item” · captioned “Inventory by Item (Power BI)”
• Page 37024 “Inventory by Location” · captioned “Inventory by Location (Power BI)”
• Page 37026 “Item Availability” · captioned “Item Availability (Power BI)”
• Page 37027 “Gross Requirement” · captioned “Gross Requirement (Power BI)”
• Page 37028 “Scheduled Receipt” · captioned “Scheduled Receipt (Power BI)”
• Page 37029 “Inventory by Lot” · captioned “Inventory by Lot (Power BI)”
• Page 37030 “Inventory by Serial No.” · captioned “Inventory by Serial No. (Power BI)”
• Page 37031 “PowerBI Bin Contents” · captioned “Bin Contents (Power BI)”
• Page 37032 “Bin Contents by Item Tracking” · captioned “Bin Contents by Item Tracking (Power BI)”
• Page 37056 “Inventory Valuation Overview” · captioned “Inventory Valuation Overview (Power BI)”
• Page 37057 “Inventory Valuation by Item” · captioned “Inventory Valuation by Item (Power BI)”
• Page 37058 “Inventory Valuation by Loc.” · captioned “Inventory Valuation by Location (Power BI)”
• Report 704 “Inventory - Transaction Detail”
• Report 707 “Inventory - Availability Plan” · captioned “Inventory - Availability Plan (Obsolete)”
• Report 708 “Inventory Order Details”
• Report 709 “Inventory Purchase Orders”
• Report 711 “Inventory - Top 10 List” · captioned “Inventory Top 10 List”
• Report 713 “Inventory - Customer Sales” · captioned “Inventory Customer Sales”
• Report 714 “Inventory - Vendor Purchases”
• Report 716 “Inventory Cost and Price List”
• Report 723 “Item - ABC Analysis” · captioned “Item - ABC Analysis (Excel)”
• Report 813 “Inventory Picking List”
• Report 1001 “Inventory Valuation”
• Report 5806 “Item Charges - Specification”
• Report 5807 “Item Age Composition - Qty.” · captioned “Item Age Composition - Quantity (Obsolete)”
• Report 5808 “Item Age Composition - Value” · captioned “Item Age Composition by Quantity and Value”
• Report 5809 “Item Expiration - Quantity”
• Report 7150 “Item Dimensions - Detail”
• Report 7151 “Item Dimensions - Total”
• Report 7313 “Whse. Shipment Status” · captioned “Warehouse Shipment Status”
• Report 7319 “Warehouse Bin List”
• Report 7320 “Whse. Adjustment Bin” · captioned “Warehouse Adjustment Bin”
• Page 36951 “PowerBI Reports Setup” · captioned “Power BI Reports Setup” · on Table 36951 “PowerBI Reports Setup” · via Power BI inventory app
• Page 37025 “Purchase and Sales Quantity” · captioned “Purchase and Sales Quantity (Power BI)” · via Power BI inventory app
• Page 37064 “Inventory Report” · captioned “Inventory Report (Power BI)” · via Power BI inventory app
• Page 37065 “Inventory Valuation Report” · captioned “Inventory Valuation Report (Power BI)” · via Power BI inventory valuation app
• Page 37110 “Inventory Forecasting” · captioned “Inventory Forecasting (Power BI)” · via Power BI inventory app
• Page 37111 “PowerBI ABC Analysis” · captioned “ABC Analysis (Power BI)” · via Power BI inventory app
• Report 705 “Inventory Availability” · via Built-in inventory and warehouse reports
• Report 706 “Status” · via Built-in inventory and warehouse reports
• Report 718 “Inventory - Sales Back Orders” · via Built-in inventory and warehouse reports
• Report 719 “Inv. Availability Plan” · captioned “Inventory - Availability Plan (Excel)” · via Built-in inventory and warehouse reports
• Report 720 “Item/Vendor Catalog” · via Built-in inventory and warehouse reports
• Report 5701 “Item Substitutions” · via Built-in inventory and warehouse reports
• Report 6625 “Item GTIN Label” · via Built-in inventory and warehouse reports
• Report 6626 “Reference No Label” · captioned “Reference No. Label” · via Built-in inventory and warehouse reports
• Report 6627 “SN Label” · via Built-in inventory and warehouse reports
• Report 6628 “Lot No Label” · via Built-in inventory and warehouse reports
• Report 99001048 “Planning Availability” · captioned “Planning Availability (Obsolete)” · via Built-in inventory and warehouse reports

Learn also names 1 object with no object page: report/990003804.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.