Edit

Share via


Inventory Vendor Purchases (report)

The Inventory Vendor Purchases report shows a total of items purchased from vendors in a date period, grouped by items.

Value entries for each combination of a vendor and an item are summed to calculate the total invoiced quantity, cost amount, and discount amount.

The calculated cost amount includes added costs, such as item charges.

Available layouts

INTRODUCED IN: Business Central 2026 release wave 1.

The report includes different layouts for different use cases:

  • An Excel layout with worksheets designed for print and for analysis.
  • A Word layout designed for print/PDF output.

You can export either layout from the Report Layouts, edit it in Excel or Word to cater for your needs, and import it back to Business Central. To learn more, go to Creating your own report layouts.

Use cases

Analyze vendor purchases per item to manage inventory procurement and improve supply chain processes. Assess the relationship between discounts, cost amounts, and volume of item purchases.

Procurement specialists use the report to:

  • Analyze item purchases. The report displays a list of vendors that your company purchased from in a selected period, showing the invoiced quantity, amount, and discount. Use this information to analyze item purchases and manage inventory procurement.

Procurement managers use the report to:

  • Analyze procurement performance. The report shows a total of items purchased from vendors in a period, grouped by items. Use this information to analyze procurement performance and identify areas for improvement.
  • Improve supply chain processes. The report provides information about the total invoiced quantity, cost amount, and discount amount for each combination of a vendor and an item. The analysis helps you assess the relationship between discounts, the cost amount, and the volume of item purchases. Use this information to improve supply chain processes and optimize procurement strategies.

Controllers use the report to:

  • Monitor vendor spending. The report provides information about the total invoiced quantity, cost amount, and discount amount for each combination of a vendor and an item. The analysis helps you monitor vendor spending and identify potential issues.

Try the report

Try the report here: Inventory Vendor Purchases

Tip

If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.

Purchase reports
Ad hoc analysis of purchasing data
Purchasing analytics overview

Find free e-learning modules for Business Central here