Filters can be saved and include the actual filter, the columns selected, the column position and the sort order.
Useful Filter Examples
- Inventory requires ordering – Filter = ‘Suggested Qty” is not equal to 0
- Inventory not sold in 2 years – _Filter = _“This Years Units” is 0 + “Last Years Units” is 0. Then set the “Match if” to All
- AR over 120 days – Filter = “Over 120” is not 0
- Sales Order with margin less than X – Filter = “GP %(Average) is less than X
- Purchase orders received in full – _Filter – _ “Remaining Amount” is 0
Filter Save Options.
Add Filter – Adds another filter selection.
Save Default – Once a filter an/or column layout is selected the user can click ‘Save Default’ and then every time they enter this module this is the layout that will be presented. It does not have to be given a name so therefore does not have to be selected.
Remove Default – Removes a default that was previously set.
Save Preset – Save a filter and/or column layout. User will be asked to give it a name and if they want it to be just for the user or for everyone in the company.
Add Filter To Module List – Select this to add the filter to the main menu on the left. Once added it will be indented under the module icon. The list can be accessed by clicking the arrow to the left of the icon.
Remove Filter From Module List – Removes the preset filter from the list.
Delete Preset – Deletes the preset filter.
Filter List – Shows the list of saved filters.
