Purchases Overview (Power BI report)

APPLIES TO: Generally available in Business Central 2024 release wave 2 (version 25.1).

The Purchases Overview report gives a clear picture of your purchasing activities. It highlights important metrics such as

• Total purchase amounts
• Outstanding liabilities
• Invoiced purchases

The report breaks down purchase quantities by location and item category, and provides vendor information to help with financial analysis, budget management, and compliance.

Use the report

The report helps leadership and management teams track actual spending on purchasing activities, manage budgets, and evaluate vendor performance.

CEOs can use the report to keep track of purchasing activities. This report gives a clear picture of your total purchase amount, outstanding liabilities, and invoiced purchases. By analyzing purchase quantities by location and item category, and reviewing vendor information, you can gain valuable insights into your financial performance. With this information, you can make informed decisions about budget management and vendor relationships.

Purchasing managers can identify where you might be overspending or underspending. For example, you might notice that your organization spent a lot on a specific item category, but the quantity of purchases was lower than expected. You might review vendor contracts, find alternative vendors with better prices, or negotiate better terms with existing vendors. By taking these actions, you can optimize purchasing activities, reduce costs, and comply with the overall budget.

Data used in the report

The report uses data from the following tables in Business Central:

• Item Ledger Entry
• Value Entry
• Purchase Lines

Try the report

Try the report here: Purchases Overview

See also

Track KPIs with Power BI metrics
Power BI Purchasing app
Ad hoc analysis of purchasing data
Built-in purchasing reports
Purchasing analytics overview
Purchasing overview