Is there a way to consolidate the balances/transaction totals of two Vendor records in a saved search?
We have a few vendor records that have the same name but different capitalization (this is due to Integration but is not a good practice).
Example: Apple, Inc. and apple, Inc. are two Vendor records.