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
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
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
I have defined how to Create New Filter Token in msdyn365bc which will be storing the values and we can use that particular filter through out the Application.
Source : Divyesh Chitte
If your customer is using complex filter in List page and wants to save the Filter of list page and use the Filter Frequently for all the related pages then we can use Filter Token.
Source : Divyesh Chitte
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
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