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.
Thank you for the reply. Unfortunately this report does not allow filtering by source name. It only allows filtering by name and associated fields. 'Name' is a completely irrelevant field that we would never have any use for. I can't understand why QB chooses which fields can be used for certain reports. Give us the option.
For now, we're unable to add Source Name in the Filters tab.
As you may have observed, the names that you can see when the Multiple names filter is being applied are vendor profiles. This means that the list of transactions will still be sorted out according to the selected vendors.
Let me also share this article about running reports for additional details: Understand reports.
Add another reply below or visit us again if you need anything else.