Power Searches

If the Quick Search, Filter By and Cross-reference tools aren’t enough to produce the desired records, the Power Search is a very powerful searching tool that gives you access to every table and field in the entire database. It also allows you to build (and save!) multi-line searches that can be used over and over again and even shared with other system users.

Each of these search tools can be used independently to produce a list of records to work with. Also, you can combine these tools in a single search for a very focused result.

In this article we'll look at creating and saving a Power Search that will display a list of Sales Orders that we Invoiced to our Widget Buyer Client for the last quarter of Fiscal Year 2012.

1. Open the Sales Order window

1. Open the Sales Order window

2. Start entering the search criteria

2. Start entering the search criteria

2.1 Finish entering the search criteria and Save the Power Search

2.2 Name the Power Search

2.2 Name the Power Search

2.3 Set User access to the Power Search

2.3 Set User access to the Power Search

3. Run the Power Search

4. View the results of the Power Search

Power Search Help

Alpha & Text

Alpha & Text

Dates

Dates

Numeric

Numeric

Boolean

Boolean

Record Count Queries

Record Count Queries