Register For Our Live Webinar WorkshopRegister Now

Technology trends, insights, success
stories and other helpful resources.

Make your work with Dynamics NAV easier with these shortcuts

March 6th, 2017 Intech SystemNilesh Gajjar Dynamics NAV, Microsoft Dynamics

Top up your experience and make your work in Dynamics NAV easier with these shortcuts. This post is about keyboard shortcuts for filter & searching data in Dynamics NAV.
The Filter (formerly known as quick filter method) is an extremely useful for searching and filtering data.  Here are various filter methods which you can use:

 

MeaningSample ExpressionRecords Displayed
An indefinite number of unknown characters*Co*Text that contain “Co”
*CoText that end with “Co”
Co*Text that begin with “Co” (classic client)
And>2000&<1000Numbers that are less than 2000 and greater than 1000.  The & sign cannot be used by itself with numbers because no record can have two numbers.
Case insensitive@man*Displays results that start with man and are case insensitive
Date specific expressions07In a date field, this will display the day in the current month and year, i.e. 03/07/17
0307In a date field, this will display the month and day in the current year, i.e. 03/07/17
P8In a date field, this will display the first through last day of a period E.g. 08/01/15..08/31/15
Either/Or1100|2100Those with the numbers 1100 or 2100
Exact character match‘man’Text that matches ‘man’ exactly and is case sensitive.
Interval1100..2100Numbers 1100 through 2100
..2500Up to and including 2500
..033117Dates up to and including 03/31/17
P8..Information for accounting period 8 and thereafter
Less than<1200Numbers less than 1200
Less than or equal to<=1200Numbers less than or equal to 1200
Not equal to<>0All numbers except 0
Greater than>1200Numbers greater than 1200
Greater than or equal to>=1200Numbers greater than or equal to 1200
One unknown characterHans?nText such as Hansen or Hanson
Example ExpressionCombinations5999|8100..8490Include any records with the number 5999 or a numberfrom 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 (all numbers except 1300 through 1399).
Here are keyboard shortcuts to make your work easier:
Keyboard ActionAction
AltDisplay shortcut keys in the ribbon
Alt+F2Toggle to display/hide FactBoxes
Alt+F3Filter to currently selected field (e.g. customer name)
Alt+F4Close window or close program
Alt+F6Collapse or expand the active frame (e.g. expand “Invoicing” section in sales order)
Alt+F12Optimize space for the current page
Alt+Left ArrowGo to the previous window in the navigation history
Alt+Right ArrowGo to the next window in the navigation history
Alt+EnterMove to the line below
Ctrl+F1Collapse or expand the ribbon
Ctrl+F2Create a new document
Ctrl+F3Select Search pages
Ctrl+F4Open related list editor (e.g. open posting group when field selected in sales order)
Ctrl+F7View entries
Ctrl+F9Release document
Ctrl+F11Reconcile or split lines
Ctrl+F12Select the address bar
Ctrl+CCopy
Ctrl+GGo to
Ctrl+EExport to Microsoft Office Excel
Ctrl+LShow links
Ctrl+NCreate a new record
Ctrl+OOpen the company
Ctrl+PPrint
Ctrl+VPaste
Ctrl+WExport to Microsoft Office Word
Ctrl+XCut
Ctrl+ZUndo
Ctrl+Page DownDisplay next document or card in a list
Ctrl+Page UpDisplay previous document or card in a list
Ctrl+Up ArrowMove up while the selected line stays selected
Ctrl+Down ArrowMove down while the selected line stays selected
Ctrl+Left ArrowMove to the first field on a line
Ctrl+Right ArrowMove to the last field on a line
Ctrl+Alt+F1Open the About this Page/Report window (shortcut is commonly used by other programs e.g. Intel graphics. You may have to disable these first.)
Ctrl+DeleteDelete the selected line
Ctrl+HomeMove to the first line in a list
Ctrl+EndMove to the last line in a list
Ctrl+EnterSave and close window (equivalent to choosing the OK button)
Ctrl+InsertInsert new line
Ctrl+Shift+F3Select Limit totals to (e.g. chart of accounts)
Ctrl+Shift+AClear all filters (e.g. when opening report)
Ctrl+Shift+CCopy Rows
Ctrl+Shift+DShow dimensions
Ctrl+Shift+EEdit list
Ctrl+Shift+RView list
Ctrl+Shift+QCollapse/expand a line in a hierarchy
Ctrl+Shift+VPaste rows
Ctrl+Shift+WOpen current page (e.g. sales orders) in a separate window
Ctrl+Shift+EnterSave and close the window (e.g. saves new item being created) and opens a new window (e.g. new item)
F1Open Help
F2Edit
F3Select Type to filter (field filter)
F4Drop-down or look up to select
F5Refresh the active window
F6Go to the next frame
F7Display statistics
F8Copy the field above
F9Post
F10, AltSelect the menu bar and display access keys
F12Select the navigation pane
Shift+F1View error message
Shift+F3Select Show Results (FlowFilter)
Shift+F4Open a lookup window (from an ellipsis button)
Shift+F6Go to the previous frame
Shift+F7Open the related card
Shift+F8Drop-down or look up to view
Shift+F9Post and print
Shift+F10Display a shortcut menu
Shift+F11Apply entries, get source documents, or get warehouse documents
Shift+F12Open the Role Center from the navigation pane
Shift+TabMove to the previous field
TabMove to the next field on non-line FastTabs
DeleteClear selected text
EscClose the window or undo the data entry
EndMove to the last field on a line
HomeMove to the first field on a line
EnterMove to the next editable field

 

Hope these will help you in bringing the best out of Dynamics NAV.
In case of any query, feel free to reach us.

Recent Post

Corporate Profile

Request Demo Download Brochure
Contact Us

How we can help you!

Talk to Dynamics 365 experts for your concerns

Contact Us
Contact Us

How can we help? - Talk to Dynamics 365 experts for your concerns

    Join our mailing list for news updates, invitations, and more