# Purchases Return Overview (Power BI Report)
> APPLIES TO: Business Central 2025 release wave 2 and later.
The Purchase Return Overview report tracks and analyzes purchase returns, showing
reasons for return, return rate, purchase value and the financial impact on the organization. This report summarizes key return trends by vendor, reason and type, and visualizes return metrics over time.
![Screenshot of the Purchase Return Overview Power BI report]
## Use the report
Leadership and purchasing teams use the report to identify the return trends contributing to return orders and credit memos.
For CEOs, you want to evaluate return trends to inform key business decisions. For example, you identify a particular vendor with the highest purchases-powerbi-kpis#return-rate-amount. In response, you engage with an alternative vendor to minimize returns and reduce time spent conducting product quality inspections.
As a purchasing manager, you want to identify key factors contributing to purchase returns to optimize purchasing operations. For example, you identify an increase in credits attributed to purchaser errors, impacting profit metrics. These insights empower you to invest in additional employee training to improve purchasing processes.
As a purchaser, you want to analyze return trends to ensure product quality while maintaining effective supplier relations. Using this report, you recognize a particular component has an increased credit amount over the past months, due to faulty products. Using this information, you engage with the supplier to switch to a more reliable component, decreasing return frequency.
## Key Performance Indicators (KPIs)
The Purchase Return Overview report includes the following KPIs and measures:
 purchases-powerbi-kpis#return-rate-amount
 purchases-powerbi-kpis#return-rate-qty
 purchases-powerbi-kpis#total-credit-amount
 purchases-powerbi-kpis#total-credit-qty
 purchases-powerbi-kpis#total-purchase-amount
 purchases-powerbi-kpis#no-of-outstanding-return-orders
Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.
> TIP
> You can easily track the KPIs that the Power BI reports display against your business objectives. See Track your business KPIs with Power BI metrics<track-kpis-with-power-bi-metrics>.
## Data used in the report
The report uses data from the following tables in Business Central:
 Purchase Line
 Value Entry
 Purchase Credit Line
 Purchase Invoice Line
 Reason Code
 Vendor
 Item
 Resource
 G/L Account
## Try the report
Try the report here: Purchases return overview<https://businesscentral.dynamics.com?page=37116>
> TIP
> If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.
## Related information
track-kpis-with-power-bi-metrics
Power BI Purchasing app<purchases-powerbi-app>
Ad hoc analysis of purchasing data<ad-hoc-analysis-purchasing>
Built-in purchasing reports<purchase-reports>
purchasing-analytics-overview
Purchasing overview<purchasing-manage-purchasing>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/purchases-powerbi-purchase-return-overview, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/purchases-powerbi-purchase-return-overview/
