Security Filters in Business Central

Business Central Security’s security system allows you to control the objects that a user can access within each database or environment. For each user, you can specify whether you want to allow reading, editing or inserting data in the selected database objects.

You can specify which records are stored in the tables that each user is allowed to access. This means that permissions can be allocated at both the table level and the record level.

Source : Roberto Stefanetti Blog
Read more…

How to add Filter Tokens in Microsoft Dynamics 365 Business Central

Filter Tokens is an interesting functionality in Business Central. Many of us do not know about this functionality. Using this functionality, you can add Filter Tokens like Tomorrow, Yesterday, ThisMonth, PrevMonth, FiscalYear, PrevFiscalYear, NextFiscalYear etc. so that User can use them just like Today and WorkDate Filter Tokens to apply date filters.

Source : msnJournals
Read more…

Using Search, Sort, And Filter Features In Microsoft Dynamics Business Central To Get The Data You Need Faster

Microsoft Dynamics 365 Business Central has the tools you need to find and report on the data in your ERP system. Understanding how to search, sort, and filter is critical.

Watch this video to see how to search and sort your data in list views and how to use the powerful filter options in both list views and reports to get the data you need to make informed decisions. You’ll also find tips for search criteria as well as how to access hidden data fields for filtering.

Source : ArcherPoint
Read more…

How do I : Add filters in a report in VSCode with AL?

Recently someone asked me, what’s wrong with me report, it’s not showing me the correct data?

After investigating I noticed that the report used filters, applied in several different ways and that the expected data was not showing up in the dataset, and then of course it was also not displayed in the layout.

Source : Think about IT
Read more…

Development Design pattern for Best Fit Filtering

In our Org we have quite a few places were data is auto populated based on other data selected. This however comes with allot of rules. When I started, we had allot of issues where sometimes the incorrect data is selected. This required a rewrite of the filtering to find the correct data but often caused the “fix” to break another set of data combinations.

Source : Oosie’s Rants
Read more…