Filter Tokens

When entering filter values in the filter pane in the Business Central web client, users can enter filter tokens [% + reserved word] that resolve to a filter value or a filter expression. The reserved word can be written in small letters or completely in capitals, or even be translated – more on that soon.

Source : The BC Docs Librarian
Read more…

Dynamics 365 Business Central: introducing the Azure File Share module

I wrote in the past some articles about how it’s important to use Azure Storage for storing files in a Dynamics 365 Business Central project (avoid using blobs and media as much as possible) and I’ve talked about the differences between Azure Blob Storage and Azure File Share, also providing a solution for mapping an Azure File Share as a local drive for data exchange with Dynamics 365 Business Central (link here).

Source : Stefano Demiliani
Read more…

Dynamics 365 Business Central: How to check if there is only one value in the filter for a field (For example, check if number of G/L Account No. filter is greater than 1)

Today I would like to talk about an interesting question I was asked before, is there any way to check if there is only one value in the filter for a field, for example, check if number of G/L Account No. filter is greater than 1.

Source : Dynamics 365 Lab
Read more…

Dynamics 365 Business Central: How to convert Image (item picture) to encoded text (Base64 String) via AL

In Business Central, there are several built-in filter tokens available, and users can also define custom filter tokens to suit their specific needs. Custom filter tokens can be defined in any language and are accessible across the application.

Source : BeyondIT
Read more…

Dynamics 365 Business Central: Entering Criteria in Filters (Not equal to multiple criteria)

A few days ago, I was asked an interesting question, how to combine “Not equal to” format expressions when entering Criteria in Filters (Not equal to multiple criteria). This is not a very difficult question. In this post, I would like to briefly share information about how to enter criteria in filters in Business Central.

Source : Dynamics 365 Lab
Read more…

A simple way to filter list pages in Business Central using FilterPageBuilder

FilterPageBuilder Data Type
Version: Available or changed with runtime version 1.0.

Stores filter configurations for a filter page. A filter page is a dynamic page type that contains one or more filter controls that enable users to set filters on fields of the underlying tables.

Source : Ivan Singleton
Read more…