Skip to main content

How do I filter the invoice list, and how can I tell a filter is active?

Click the arrow in the column header, choose values and click Apply filter. Filter (1) and "12 of 22 lines" at the top show that a filter is active. Clear all filters removes them.

In Invoice → Incoming invoice you filter by clicking the arrow in the header of the column you want to filter on, for example Posting period, Due date, Status or Flag. When a filter is active, the button at the top of the table shows for example Filter (1), and Clear all filters removes all filters.

How to filter

  1. Go to Invoice and the Incoming invoice tab.

  2. Click the arrow in the header of the column you want to filter on, for example Posting period or Status.

  3. Choose how you want to filter:

    • Select values: Tick the values to show, for example the months you want to see. Use Search values to find a value quickly.

    • Number rule: For amounts, choose a rule, for example greater than or between, and enter a value.

  4. Click Apply filter.

  5. Use the search field on the left above the table to search for invoice number, supplier and other text.

The filter menu in a column with a number rule.

How to see that a filter is active

  • The button at the top shows the number of filters, for example Filter (1).

  • At the top it says how many lines are shown out of the total, for example 12 of 22 lines.

  • The filter icon in the header of the filtered column is highlighted.

Active filter shown at the top of the table.

Quick selections above the table

Above the table you'll find quick selections with counts, for example all invoices, Unlinked (blue circle) and linked invoices.

Can't find an invoice?

  1. Check whether the button at the top shows a filter, for example Filter (1), and how many lines are shown out of the total.

  2. Check whether a quick selection is active.

  3. Click Clear all filters at the top of the table to see the whole list again.

Good to know

  • You can filter on several columns at the same time. The table then shows only the invoices that match all the filters.

  • You can only filter on columns that are shown in the table.

Related questions

Did this answer your question?