Back

Filter on several values in options fields

Navigation
Video 21/26
Play
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
A beginner video is for people with little or no experience with Business Central. It is explained thoroughly and is easy to understand. Beginner Watch the "basic" videos to take the tour of the main processes of Business Central. This is the basic, need-to-use functionality. The Basics

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Presenter: Jesper Nielsen, Head of Onboarding

This is what happens in the video

In Business Central you can filter an option field on more than one value at the same time. This lets you combine several statuses in a single filter instead of looking at each value separately. For example, on the customer list you can filter the Blocked field to show customers that are blocked for both Ship and Invoice at once.

Filtering an option field on several values in Business Central

Option fields in Business Central hold a fixed set of values. The Blocked field on the customer card is a good example, with options such as Ship, Invoice and All. Sometimes you want to see records that match more than one of these values, and you can do that directly in the filter pane.

Open the customer list and select the filter pane. From there you add a filter on the Blocked field. Instead of choosing a single value, you can enter several of the option values so the list shows customers that are blocked for shipping and for invoicing at the same time.

This is a small but practical trick. It saves you from running separate filters for each status when you want an overview of customers that are blocked in any of several ways.

Q&A

Can you filter on more than one value in an option field in Business Central?

Yes. In the filter pane you can enter several of the option values for the same field, so the list shows records matching any of those values.

How do you filter customers that are blocked for both shipping and invoicing?

Open the customer list, select the filter pane and add a filter on the Blocked field. Choose both the Ship and Invoice values, and the list shows customers blocked for shipping and invoicing at the same time.

403218475-qXgM9wi9io-ENG19120304