An invoice search has different field types for filters. These field types each have their own set of comparisons.

For numeric fields, the possible comparison values are as follows.

• =. Searches for numbers that match the entered value exactly.

• <. Searches for numbers that are less than the entered value.

• ≤. Searches for numbers that are less than or equal to the entered value.

• >. Searches for numbers that are more than the entered value.

• ≥. Search for numbers that are more than or equal to the entered value.

• Between. Searches for numbers that fall between the entered value.

For text fields, the possible comparison values are as follows.

• Starts. Searches for values that start with the entered characters.

• Ends. Searches for values that end with the entered characters.

• =. Searches for values that match the entry exactly.

• ≠. Searches for values that do not match the entry.

• Includes. Searches for values that contain the given search string anywhere in the dimension.

• Like. Searches for values that match a specified pattern.

  For example, enter x%y to search for invoices that start with x and end with y.

• Where in. Searches for the values provided in this field as a semicolon-separated list.

• Where not in. Searches for values that are not in the semicolon-separated list provided in this field.

For date fields, the possible comparison values are as follows.

• =. Searches for dates that match the entered date exactly.

• <. Searches for dates that are earlier than the entered date.

• ≤. Searches for dates that are earlier or equal to the entered date.

• >. Searches for dates that are later than the entered date.

• ≥. Search for dates that are later or equal to the entered date.

• Range. Searches for dates that are within the range of entered dates.

• Between. Searches for dates that fall between the entered dates.

For check box fields, the possible comparison values are as follows.

• =. Searches for invoices where the Canceled Status or the PO Invoice matches the selection exactly.

• ≠. Searches for invoices where the Canceled Status or the PO Invoice does not match the selection.