Redesign Shortcut Reference Guide





Grid Filter Shortcuts


%

Wildcard

=

value or .eq value will select all records equal to the value entered

>

value or .gt value will select all records greater than the value entered

>=

value  or .ge value will select all records greater than or equal to the value entered (default behavior for numeric fields)

<

value or .lt value will select all records less than the value entered  

<=

value or .le value will select all records less than or equal to the value entered

<>

value or .ne value will select all records not equal to the value entered

~

value or .like value will select all records starting with the value entered - ONLY WORKS FOR TEXT FIELDS; THIS IS THE DEFAULT BEHAVIOR FOR TEXT FIELDS IF NO OPERATOR IS ENTERED

*=

value1,value2,value3 etc. or .oneOf value1,value2,value3 etc. will select records containing one of the values listed - ONLY WORKS WITH NUMERIC FIELDS

value1..value2

value1..value2 or .between value1,value2 will select records between the values listed




Date Shortcuts

YeaR (Calendar)

Y - Jan 1 of current calendar year

R - Dec 31 of current calendar year

FiscaL

F - July 1 of current fiscal year

L - June 30 of current fiscal year

MontH (based on current system date)

M - first of current month

H - last day of current month

WeeK

W - Sunday

K - Saturday

PerioD (Posting Period)

P - first day of current posting period

D - last day of current posting period

Quarter

Q - first day of quarter

U - last day of quarter

T - today

+ tomorrow

- yesterday




Keyboard Shortcuts

The following keyboard shortcuts may be used instead of the mouse or in conjunction with the mouse:

FUNCTION

SHORTCUT KEYS

Create

Ctrl+Shift+Enter

Save

Ctrl+Shift+S

Cancel

Ctrl+Shift+X

Edit

Ctrl+Shift+E

Find

Ctrl+F

Print

Ctrl+P

Make screen smaller

Ctrl+- (minus key)

Make screen bigger

Ctrl+ + (add key)


When in the view or edit options in any record the ESC key will allow the user to return to the grid.