I have two databases on the same accounts with exactly the same products and customers.
When I generate a sales report combining the two databases, I get a duplicate product names. For an example, I get Product x and Product x (2).
Is there a way to group the same product from the databases into one?