---
id: topic/business-central/business-functionality/purchasing/purchasing-analytics
type: topic
title: Purchasing analytics
summary: Purchasing analytics in Business Central covers the Power BI Purchases app, built-in purchasing and payables reports, legacy reports marked for removal, and ad-hoc analysis with the Data Analysis feature. It answers questions about which report or tool fits a purchasing, vendor, or spend question and what each one shows.
tier: official
language: en
system: purchasing
review:
  state: reviewed
  by: opus
  at: "2026-10-07T05:20:55.174Z"
  flags: []
generated:
  at: "2026-10-08T00:04:31.553Z"
  pipeline: 0.2.0
  prompts:
    hub-topic: 1
  input_hash: 72ae8c0f550b80ee5141c97fab2f04a68fbbeefe6d5c1fbfff8c3e173f4a02b0
evidence:
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-actual-vs-budget
    title: Actual vs. Budget (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/ad-hoc-analysis-purchasing
    title: Ad-hoc analyses in purchasing
    date: "2024-04-29"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-322
    title: Aged Accounts Payable (report)
    date: "2024-12-16"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-4403
    title: Aged Accounts Payables (Excel report)
    date: "2024-12-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchasing-analytics-overview
    title: Analytics in purchasing
    date: "2025-10-03"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-daily-purchases
    title: Daily Purchases (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-2502
    title: Day Book Vendor Ledger Entry (report)
    date: "2026-03-08"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-6102
    title: E-Doc Sample Purchase Invoice report
    date: "2026-09-18"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-709
    title: Inventory Purchase Orders (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-714
    title: Inventory Vendor Purchases (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-720
    title: Item/vendor catalog (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-key-purchase-influencers
    title: Key Purchase Influencers (Power BI Report)
    date: "2025-09-30"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-moving-annual-total
    title: Moving Annual Total (MAT) (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-moving-averages
    title: Moving Averages (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-319
    title: Payments on Hold (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-period-over-period
    title: Period-Over-Period (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-app
    title: Power BI Purchase app
    date: "2025-12-16"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-app-semantic-model
    title: Power BI Purchases app semantic model
    date: "2026-07-03"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-purchase-forecasting
    title: Purchase Forecasting (Power BI Report)
    date: "2025-09-30"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-purchase-quote-overview
    title: Purchase Quote Overview (Power BI Report)
    date: "2025-09-30"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-409
    title: Purchase Reservation Availability (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-312
    title: Purchase statistics (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-purchases-by-item
    title: Purchases by Item (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-purchases-by-location
    title: Purchases by Location (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-purchases-by-purchaser
    title: Purchases by Purchaser (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-purchases-by-vendor
    title: Purchases by Vendor (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-purchases-decomposition
    title: Purchases Decomposition (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-kpis
    title: Purchases KPIs and measures (Power BI)
    date: "2024-11-06"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-purchases-overview
    title: Purchases Overview (Power BI Report)
    date: "2024-10-31"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-purchase-return-overview
    title: Purchases Return Overview (Power BI Report)
    date: "2025-09-30"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/purchase-reports
    title: Purchasing reports and analytical tasks
    date: "2026-09-18"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-1322
    title: Standard Purchase Order report
    date: "2026-09-18"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-304
    title: Vendor - Detail Trial Balance (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-301
    title: Vendor - List (report)
    date: "2024-10-18"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-308
    title: Vendor - Order Detail (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-307
    title: Vendor - Order Summary (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-311
    title: Vendor - Top 10 List (report)
    date: "2024-12-16"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-4404
    title: Vendor - Top 10 List Excel (Excel report)
    date: "2024-12-15"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-329
    title: Vendor - Trial Balance (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/reports/report-320
    title: Vendor Item catalog (report)
    date: "2024-10-14"
    commit: null
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/ad-hoc-analysis-purchasing
    - https://learn.microsoft.com/dynamics365/business-central/purchasing-analytics-overview
  objects:
    - object/page/29
    - object/page/518
    - object/page/9306
    - object/page/9307
    - object/page/36951
    - object/page/36996
    - object/page/37009
    - object/page/37010
    - object/page/37011
    - object/page/37012
    - object/page/37013
    - object/page/37014
    - object/page/37015
    - object/page/37016
    - object/page/37017
    - object/page/37018
    - object/page/37019
    - object/page/37020
    - object/page/37021
    - object/page/37025
    - object/page/37061
    - object/page/37112
    - object/page/37115
    - object/page/37116
    - object/page/37117
    - object/page/37118
    - object/report/301
    - object/report/304
    - object/report/307
    - object/report/308
    - object/report/311
    - object/report/312
    - object/report/313
    - object/report/319
    - object/report/320
    - object/report/322
    - object/report/329
    - object/report/409
    - object/report/707
    - object/report/709
    - object/report/714
    - object/report/716
    - object/report/720
    - object/report/1322
    - object/report/2502
    - object/report/4403
    - object/report/4404
    - object/report/6102
  features: []
  topics:
    - topic/business-central/business-functionality/purchasing
    - topic/business-central/business-functionality/purchasing/purchasing-analytics/power-bi-purchasing-app
    - topic/business-central/business-functionality/purchasing/purchasing-analytics/built-in-purchasing-reports
    - topic/business-central/business-functionality/purchasing/purchasing-analytics/legacy-reports-will-be-removed
  localizations: []
  videos: []
  posts: []
  guidelines: []
learn_toc_path:
  - Business functionality
  - Purchasing
  - Purchasing analytics
toc_file: business-central/TOC.md
parent: topic/business-central/business-functionality/purchasing
children:
  - topic/business-central/business-functionality/purchasing/purchasing-analytics/power-bi-purchasing-app
  - topic/business-central/business-functionality/purchasing/purchasing-analytics/built-in-purchasing-reports
  - topic/business-central/business-functionality/purchasing/purchasing-analytics/legacy-reports-will-be-removed
coverage:
  learn: 43
  code: 48
  video: 0
  blog: 0
  guideline: 0
bc_forms:
  - 29
  - 301
  - 304
  - 307
  - 308
  - 311
  - 312
  - 313
  - 319
  - 320
  - 322
  - 329
  - 409
  - 518
  - 707
  - 709
  - 714
  - 716
  - 720
  - 1322
  - 2502
  - 4403
  - 4404
  - 6102
  - 9306
  - 9307
  - 36951
  - 36996
  - 37009
  - 37010
  - 37011
  - 37012
  - 37013
  - 37014
  - 37015
  - 37016
  - 37017
  - 37018
  - 37019
  - 37020
  - 37021
  - 37025
  - 37061
  - 37112
  - 37115
  - 37116
  - 37117
  - 37118
member_hash: 5b038f184e281153335d5e600c88f7e7803193ccd5c6cf022a613d789e8ea6a0
narrative: generated
---

# Purchasing analytics

> Purchasing analytics in Business Central covers the Power BI Purchases app, built-in purchasing and payables reports, legacy reports marked for removal, and ad-hoc analysis with the Data Analysis feature. It answers questions about which report or tool fits a purchasing, vendor, or spend question and what each one shows.

Path: [Business functionality](../../business-functionality.md) > [Purchasing](../purchasing.md) > Purchasing analytics · tier official · system purchasing · narrative reviewed (checked by Opus)

## Overview

Purchasing analytics groups the ways to monitor purchasing KPIs, vendor performance, and purchasing trends. The two own pages give the entry points: an overview of analytics options (Power BI reports, ad-hoc analysis, financial reporting, data analysis, Excel integration, dimension analysis) and a page on ad-hoc analysis using the Data Analysis feature, which lets you analyze purchase orders, invoices, and vendor ledger entries without running a report.

The subtopics go deeper. The Power BI purchasing app section documents the app, its semantic model, the KPI and measure reference, and each report. The built-in reports section describes what each standard report shows and who uses it, such as aged payables, vendor balances, open purchase orders, and purchase document layouts. The legacy section lists four reports that will be removed.

Start with "Analytics in purchasing" to choose an approach. Use Data Analysis for quick questions on live data, built-in reports for standard payables and purchasing output, and the Power BI app for spend, vendor, budget, return, and trend analysis. Avoid the legacy reports in new work.

## Key points

- Analytics in purchasing is the starting page, covering Power BI, ad-hoc analysis, financial reporting, data analysis, Excel integration, and dimension analysis.
- Ad-hoc analysis uses the Data Analysis feature on purchase orders, invoices, and vendor ledger entries, with Pivot Mode and Analysis Filters, and includes a GRNI overview and payment analysis.
- The Power BI purchasing app has 20 pages covering the app, its semantic model, KPI and measure reference, and each report.
- Built-in reports (17 pages) include aged payables, vendor balances and trial balances, vendor ledger day books, open purchase orders, purchase history and statistics, and item/vendor catalogs.
- Built-in reports also cover purchase reservation availability and document layouts such as purchase orders and e-document invoice previews.
- Legacy reports marked for removal: Aged Accounts Payable, Payments on Hold, Vendor - List, and Vendor - Top 10 List.

## Subtopics

- [Power BI purchasing app](purchasing-analytics/power-bi-purchasing-app.md) (20 pages)
- [Built-in purchasing reports](purchasing-analytics/built-in-purchasing-reports.md) (17 pages)
- [Legacy reports (will be removed)](purchasing-analytics/legacy-reports-will-be-removed.md) (4 pages)

## More Learn pages

- [Ad-hoc analyses in purchasing](https://learn.microsoft.com/dynamics365/business-central/ad-hoc-analysis-purchasing): Learn how to use the data analysis mode to analyze data in purchasing.
- [Analytics in purchasing](https://learn.microsoft.com/dynamics365/business-central/purchasing-analytics-overview): Learn how to use Business Central's analytics features to monitor purchasing KPIs, perform ad-hoc analysis, and create financial 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 29 "Vendor Ledger Entries"](../../../../objects/page/29.md) · on [Table 25 "Vendor Ledger Entry"](../../../../objects/table/25.md)
- [Page 518 "Purchase Lines"](../../../../objects/page/518.md) · on [Table 39 "Purchase Line"](../../../../objects/table/39.md)
- [Page 9306 "Purchase Quotes"](../../../../objects/page/9306.md) · on [Table 38 "Purchase Header"](../../../../objects/table/38.md)
- [Page 9307 "Purchase Order List"](../../../../objects/page/9307.md) · captioned "Purchase Orders" · on [Table 38 "Purchase Header"](../../../../objects/table/38.md)
- [Page 36996 "Detailed Vendor Ledger Entries"](../../../../objects/page/36996.md) · captioned "Detailed Vendor Ledger Entries (Power BI)"
- [Page 37009 "Purchases Overview"](../../../../objects/page/37009.md) · captioned "Purchases Overview (Power BI)"
- [Page 37010 "Purchases Decomposition"](../../../../objects/page/37010.md) · captioned "Purchases Decomposition (Power BI)"
- [Page 37011 "Daily Purchases"](../../../../objects/page/37011.md) · captioned "Daily Purchases (Power BI)"
- [Page 37012 "Purchases Moving Averages"](../../../../objects/page/37012.md) · captioned "Purchases Moving Averages (Power BI)"
- [Page 37013 "Purchases Moving Annual Total"](../../../../objects/page/37013.md) · captioned "Purchases Moving Annual Total (Power BI)"
- [Page 37014 "Purchases Period-Over-Period"](../../../../objects/page/37014.md) · captioned "Purchases Period-Over-Period (Power BI)"
- [Page 37015 "Purchases Year-Over-Year"](../../../../objects/page/37015.md) · captioned "Purchases Year-Over-Year (Power BI)"
- [Page 37016 "Purchases by Item"](../../../../objects/page/37016.md) · captioned "Purchases by Item (Power BI)"
- [Page 37017 "Purchases by Purchaser"](../../../../objects/page/37017.md) · captioned "Purchases by Purchaser (Power BI)"
- [Page 37018 "Purchases by Vendor"](../../../../objects/page/37018.md) · captioned "Purchases by Vendor (Power BI)"
- [Page 37019 "Purchases by Location"](../../../../objects/page/37019.md) · captioned "Purchases by Location (Power BI)"
- [Page 37020 "Purch. Actual vs. Budget Qty."](../../../../objects/page/37020.md) · captioned "Purchase Actual vs. Budget Quantity (Power BI)"
- [Page 37021 "Purch. Actual vs. Budget Amt."](../../../../objects/page/37021.md) · captioned "Purchases Actual vs. Budget Amount (Power BI)"
- [Page 37025 "Purchase and Sales Quantity"](../../../../objects/page/37025.md) · captioned "Purchase and Sales Quantity (Power BI)"
- [Report 307 "Vendor - Order Summary"](../../../../objects/report/307.md)
- [Report 308 "Vendor - Order Detail"](../../../../objects/report/308.md)
- [Report 311 "Vendor - Top 10 List"](../../../../objects/report/311.md) · captioned "Vendor - Top 10 List (Obsolete)"
- [Report 312 "Purchase Statistics"](../../../../objects/report/312.md)
- [Report 313 "Vendor/Item Purchases"](../../../../objects/report/313.md)
- [Report 319 "Payments on Hold"](../../../../objects/report/319.md) · captioned "Payments on Hold (Obsolete)"
- [Report 320 "Vendor Item Catalog"](../../../../objects/report/320.md)
- [Report 409 "Purchase Reservation Avail."](../../../../objects/report/409.md)
- [Report 707 "Inventory - Availability Plan"](../../../../objects/report/707.md) · captioned "Inventory - Availability Plan (Obsolete)"
- [Report 709 "Inventory Purchase Orders"](../../../../objects/report/709.md)
- [Report 714 "Inventory - Vendor Purchases"](../../../../objects/report/714.md)
- [Report 716 "Inventory Cost and Price List"](../../../../objects/report/716.md)
- [Report 720 "Item/Vendor Catalog"](../../../../objects/report/720.md)
- [Page 36951 "PowerBI Reports Setup"](../../../../objects/page/36951.md) · captioned "Power BI Reports Setup" · on [Table 36951 "PowerBI Reports Setup"](../../../../objects/table/36951.md) · via [Power BI purchasing app](purchasing-analytics/power-bi-purchasing-app.md)
- [Page 37061 "Purchases Report"](../../../../objects/page/37061.md) · captioned "Purchases Report (Power BI)" · via [Power BI purchasing app](purchasing-analytics/power-bi-purchasing-app.md)
- [Page 37112 "Purchase Forecasting"](../../../../objects/page/37112.md) · captioned "Purchase Forecasting (Power BI)" · via [Power BI purchasing app](purchasing-analytics/power-bi-purchasing-app.md)
- [Page 37115 "Vendor Quality Analysis"](../../../../objects/page/37115.md) · captioned "Vendor Quality Analysis (Power BI)" · via [Power BI purchasing app](purchasing-analytics/power-bi-purchasing-app.md)
- [Page 37116 "Purchase Return Overview"](../../../../objects/page/37116.md) · captioned "Purchase Return Overview (Power BI)" · via [Power BI purchasing app](purchasing-analytics/power-bi-purchasing-app.md)
- [Page 37117 "Key Purchase Influencers"](../../../../objects/page/37117.md) · captioned "Key Purchase Influencers (Power BI)" · via [Power BI purchasing app](purchasing-analytics/power-bi-purchasing-app.md)
- [Page 37118 "Purchase Quote Overview"](../../../../objects/page/37118.md) · captioned "Purchase Quote Overview (Power BI)" · via [Power BI purchasing app](purchasing-analytics/power-bi-purchasing-app.md)
- [Report 301 "Vendor - List"](../../../../objects/report/301.md) · captioned "Vendor List (Obsolete)" · via [Legacy reports (will be removed)](purchasing-analytics/legacy-reports-will-be-removed.md)
- [Report 304 "Vendor - Detail Trial Balance"](../../../../objects/report/304.md) · via [Built-in purchasing reports](purchasing-analytics/built-in-purchasing-reports.md)
- [Report 322 "Aged Accounts Payable"](../../../../objects/report/322.md) · captioned "Aged Accounts Payable (Obsolete)" · via [Legacy reports (will be removed)](purchasing-analytics/legacy-reports-will-be-removed.md)
- [Report 329 "Vendor - Trial Balance"](../../../../objects/report/329.md) · via [Built-in purchasing reports](purchasing-analytics/built-in-purchasing-reports.md)
- [Report 1322 "Standard Purchase - Order"](../../../../objects/report/1322.md) · captioned "Purchase - Order" · via [Built-in purchasing reports](purchasing-analytics/built-in-purchasing-reports.md)
- [Report 2502 "Day Book Vendor Ledger Entry"](../../../../objects/report/2502.md) · via [Built-in purchasing reports](purchasing-analytics/built-in-purchasing-reports.md)
- [Report 4403 "EXR Aged Acc Payable Excel"](../../../../objects/report/4403.md) · captioned "Aged Accounts Payable (Excel)" · via [Built-in purchasing reports](purchasing-analytics/built-in-purchasing-reports.md)
- [Report 4404 "EXR Vendor Top List"](../../../../objects/report/4404.md) · captioned "Vendor - Top List (Excel)" · via [Built-in purchasing reports](purchasing-analytics/built-in-purchasing-reports.md)
- [Report 6102 "E-Doc Sample Purchase Invoice"](../../../../objects/report/6102.md) · via [Built-in purchasing reports](purchasing-analytics/built-in-purchasing-reports.md)

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