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-to: Sort Columns – SETASCENDING

Since NAV 2013 we are more and more getting the full potential out SQL Server.

In NAV 2009 (and before) it was, for example, unimaginable to setup “your own” sorting for your data retrieval as SETCURRENTKEY only allowed you to use the keys defined on the table you were going to query. Or not possible for users to sort their lists by any column, like they had been used to in, for example, Excel long time.

Bron : Van Vugt’s dynamiXs
Lees meer…

How to set dynamically the Key and Sort Order for the pages using NAV 2009 Web Services feature

The default methods exposed when a page is published are the so-called CRUD (Create, Read, Multiple and Delete) methods. All of those does not allow to set up previously a key for sorting order nor if the records have to be ascending or descending.

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…