Filtering records in EFT Processing

On all screens, you can type a value in the fields and use the Enter key to filter by the default condition (e.g. contains for Text fields, is After for Date fields ).

Orchid EFT now supports Sage Intacct's advanced filtering as descxribed in this page.

You can also sort by all columns on the screens. See Sorting records in EFT Processing

For an overview and tips on using filters, refer to video

This applies to the following Orchid EFT Processing screens to select records and to view EFT Files.

  • EFT File List

  • AP Payment Request

  • AR Payment Request

  • Employee Expense Payment Request

  • Create AR Payment

Active filters

If you can't see all the records you expect to see on the screen, check if there are any active filters.

There are two indications on the screens that filters are active.

  • The Filter icon next to the column name is filled in. The icon is only an outline if there are no filters for the column.

  • On the Advanced Filter icon, you can see the number of active filters.

Example:

On the EFT File list, we have added a filter by Date Created and one by Status to show only New files, created since 1/12/2025.

Clearing Filters

Clearing filters on one column

To clear a filter on one field only, select the icon next to the column name and choose Clear.

Viewing / Clearing all filters

To view all filters and clear them (or modify a few filters on one screen), use the Filters icon on the top right of the screen.

  • To remove all filters, use the Clear button and all records are displayed.

  • To remove a filter, select the - button next to the filter you want to remove

  • You can change the , and of the filters.

  • To add a new filter, use the + button

  • Use Apply to save the filters.

Filtering Records - Examples

Filtering based on the list of existing values

Choose the Is One Of or Is not one of

When you go to the Value field, the list of existing values for the field is displayed.

Fields available to filter by:

  • You can filter by any fields on the screen using the filter icon next to the column or add filters using the Advanced Filter button on the top right of the screen.

  • Vendor/Customer/Employee Types and Payment Created by are available to use as filters.

When working at Entity Level in Sage Intacct

If working in Sage Intacct at the Entity Level, the only shows the user name for payments created by the logged on user. The payment is displayed in the list, but the field is blank.

If you have security rights at the top level, you can view and filter by the name for all users.

Filtering records - Examples

You can filter records using the Filter icons next to each column and the Advanced Filter icon.

See examples in Filtering records in EFT Processing

Example:

In the EFT File List, you can filter based on the Status field - Choose and select all options you want to view.

Example:

In the EFT Payment Request screen, to filter by Payment Method, you can type a value and Enter to filter by the default condition (contains).

For more advanced filters, click on the Finder icon next to the Payment method field.

To display all values, select : Is one of or Is not one of and you can select the values required, for example "Printed Checks"

You can filter by Vendor name using Contains, Is One of or Is Not One of

Example:

Filtering on the EFT AR Payment Request screen - Customer name example

Example:

Filtering on the EFT Employee Expenses Request screen - Payment method example