Grid Search
Advanced Query Search
Activity Ledger Query Search

1. Simple Grid Search

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.

...

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.

...

More Button on Grid

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.

...

2. Advanced Query

An advanced query is a great way to fine tune your search. Select the button.

...

Advanced Query Tutorial Video

3. Activity Ledger Query

Activity Ledger Query is a query only grid allowing you to filter existing transactions under the TRANSACTIONS menu.  They include:

• Purchase orders

• Invoices

• Disbursements

• Receipts

• Refunds

• Transfers

• Distributions

You can filter your data by entering your search criteria in the filter row. Click on any row of the search results to see a highlight view of the record.   The More button on the grid will allow more properties to be added as a column onto your grid.  The Advanced Query can be utilized to further filter the grid down. The Report option allows you to generate a quick report of your filtered data.

The Image Added will limit the grid results for improved responsiveness.  Grid results minimum range is 100 records and the maximum is 2000.

In the example below, a multi-vendor purchase order was filtered in order to view the transaction history.  A primary sort was done on the transaction 'type' and a secondary sort on the transaction 'date' in order to view sequentially the invoices and disbursements processed against the purchase order.

...