Membership Details report, "Payment Amount (most recent)" returns total amount for all membership contributions instead of the most recent Contribution for the Membership renewal
Membership Details report, "Payment Amount (most recent)" returns total amount for all membership contributions instead of the most recent Contribution for the Membership renewal.
Steps to reproduce
- Locate an existing Contact with a membership, eg. "Dr. Jacob Terrell-Terry Sr." https://dmaster.demo.civicrm.org/civicrm/contact/view?reset=1&cid=33
- Renew the membership and enter in a contribution amount, $150
- Save the contribution
- Open the Membership Details report, https://dmaster.demo.civicrm.org/civicrm/report/instance/23
- Display column: "Payment Amount (most recent)"
- Set Contact filter to locate the contact, eg. Terrell
- Report displays $250 value for "Payment Amount (most recent)" column
- Expected result is "Payment Amount (most recent)" shows $150 (not the combined total)
It is also confusing to label the column "Payment Amount (most recent)" and then in the results show the column as "Amount".
As verified on CiviCRM 5.36.alpha1 - https://dmaster.demo.civicrm.org
Agileware Ref: CIVICRM-1664