Include Max Date of the associated Paying Transaction in the search? That way if there's more than one, you have the most recent.