Transaction Saved Search Formula that Pulls Invoices Ending in Number 1 or 2

1. Navigate to Reports > Saved Searches > All Saved Searches > New.

2. Click on Transaction.

3. Under Criteria tab of the Transaction search, set the following filters:

  *Type = Invoice
  *Main Line = True
  *Formula (Numeric); Description = equal to 1; Formula = case when to_char(substr({number},-1,1)) = '1' or to_char(substr({number},-1,1)) = '2'  then 1 else 0 end 

4. Hit Save or Preview.