Previous Topic

Next Topic

Book Contents

Book Index

Filtering a list

For every list of records you create, you can filter that list, or narrow down the list to records with certain criteria. For example, out of a long list of inventory items, you may only want to see those items in a particular location. You narrow down that list by filtering by that particular location.

To filter a list:

  1. In the green bar above the list, you see two fields, Filter and Contains.
  2. From the Filter drop-down, select the type of criteria you want to filter by. For example, when filtering the Inventory By Item report, you can filter by Item #, Description, Group, Serial #, Lot #, Preferred Vendor, Product id, Expire date, Item receipt date, or Location.
  3. In the Contains field, enter the value you want to filter by. For example, if you had selected Location for your filter type, you would enter all or part of the location name in the Contains field. If you are filtering by a number or a date, the Contains field changes to two fields, From and To. Enter the range you want to filter by. See the following examples:

    Filter Example

    Filter Example - From To

    If you are entering a date, you can enter an absolute date (mm/dd/yyyy), a relative date (e.g. "-7" for seven days previous, "+5" for five days from now), or "today". For example, you could filter by Item receipt date in range "-7" to "today" to find all of the items received in the past week.

  4. Click the Filter button to the right. The results appear below.

    Filter Results

  5. To clear filter settings, select Show All Show All button in the top right corner.

See Also

Tips for working efficiently in SmartTurn

Sorting a list

Filter or sort a lookup list

One-click check box to select all rows

Printing

Exporting lists and documents

Separating inventory with splits

If you can't see certain data

© 2009 SmartTurn, Inc. www.smartturn.com