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 purchase amounts, invoice discounts, payment discounts, payment discount tolerances, and payment tolerances, all in local currency.

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:

  • Compare purchase amounts. Review purchases in local currency across five periods for each vendor.
  • Evaluate vendor discounts. Review invoice discounts, payment discounts, payment discount tolerances, and payment tolerances.

Accounts payable specialists use the report to:

  • Review discount and tolerance totals. Compare the amounts recorded for each vendor across the selected periods.

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 cash flow 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. The new tab lets you 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 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. Learn more in 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