Dynamics NAV selection filters

ERP Toolbox - Dynamics NAV

Here are several Signs combinations that can be used within NAV2015  Filters fields. This article is provided in addition to our Blog article dedicated to the Dynamics NAV2015 or NAV2013 Keyboard Shortcuts :

Interval : ..

1100..2100 Numbers 1100 through 2100
..2500 Up and including 2500
..12 31 15 Dates up to and including 12 31 15
P8.. Information for accounting period 8 and thereafter
..23 From the beginning date until 23-current month-current year 23:59:59
23.. From 23-current month-current year 0:00:00 until the end of time
22..23 From 22-current month-current year 0:00:00 until 23-current month-current year 23:59:59

Either / Or : |

1200|1300 Numbers with 1200 or 1300

Not equal to : <>

<>0 All numbers except 0

Greater than : >

>1200 Numbers greater than 1200

Greather than or equal to : >=

>=1200 Numbers greather than or equal to 1200

Less than : <

<1200 Numbers less than 1200

Less than or equal to : <=

<=1200 Numbers less than or equal to 1200

An indefinite number of unknown characters : *

*Co* Text than contains “Co”
*Co Text that ends with “Co”
Co* Text that begins with “Co”

One unknown character : ?

Hans?n Text such as Hansen or Hanson

Combined format expressions :

5999|8100..8490 Include any records with the number 5999 or a number from the interval 8100 through 8490
..1299|1400.. Include records with a number less than or equal to 1299 or a number equal to 1400 or greater
>50&<100 Include records with numbers that are greater than 50 and less than 100 (numbers 51 through 99)

Dates Signs :

w NAV Work date (enterred in Tools>Work Date)
t Today’s date
c Closing date
# Number of the day in the current work month
Days :

m : Monday
tu : Tuesday
we : Wednesday
th : Thursday
f : Friday
sa : Saturday
su : Sunday




Enjoy it !

No comments

Leave a reply

You must be logged in to post a comment.