Purchase statistics (report)

The report shows purchase statistics for each vendor. The statistics include information for five periods, starting on the date that you specify.

You can specify the period length, such as 14 days, 1 month, or 1 quarter.

The report includes the total purchases, payments, finance charges, and discount information, including the payment discounts taken and lost.

Statistics are calculated for:

  • Purchases before the date entered.
  • At three intervals from the date entered
  • Purchases made after the third interval.

Use cases

Track vendor performance and ensure that your company gets the best value for money.

Procurement analysts use the report to:

  • Monitor vendor performance. The report provides a comprehensive view of purchase statistics for each vendor over a period of time. Use this information to monitor vendor performance and identify discrepancies in pricing or delivery timelines.
  • Evaluate vendor discounts. The report includes information about payment discounts that were taken and lost. Use this information to evaluate vendor discounts and identify opportunities to save cost.

Accounts payable specialists use the report to:

  • Manage vendor payments. The report provides a quick look-up of posted payments, discounts, and other transactions for a vendor. Use this information to manage vendor payments and avoid disputes with vendors.

Controllers use the report to:

  • Forecast cash flow. The report provides a comprehensive view of purchase statistics for each vendor over a period of time. Use this information to forecast cash flow, identify potential cashflow issues, and take action to avoid disruptions in cash flow.

Try the report

Try the report here: Purchase statistics

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.

Alternative reports

There are several other ways to analyze your vendors.

  • The Vendors list and the Vendor card both include a Vendor Statistics section in the factbox.
  • The Vendor card includes a Statistics action that opens the Vendor Statistics page.
  • All reports in the Power BI Purchasing app support filtering to one or more vendors. To learn more, go to Power BI Purchasing app.

Purchase reports
Ad hoc analysis of purchasing data
Power BI Purchasing app
Purchasing analytics overview

Find free e-learning modules for Business Central here