Find Data - Instantly!
When the phone is ringing or a line of customers are standing right in front
of you--we understand that you need to be able to view, enter, and if necessary,
find data--any data--fast. One of the greatest strengths of OneSource is the
ability to display pertinent data on each screen, link to related data with
1 click, or search and find the data you need--fast!
The following links provide an overview of the various searching features included
in OneSource:
OneSource to Enter, Find & Analyze Data
OneSource can truly become your single source to input, manage and find the following types of data:
- Customers & Suppliers + unlimited contacts for each
- Prospects & Leads + unlimited contacts for each
- Quotes, Sales Orders, Invoices
- Activities: Meetings, Calls, Deliveries, Tasks, etc.
- Jobs, Projects, Service Contracts
- Inventory Items, Unlimited Pricing Options per Item or Item Type / Per Customer
- Purchase Orders
- Accounts Receivable
- Accounts Payable
- Banking / Checking
- General Ledger, Financial Reports
- Documents: Proposals, Letters, E-Mails, Faxes, etc.
- Etc...
Data where you need it, when you need it.
It's one thing to be able to find data fast, but it's even better to not have
to search for data at all. Most OneSource data entry screens (Quotes, Sales
Orders, Invoices, Customers, Inventory, etc.) provide virtually all pertinent
data to perform the function that you are doing right on the same screen--preventing
the need to go looking for data in the first place. Another common trait of
nearly every screen is the the ability to find related data with 1 click using
the magnifying glass icon.
Finding data with a Simple or Refined Search
- Using a menu option (or a function key, such
as F3, F4, etc...) the Simple Search form is immediately displayed with the
type of data you want to search.
- Each keystroke immediately filters the search
list to the closest record matching the criteria entered in the search field.
(This typically allows a record to be located and displayed with only 2 or
3 keystrokes).
- To speed up the searching process, the system memorizes and displays your
last Search By criteria.
- By clicking on the "Refined Search" button, you can immediately
define, on the fly, which columns will be searched and how the search will
be performed (such as begins with, contains, etc.)

Finding data using a right click filter--on any field.

Right click on virtually any field on any screen to use context sensitive tools
(as illustrated above) to immediately find or sort data of that type, including:
- Filter By Selection: Find all records that have the same value that you have highlighted.
- Filter Excluding Selection: Find all records Excluding the value that you
have highlighted.
- Filter For: Find all records that have an exact value, a value that begins
with..., a value that ends with, a value that is contained anywhere in the
field, etc.
- Sort Ascending: Sort all records in ascending order.
- Sort Descending: Sort all records in descending order.
Finding data using the instant spreadsheet view.
Press F11 on almost any form to instantly view a summarized spreadsheet type of view of all records contained in the filter/search. Use right click filters or sorting to narrow your search with a single click.
Performing Advanced Queries
You can open or create any number of advanced queries, displaying the exact fields, based on your exact criteria, based on a combination of one or more tables. The result can then be viewed, printed, saved or used as a data source for a form or report.
For more information how to Find Data - Instantly!
with OneSource, please contact a sales
or customer service representative at OneSource
Software Solutions at (866) 204-4997.