View source for 6 Ctrl, Shift, N

Ctrl, Shift, N

What does this filter do?

A quick a easy way of filtering is to select the data required, then hold down and press (at the same time) 
"Ctrl + Shift + N"

Filters and Queries can be accessed and created from within reports and lists, across all modules. 
There is no limit to the number of columns and data you can filter on at the same time, but keep in mind the difference 
between an "And" filter and an "Or" filter.

Right mouse click in any number of columns or fields you wish to filter and a range of options will pop up.
Then left mouse click on the desired filter. 
 

And 	filters to name and something else
Or      	filters to name or something else
Partial	filters part of a name/option/word
Exclude 	excludes something eg. date range
Bracket	a bracket can be created with a filter within it then a further one created. To be used when you require a 
			calculation to be done, before another command


When a filter has been created, right mouse click and choose preview to view details.
If you wish to clear a filter you have created, right mouse click and choose Clear Filter from the options.
If the filter you have created is one that would be re-used, this can be saved by right mouse clicking and selecting 
		'Add Custom Filter', (Name and save it), the custom filter will then run automatically when selected in the future. 
You can add further filters as you require.
Creating a "Default Custom Filter" will open that list with this filter active everytime.