The first and easiest way to find a requisition, purchase order, receipt, refund, invoice etc. is to use the grids and filter on the piece of information you have.
- Start a Simple Grid Search, using the following search tools:
- =value or .eq value will select all records equal to the value entered
- > value or .gt value will select all records greater than the value entered
- >= value or .ge value will select all records greater than or equal to the value entered (default behavior for numeric fields)
- < value or .lt value will select all records less than the value entered
- <= value or .le value will select all records less than or equal to the value entered
- <> value or .ne value will select all records not equal to the value entered
- ~ value or .like value will select all records starting with the value entered (only works for text fields; this is the default behavior for text fields if no operator is entered)
- *= value1,value2,value3 etc. or .oneOf value1,value2,value3 etc. will select records containing one of the values listed (NOTE: only works for numeric fields)
- value1..value2 or .between value1,value2 will select records between the values listed
2. Users can Sort any Column by ascending or descending order by simply clicking on the column header name. To filter by more than one column, select the first column then hold down the shift and select the second column you want to filter on.
3. Use the More Button to add or take away filter options in your grid. Click on the carrots to expand search options. Check the box you want and it instantly shows on your grid.
4. An Advanced Query Option is a great way to fine tune your search. Select the 
button.
Example: You are looking for a receipt that was for the football team and you know it came from the Athletic Boosters but you don't have a date or an amount.
Advanced Query Results
