2

Stripe.com shows we received a donation of $15. It correctly shows on the Civi Contribution Dashboard. When we run Civi Report, the amount shows up as $30. We have many cases when the report and the dashboard give the correct results. This is the first time when the amounts do not agree. Anybody know what is wrong? enter image description here

5
  • can you add a screenshot of the expanded section below the $15 , and/or of the 'View' version of that contribution
    – petednz - fuzion
    Apr 22, 2019 at 22:18
  • I found that removing Donor Phone from the columns stops the report showing a double amount. Asking for the Donor Phone adds the following to the query LEFT JOIN civicrm_phone phone_civireport ON contact_civireport.id = phone_civireport.contact_id AND phone_civireport.is_primary = 1 Apr 23, 2019 at 3:00
  • I found that the donor had two home phone numbers in her contact info. Removing the second home phone, resulted in the amount not being doubled. Apr 23, 2019 at 3:04
  • Thanks for sharing your solution -> copy/paste it into an answer (you can answer your own question) Apr 23, 2019 at 4:08
  • only one of those phones should have been 'is_primary' so something with that report may be off
    – petednz - fuzion
    Apr 23, 2019 at 9:05

1 Answer 1

1

I found that the donor had two home phone numbers in her contact info. Removing the second home phone, resulted in the amount not being doubled.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.