Dynamics 365

Advanced Filtering in Microsoft Dynamics 365 Business Central

Source: Business Applications October 2018 Release Notes

With the October 2018 release of Microsoft Dynamics 365 Business Central, you can be more productive when filtering lists by influencing calculations and applying filters to multiple fields.

Back-office information workers spend significant time working with lists: entering or modifying data, analyzing trends and anomalies, or simply looking for specific records. While a quick search can reduce the list by finding the closest matches across all columns, users often need a higher degree of control as the size of the business database grows. The powerful filtering capabilities in Business Central accelerate list-related tasks by providing absolute control over filtering in a modern and intuitive experience.

Filtering lists

Anchored to the side of your lists, the new filter pane has a familiar design that is easy to learn and efficient to work with. Switch between predefined filtered views of your list, adjust a view by adding your own filters, or simply start from scratch.

Advanced Filtering in Dynamics 365 Business Central

The filter pane allows you to:

  • Get an overview of the currently applied filters, and see if they were set by you, by a filtered view, or by the application itself.
  • Add as many filtered columns as you like by typing to quickly search for more fields on the source table.
  • Get assistance with specifying filter values using lookups or the field's data type.
  • Create complex filters using operators, ranges, variables, and shorthand.
  • Filter to the current cell value in the list.

Business Central remembers the filters you applied throughout the session as you navigate back and forth across pages. The ability to permanently save your changes as a filtered view will be available at a later date. 

The filter pane is available on all pages that display lists, including worksheets, document lines, and list parts. This feature replaces the previous filter window reachable from each column header, and it complements other features that help you find specific rows or analyze your data, such as searching and sorting.

Limit totals

One of the most popular features of Dynamics NAV now makes its way to Business Central. Lists often display aggregated or computed values, such as currency amount totals. With this release, Business Central gives you a whole new level of control through which you can apply filters to one or more dimensions that influence computed values. Use this in combination with filters, sort, and search to explore and analyze your data.

Keyboard shortcuts

Although the filter pane is just a click away, you can also have a mouse-free experience with a variety of keyboard shortcut combinations, including the Alt+F3 shortcut to filter to the current value. You can now create compound filters on the fly without ever leaving the list, using shortcuts to navigate across cells and then filter to the currently focused value or clear the filter on the current column.

For more information about Dynamics 365 Business Central and how it can help your business, contact us.

Search in All Title Contents
2019 Apr  21  2
2019 Mar  27  3
2019 Feb  28  4
2019 Jan  76  10
2018 Dec  20  6
2018 Nov  50  7
2018 Oct  46  4
2018 Sep  38  3
2018 Aug  50  5
2018 Jul  21  5
2018 Jun  48  6
2018 May  34  5
2018 Apr  491  6
2018 Mar  85  7
2018 Feb  42  5
2018 Jan  121  5
2017 Dec  95  9
2017 Nov  41  6
2017 Oct  73  8
2017 Sep  31  5
2017 Aug  154  11
2017 Jul  174  9
2017 Jun  123  11
2017 May  282  10
2017 Apr  29  6
2017 Mar  408  9
2017 Feb  200  11
2017 Jan  470  11
2016 Dec  235  10
2016 Nov  247  12
2016 Oct  23  11
2016 Sep  37  15
2016 Aug  34  16
2016 Jul  29  11
2016 Jun  40  12
2016 May  39  20
2016 Apr  51  5
2016 Mar  22  10
2016 Feb  67  3
2016 Jan  6  4