Skip to main content What is Dynamics 365? Guided tours Customer stories Try our products Build your own agents CRM ERP Sales Service Sales Customer Insights Customer Service Contact Center Field Service Supply Chain Management Commerce Finance Project Operations Human Resources Business Central Pricing Business application topics Training & certifications Migrate to the cloud Documentation Events Dynamics 365 Blog Product updates Onboarding and implementation Community Find a partner Software Development Companies Partner resources Microsoft Marketplace Product documentation Technical support On-premises product support Contact us Try for free Sign in
  • 1 min read

NAV 2009 Tips and Tricks: Change the default filter in fields that take input


In fields that take input, such as Sell-to-Customer No., Location Code, or  Address, as you start entering characters, a drop-down list shows possible field values that match the characters you have typed. Typcally, Microsoft Dynamics NAV sets the default filter to the number value in number fields such as Customer No. and to the text value in fields such as Address.

But you can change the default field you use as a filter. In this example, you can change the filter from No. to Name.

  1. In the drop-down list, click the heading of the column you want to set as a default filter column.
  2. Click Set as default filter column.

Now, as you type in the Sell-to Customer No. field, the filter is set to look in the Name column rather than the No. column.

Get started with Dynamics 365

Drive more efficiency, reduce costs, and create a hyperconnected business that links people, data, and processes across your organization—enabling every team to quickly adapt and innovate.