Top Suppliers by Spend

View suppliers ranked by the total spend, from highest to lowest, to identify suppliers that account for the largest share of your organization's expenditure.

The Top Suppliers by Spend widget shows a bar chart with expenditure data for up to ten suppliers. You can filter data based on these fields:

  • Business Unit
  • Period from
  • Period to
  • Number of suppliers (from 1 to 10)

Each bar represents a supplier’s net spend during the selected time range. Hover over a bar to view the exact spend amount. You can also click a bar to drill into detailed invoice transactions. Invoice details are displayed in a sortable grid with these columns:

  • Invoice Reference
  • Amount
  • Transaction Date

From the grid, you can open the Purchase Invoice Entry (PIE) function to view individual invoice records. The horizontal axis of the chart shows the owed amount and currency symbol that is set for the selected business unit. The vertical axis of the chart lists the selected suppliers.

To control access to the Top Suppliers by Spend widget and restrict supplier visibility based on user permissions, configure Data Access Groups (DAG).

The Top Suppliers by Spend query logic

The Top Suppliers by Spend widget ranks the top suppliers based on the total purchase spend within a selected business unit and period range. The widget aggregates the total invoice amounts for each supplier through approved purchase invoices that fall within the defined period range. Data is retrieved from the ledger and is filtered by the values of the Business Unit, Period from, and Period to fields. Period values must be specified in a specific format, such as 005/2025, and validated to ensure that the start period is earlier than the end period.