Membership Detail Report Date Recieved Value is Incorrect
Overview
The Membership Detail report (CRM_Report_Form_Member_Detail) reports about the oldest contribution when there are multiple contributions associated with a membership.
Current behaviour
The sql that selects the contribution associated with the membership uses a simple left join which will select the oldest contribution towards that membership (or at least, the one with the lowest id, which is usually the oldest one).
That contribution information is not as useful as the most recent contribution associated with a membership.
Expected behaviour
I would expect to be reporting on the most recent contribution associated with a membership!
Comments
Here's where the SQL is getting added: https://github.com/civicrm/civicrm-core/blob/d4780a599def82852c30bb0475f2e34370932683/CRM/Report/Form/Member/Detail.php#L296
PR forthcoming.