@Eileenmcnaughton I'm reviewing the Benefactors page and used FY 2017-2018 total field to pull the list. CID 25659693 donated in that fiscal year, but it doesn't reflect in that field on their contact summary so they were ultimately left off the report. Do you know why they were excluded and/or if there could be others like this?
Description
Description
Event Timeline
Comment Actions
I looked into this & you have found 4 of a total of 1511 contacts that matched this pattern.
I didn't find a systemic reason for the missing total - although they were mostly fairly tightly bunched in terms of when they were received so it seems a particular period was possibly affected.
Running the 'fill' script again resolved them.
- tech details-----------------------
script is
drush civicrm-fill-donor-totals
After that only 42 entries were found with the query
SELECT d.entity_id, receive_date, SUM(COALESCE(IF(receive_date BETWEEN '2017-07-01' AND '2018-06-30 23:59:59', c.total_amount, 0),0)) as total_2017_2018, GROUP_CONCAT(c.id) FROM wmf_donor d LEFT JOIN civicrm_contribution c ON c.contact_id = d.entity_id WHERE d.entity_id >= 1 AND is_2017_donor = 1 AND total_2017_2018 = 0 AND contribution_status_id = 1 AND total_amount > 0 AND (trxn_id NOT LIKE 'RFD %' OR trxn_id IS NULL) GROUP BY d.entity_id;
41 of them were old (2008-2016) and related to how refunds were recorded. The last one was a real anomaly - civicrm/contact/view?reset=1&cid=25659300 was entered by Engage and the contribution had no receive_date. I don't know how that could have happened but I fixed it. It appears to be unique as
select * FROM civicrm_contribution WHERE receive_date IS NULL;
returns NULL