Home > Counter Control Help Documentation > Procedures > Record Selection Criteria

Record Selection Criteria


 

Overview

 

The Record Selection Criteria utility can be found in most tables, reports, and utility programs (such as the purchase order program and the record stuffer).  The Record Selection Criteria screens are designed to filter items within a group, and have subtle changes in usage depending on the location that it will be used.

 

                                                                        


 

Usage


When using the utility within a table (inventory, accounts, etc.) the user will click the Record Selection Criteria icon (or click the F5 function key).  When using the utility within a program (reporting, the purchase order program, the record stuffer, etc.) the user will see a screen dedicated to filtering information.  However, the program’s functionality is identical in all locations.



 

Step #1:  Start by entering the field to be filtered.  Almost every field within the table (inventory, accounts, suppliers, etc.) is an option for being filtered.  The exception to the rule is some of the calculated fields. 




Select the appropriate field within the box.



 

Step #2:  Select the method the information will be filtered. 


Choose from:

Examples:

Examples:

Examples:

Examples:

Examples:

Examples:

Examples:

Examples:

Examples:

 

Step #3:  Select what the filter represents


Choose from:

 

Step #4:  Enter the appropriate information dependent on the selections above.

 

Step #5View By…

Choose from:

 

 

 

 

Additional Processes
  and  

( ) :using parenthesis will allow users to organize the search criteria, and search for criteria within criteria.

For example:

MFG EQUALS “Wix”

AND (SalesPeriod1 is NOT EQUAL to “0”

OR (SalesPeriod2 is NOT EQUAL to “0”)

 

This will allow users to do the following items simultaneously:

 

MFG equals WIX and SalesPeriod1 is not 0,

OR

MFG equals WIX and SalesPeriod2 to is not 0.

 





See also

Adjusted Selling Price
Background Tasks
Cash Drawer
Dated Billing
Debugging
Deleting Records
Donations
End Of Day
Gift Cards
Initial Set Up
Interstore Transfer
Inventory Import and Update
Inventory Price Level Calc Procedure
Setup and Create Customer Backorders


Record Selection Criteria Last Updated on 2/28/2014 JMM