Study guide

14.2 Searching, Advanced Filters, Saved Views & Page Inspection

Microsoft Dynamics 365 Business Central Functional Consultant MB-800

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Company Creation & Data Migration

1.1 Creating Companies & Assisted Setup Wizards 1.2 Configuration Packages & RapidStart Worksheets 1.3 Opening Balances & Data Migration Strategies

2 Chapter 2: Security, Profiles & Auditing

2.1 Users, User Setup & Role Center Profiles 2.2 Permission Sets & Security Group Management 2.3 Security Filters, Change Log & Security Auditing

3 Chapter 3: Core System Configuration, Number Series & Copilot

3.1 Company Information, Number Series & Job Queues 3.2 Report Layout Management & Copilot AI Capabilities

4 Chapter 4: Dimensions Architecture & Governance

4.1 Dimension Concepts & Dimension Values 4.2 Global Dimensions vs Shortcut Dimensions 4.3 Default Dimensions, Combinations & Priorities

5 Chapter 5: Workflows & Approvals

5.1 Native Workflow Templates & Approval Hierarchy 5.2 Workflow User Groups & Notification Configuration

6 Chapter 6: Financial Setup, Periods & Currencies

6.1 General Ledger Setup & Accounting Periods 6.2 Payment Terms, Payment Methods & Deferrals 6.3 Multi-Currency Setup & Exchange Rates

7 Chapter 7: Chart of Accounts, Categories & Allocations

7.1 Chart of Accounts Structure & G/L Account Cards 7.2 Account Categories, Subcategories & Financial Reporting 7.3 General Ledger Allocation Accounts & Sharing

8 Chapter 8: Posting Groups & Posting Setup

8.1 Specific Posting Groups: Customer, Vendor, Bank & Inventory 8.2 General Posting Groups & General Posting Setup Matrix 8.3 Inventory Posting Setup & Alternative Posting Groups

9 Chapter 9: General Journals & Recurring Methods

9.1 Bank Account Cards & Posting Setup 9.2 General Journal Templates, Batches & Number Series 9.3 Recurring General Journals & Allocation Methods

10 Chapter 10: Accounts Payable & Accounts Receivable Setup

10.1 Purchases & Payables Setup & Vendor Master 10.2 Sales & Receivables Setup & Customer Master 10.3 Payment Journals, Cash Receipts & Payment Registration Setup

11 Chapter 11: Fixed Assets Setup & Depreciation Books

11.1 Fixed Asset Setup, Classes & Depreciation Books 11.2 Fixed Asset Cards, Main/Component Assets & Depreciation Methods

12 Chapter 12: Inventory Setup, Costing & Locations

12.1 Inventory Setup, Item Types, Categories & Variants 12.2 Costing Methods (FIFO, LIFO, Average, Standard) & Ledger Architecture 12.3 Locations, Transfer Routes & Stockkeeping Units (SKUs)

13 Chapter 13: Logistics Master Data, Pricing & Discounts

13.1 Shipping Agents, Locations & Vendor Lead Times 13.2 Sales Prices, Purchase Prices & Price Lists 13.3 Line Discounts, Invoice Discounts & Thresholds

14 Chapter 14: User Interface, Views, Inspection & Excel

14.1 Personalization, Profile Customization & Designer 14.2 Searching, Advanced Filters, Saved Views & Page Inspection 14.3 Edit in Excel, OneDrive & Data Analysis Mode

15 Chapter 15: Purchase & Sales Order Execution

15.1 Purchase Orders, Receiving, Over-Receipt & Undo 15.2 Purchase Invoicing, Recurring Lines & Blanket Orders 15.3 Sales Quotes, Availability Checks & Order Conversion 15.4 Sales Shipping, Invoicing, Undo & Blanket Orders

16 Chapter 16: Invoices, Credit Memos & Document Corrections

16.1 Direct Invoices, Credit Memos & Document Reopening 16.2 Correct, Cancel & Corrective Credit Memo Procedures 16.3 Combined Shipments/Receipts & Prepayment Workflows

17 Chapter 17: Cash Management, Bank Reconciliation & Ledger Applications

17.1 Processing Payment Journals & Cash Receipt Registrations 17.2 Applying, Unapplying & Reversing Customer/Vendor Entries 17.3 Bank Account Reconciliation & Statement Matching Rules

18 Chapter 18: Operational Adjustments, Inventory & Asset Accounting

18.1 Exchange Rate Adjustments & Dimension Corrections 18.2 Inventory Adjustments, Transfers & Physical Counting 18.3 Fixed Asset Acquisitions, Depreciation Runs & Disposals

14.2 Searching, Advanced Filters, Saved Views & Page Inspection

Key Takeaways Explain This Topic AI

Business Central distinguishes between Quick Search (full-text search across visible list columns) and Tell Me (Alt+Q global search for pages, reports, actions, and documentation).

The Filter Pane (Shift+F3) provides two distinct filtering scopes: 'Filter list by...' (which evaluates static master/document fields) and 'Filter totals by...' (which configures FlowFilters like Date Filter and Global Dimension Filters to calculate FlowFields).

Business Central supports rich logical filter operators including ranges (..), logical OR (|), logical AND (&), wildcards (* and ?), case-insensitive prefixes (@), and empty field queries ('').

Saved Views allow users to preserve customized combinations of record filters, FlowFilters, sorting, and column layouts as named tabs in the list navigation pane.

Page Inspection (Ctrl+Alt+F1) exposes diagnostic schema metadata, extension ownership, and unexposed table fields, while Find Entries traces all linked ledger entries, registers, and posted documents across database tables.

Last updated: September 2026

14.2 Searching, Advanced Filters, Saved Views & Page Inspection

Quick Summary: Efficient data location and system diagnostics in Dynamics 365 Business Central rely on five core capabilities: Tell Me ( Alt+Q ) for feature and action navigation, Quick Search ( F3 ) for multi-column list queries, The Filter Pane ( Shift+F3 ) for combined record filters and FlowFilters, Saved Views for persisting tailored list configurations, and Page Inspection ( Ctrl+Alt+F1 ) for inspecting underlying Page IDs, Table IDs, extension ownership, and unexposed field values. To trace transactions across tables, Find Entries traverses the database to display all ledger entries and documents sharing a common Document Number and Posting Date.

Search Capabilities: Quick Search vs. Tell Me

Users often confuse navigation searching with record querying. Business Central provides two foundational search tools that operate on completely distinct data boundaries. Search Boundaries in Business Central:

[Tell Me: Alt+Q] ──► Global Feature Discovery (Pages, Tasks, Reports, Documentation, Actions)

Does NOT search individual record rows or table values.

[Quick Search: F3] ──► List Data Query (Searches all visible columns on the active list page)

Queries record rows using full-text substring matching.

1. Tell Me (What do you want to do? / Alt+Q)

Located in the top application banner (or launched via Alt+Q ), Tell Me serves as the universal navigation engine. It matches user search terms across:

Pages and Tasks: Direct links to list pages, card pages, setup pages, and journals.

Reports and Analysis: Direct links to standard RDLC, Word, Excel, and Power BI reports.

Current Page Actions: Discovers and triggers action bar buttons on the active page without requiring manual menu navigation.

Documentation & AppSource: External links to Microsoft Learn articles and third-party AppSource apps.

2. Quick Search (Search List / F3)

Located in the top right corner of every list page (or activated via F3 ), Quick Search executes an immediate full-text query across all visible columns of the active dataset. Entering London filters the list to show any record containing "London" in the Name, Address, City, or Contact columns. It does not evaluate columns that are currently hidden.

Advanced Filtering & The Filter Pane (Shift+F3)

For precise data analysis, users expand the Filter Pane by clicking the filter funnel icon or pressing Shift+F3 . The Filter Pane exposes two fundamentally different filtering tiers: Filter Pane Architecture (Shift+F3):

  • ┌─────────────────────────────────────────────────────────────┐
  • │ FILTER PANE │
  • │ │
  • │ ▼ Filter list by... <-- Record Filters │
  • │ No. : 10000..20000 (Evaluates static data │
  • │ Blocked : ' ' stored in Table 18) │
  • │ │
  • │ ▼ Filter totals by... <-- FlowFilters │
  • │ Date Filter : 01/01/26..03/31/26 (Calculates FlowFields │
  • │ Global Dimension 1 : ADMIN like Net Change/Balance) │
  • └─────────────────────────────────────────────────────────────┘
  • Record Filters ("Filter list by...")

Record filters evaluate static data stored in specific table columns. Records are excluded from the view if their static field values do not satisfy the criteria (e.g., City = Atlanta ).

FlowFilters ("Filter totals by...")

FlowFilters are specialized virtual filter fields that do not filter out master records. Instead, they provide calculation parameters to FlowFields (dynamically computed formula fields derived from underlying ledger entry tables).

The Critical Difference in Master Data

Consider the Chart of Accounts (G/L Accounts) or the Customer List :

If an accountant filters the Chart of Accounts using Filter list by... Posting Date = 01/01/26..03/31/26 , the system throws an error or returns nothing because the G/L Account table does not possess a static field named "Posting Date".

Instead, the accountant expands Filter totals by... and enters 01/01/26..03/31/26 into the Date Filter FlowFilter.

Result: Every G/L Account remains visible in the list, but calculated FlowFields (such as Net Change and Balance at Date ) dynamically recalculate to reflect transactions posted strictly within that date window.

Master tables support several standard FlowFilters:

Date Filter: Restricts the date calculation window for ledger aggregations.

Global Dimension 1 / 2 Filter: Restricts calculation to specific department or project codes.

Location Filter: Restricts inventory calculations on Item cards to specific warehouse facilities.

Currency Filter: Filters customer or vendor balances by transactional foreign currency.

Business Central Filter Syntax & Operators

Business Central features a powerful filter expression syntax that supports complex Boolean logic, ranges, wildcards, and date formulas.

Operator Definition Example Syntax Operational Evaluation Behavior

.. Interval / Range 1000..2000 ; ..1000 ; 1000.. Matches numbers between 1000 and 2000 inclusive.; Matches all values up to 1000.; Matches 1000 and all higher values.

&#124; Logical OR RED&#124;BLUE ; 1000&#124;2000 Matches records where the field contains either RED or BLUE .

& Logical AND >1000&<2000 Matches values strictly greater than 1000 and strictly less than 2000.

<> Not Equal To <>0 ; <>CLOSED Matches any record where the value is not zero, or status is not CLOSED.

* Multi-Char Wildcard *CORP* ; CONT* Matches any string containing "CORP" anywhere; matches strings starting with "CONT".

? Single-Char Wildcard ?000 Matches any 4-character string ending in 000 (e.g., 1000 , 2000 , A000 ).

@ Case-Insensitive @john* Matches John , JOHN , john , or Johnathan regardless of text case.

'' Empty / Blank '' Matches records where the text or code field is completely blank (null/empty).

'=' Exact Blank Space '=' Matches records where the field contains an exact blank space character.

Standard Date Formulas in Filters

When filtering date fields, Business Central recognizes dynamic system date codes:

t or T : Evaluates to Today's date (system clock).

w or W : Evaluates to the current Work Date configured under My Settings.

cm or CM : Current Month (e.g., 01/01/26..cm filters from Jan 1 through the end of January).

cy or CY : Current Year (e.g., 01/01/26..cy filters through Dec 31).

Relative Date Formulas: -1M..t (past month through today), t..+1W (today through one week ahead).

Saved Views: Preserving Customized List Perspectives

A Saved View allows users to preserve a customized combination of filters, FlowFilters, column layouts, and sorting orders as a dedicated, reusable tab on a list page. Saved View Structure on List Pages:

  • Customer List Page
  • ├── [All] (Standard unfiltered baseline)
  • ├── [Overdue Domestic] (Filter: Balance Due > 0 & Country = US | Saved View Tab)
  • └── [EU Wholesale] (Filter: Gen. Bus. = EU & Price Group = WHOLESALE | Saved View Tab)
  • Creating and Managing Saved Views

Open any list page (e.g., Customer Ledger Entries ).

Expand the Filter Pane ( Shift+F3 ) and define record filters (e.g., Open = Yes , Due Date = <t ).

Click the Save view as floppy-disk icon at the top of the Filter Pane.

Enter a descriptive title (e.g., Overdue Open Entries ).

The saved view is immediately pinned as a distinct tab at the top of the list grid.

Scope: Saved views created by end users are stored per-user. However, administrators configuring pages via Profile Customization can create saved views that are permanently deployed to every user assigned to that profile.

Page Inspection (Ctrl+Alt+F1): The Diagnostic Hub

Page Inspection ( Ctrl+Alt+F1 or Help & Support > Inspect pages and data ) is the most essential troubleshooting and diagnostic tool available to functional consultants and administrators. Page Inspection Slide-out Pane (Ctrl+Alt+F1):

  • ┌─────────────────────────────────────────────────────────────┐
  • │ PAGE INSPECTION │
  • │ │
  • │ Page: Customer Card (21) │
  • │ Source Table: Customer (18) │
  • │ Extension: Base Application by Microsoft (24.0.0.0) │
  • │ │
  • │ ▼ Page Filters │
  • │ No. is '10000' │
  • │ │
  • │ ▼ Table Fields (Inspects all 120+ table fields) │
  • │ Field No. | Field Name | Value │
  • │ 1 | No. | 10000 │
  • │ 2 | Name | Adatum Corporation │
  • │ 102 | E-Mail | contact@adatum.com │
  • │ 2000000 | SystemId | 4f2e8b1a-9c2d-4e8f... │
  • │ 2000001 | SystemCreatedAt | 2026-01-15 08:30:12 │
  • └─────────────────────────────────────────────────────────────┘
  • Key Metadata Elements Exposed by Page Inspection

Page Identification: Displays the exact Page Name , Page ID (e.g., Page 21), and Page Type (Card, List, Worksheet, Document).

Source Table Identification: Displays the underlying database Table Name and Table ID (e.g., Table 18 Customer ).

Extension Ownership: Identifies which extension contributed the page, as well as which extensions introduced specific controls or fields. If an error is caused by a third-party AppSource app, Page Inspection reveals the owning extension.

Unexposed Table Fields & Raw Values: Displays every single field in the underlying table record—even fields completely absent from the UI, hidden technical flags, calculated FlowFields, and system audit fields ( SystemId , SystemCreatedAt , SystemModifiedAt ).

Active Filters: Shows all filters currently applied to the record set, including user-defined UI filters, page view filters, and system-enforced AL TableFilter or SecurityFilter constraints.

Note

Page Inspection is strictly a read-only diagnostic viewer. It cannot be used to modify field values or alter table schemas.

Find Entries (Formerly Navigate): Transactional Audit Tracing

When investigating posted financial or operational activities, consultants use Find Entries (historically named Navigate in older Dynamics NAV / BC versions). It traces all ledger entries, registers, and posted documents created by a single business transaction. Find Entries Relational Trace:

  • [Transaction Identifier: Document No. 'INV-102001' + Posting Date '03/15/2026']
  • │
  • ├──► G/L Entry (6 records) -> Debits Receivables, Credits Sales & VAT
  • ├──► Cust. Ledger Entry (1 record) -> Customer subledger open balance
  • ├──► Detailed Cust. Ledg. Entry (1) -> Initial transaction amount
  • ├──► Item Ledger Entry (2 records) -> Relieves inventory quantity on hand
  • ├──► Value Entry (2 records) -> Relieves inventory asset valuation
  • ├──► VAT Entry (1 record) -> Tax ledger reporting
  • ├──► G/L Register (1 record) -> Audit trail batch identifier
  • └──► Posted Sales Invoice (1 doc) -> Historical printed document header
  • How Find Entries Works

Access: Click Find entries on any posted document header, ledger entry line, or search via Tell Me ( Alt+Q -> type Find Entries ).

Matching Criteria: Automatically populates the Document No. and Posting Date of the active record. Users can also search by Business Contact Type/No. or External Document No.

Execution: Business Central queries every ledger table, subledger table, register table, and posted document header table in the database.

Results Grid: Summarizes all related tables with a No. of Records count. Users click any count to drill directly into the underlying ledger entries or view the original posted document.

Loading diagram... Find Entries Transactional Cross-Table Trace Architecture