Sorting, Searching, and Filtering in Microsoft Dynamics 365 Business Central

I get the question a lot from my clients moving from Microsoft Dynamics GP to Microsoft Dynamics 365 Business Central if SmartList exists. For those of you who are not familiar with SmartList it is a tool that allows users to sort, search, and filter data within the system for reporting purposes. While "SmartList" as we know it doesn't exist, Business Central does have very similar qualities within the system that allows users to do the same, it just looks and feels different. Lets take a look at how this functionality works within Microsoft Dynamics 365 Business Central. Scenario: It's month end and you're reviewing financials and see that travel is a bit high for the month. You want to pull detailed information and see what was coded to the travel expense account. You have two options: Pull a detail trial balance - this process can be clunky as you have to add a filter for the account number and date range within the report options window. And then if you wa...