Managing Custom Queries

If you expect to run the same Advanced Query frequently, you can save your criteria as a Custom Query and run it from the Payable List screen. You can also set a Custom Query as the default query, which will be performed every time the Payable List screen displays.

You can delete a Custom Query that you no longer need. If you delete the default query, the default Standard Query is restored.

Saving a Custom Query

To save a Custom Query:

  1. With the results of an Advanced Query displayed on the Payable List screen, click Save this custom query.

  2. In the Query Name field, enter a new name for the query.

  3. (Optional) To make this query the new default, click Yes.

  4. Click Save Query. The name of the new query is added to the list of Custom Queries on the Payable List screen.

Running a Custom Query

To run a saved Custom Query:

  1. On the Payable List screen, select the query from the Select Query list.

  2. Click Apply.

Setting the Default Query

To set a Custom Query as the default:

  1. With the query results displayed on the Payable List screen, click Update/Set Current Query as Default.

  2. Click Yes to make this the default query.

  3. Click Save Query.

Editing a Saved Query

To edit a saved query:

  1. Select SUA Payables > Advanced Query, or click the Advanced Query button on the Payable List screen or on the Manage Payables tab of the SUA Overview screen.

  2. From the Query list, select the saved query.

  3. Modify the query fields as needed.

  4. Click Process.

  5. To save the changes you made to the query, follow the steps in Renaming a Custom Query.

Renaming a Custom Query

To rename a Custom Query:

  1. With the query results displayed on the Payable List screen, click Update / Set Current Query as Default.

  2. Modify the name in the Query Name field.

  3. (Optional) If this is not the default query and you want to make it the default, click Yes.

  4. Click Save Query.

Deleting a Custom Query

To delete a Custom Query:

  1. With the query results displayed on the Payable List screen, click Update / Set Current Query as Default.

  2. Click Delete.

  3. When prompted to confirm the deletion, click Yes, Delete.