Is there a way to filter Source Names in reports?
Example: We have vendors named A, B, C, D etc. We run the Item Actual Cost Detail and switch the display from Name to Source Name so that we get a column with our vendor names. But we only want the report to show the Vendors with a vowel name (A, E, I, O, U.) We could export to Excel and filter there but all we know is that we want the vowels and we don't know what a vowel is. We'd like to go into the vendors and tell QB what vowels are...sometimes we might want Y after all.
How do we get the report to only show us the vowel source names? We can add columns to filter fields in Name but of course Name is a weirdly irrelevant column.