At Event Income Report (both Detail and Summary), in the results, contacts deleted with contributions are counted.

I tested it in dmaster and have the same behavior.

Obviously, it's because in the SQL sentence it doesn't appear the contact.is_deleted = 0 in the where clause.

The reason for that behavior is that CiviCRM considers still valid deleted contacts contributions and refuses to delete them.

So, what do you think? It's a bug that needs to be fixed? Create a custom Report? An extension?

Thanks for answering!

  • I haven't checked the code, but "is_deleted = 0" can also be added by ACL clauses. (just to keep in mind if debugging this or comparing with other reports)
    – bgm
    Commented Feb 2, 2017 at 12:42
  • 1
    i edited this hopefully to make it clearer this is about deleted Participants, not deleted Contacts.
    – petednz - fuzion
    Commented Feb 8, 2017 at 5:28

1 Answer 1


Not deleting financial information when a registration is deleted is by design so that organizations can pass audits. One wouldn't want an employee to delete some registrants and pocket the money if there is no checkin at the event, for example.

If you would like to sponsor an extension to optionally change this behaviour it should be fairly simple to create, depending on how you want to approach things.

  • Thanks for your explanation. I got the point on not deleting financial information. But if you delete some Participants with a contibution, and then make an advanced search, the results will not match with the report results. So that's why i was wondering if we can't unify this two different behaviour.
    – Albert V
    Commented Feb 9, 2017 at 8:25
  • 1
    @AlbertV agreed that it would be ideal if things matched between the different contexts. But I think the intent is take account of the purpose of those contexts - one about money, one about finding all the participants - when determining the results.
    – Joe Murray
    Commented Feb 9, 2017 at 19:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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