Setting filters is a great way of narrowing down a list to find a record or a desired set of records in NAV.
I want to describe few tips about filters usage in Dynamics NAV RTC. This can be useful for users who worked with classic client and came to RTC.
Some forms in Dynamics NAV use the property “AutoSplitKey”. That means that the “Line No.” field will be automatically assigned the next line number or a number between lines if the user tries to insert a line between two lines.
Date filters on custom made forms are a common request. Apparently I’ve been coding it wrong the past years… until today of course! Maybe my biggest mistake was that I never bothered to look at how standard Nav handles this.
Filtering on field type RecordID can be tricky because there is a difference between NAV2009SP1 and the versions before.
I want find the record links of a record in the database. (In my example I just used the first record in table 3:”Payment Terms” for which to find its records).
Vertalen
