Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-5747

CiviReport and Event Search show Fee for Amount, not actual contribution

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Won't Fix
    • Affects Version/s: 3.0, 3.0.1, 3.0.2, 3.0.3, 3.0.4, 3.1, 3.1.1
    • Fix Version/s: 4.3.0
    • Component/s: None
    • Labels:
      None

      Description

      Please See: http://forum.civicrm.org/index.php/topic,11955.0.html
      We have a very common use case: backend registration of users at prices different than the Fee / price set (often "Free", for speakers or staff). We may make exceptions for various reasons and cannot rely on published fees. It appears there is a provision for "Recording Payment" in the "Register New Participant" option of the Event drop down. When recording a payment, however, if the payment is less different than the fee, then the Income report does not show the actual revenue of the event. In fact, I can't figure out a way to generate the correct report that only pulls contribution records associated with a participant of an event. The problem is that the contribution must be associated with the participant of a specific event, and not the contact.

      I'm concerned about a few things here:
      1. A way to satisfy this common use case (where the payment does not match the fee)
      2. There is no warning about this when creating a contribution record (BTW - it should fill in the fee amount as default.)
      3. The "Income Report" (which I suggest changing to "revenue" since it does not include costs) is misleading (Perhaps "Fee report") unless it counts contributions.
      4. I see in the database civicrm_participant_payment which links participants to payments, but I can't see how to integrate that in any of the UI query tools. I would go so far as to say that the all the Find Participant fields (total amount, etc.) should be based on actual contributions, rather than published fees.

      Note:
      As for the implementation, I think there are three areas to address:
      1. Reports (Create a report that looks up contributions by participant, not fees)
      2. Searches (add contribution field or replace fees)
      3. Export (add contributions to field list)

      In fact, I wonder if user label shouldn't be "Payment Received" or "Payment" rather than "contribution", since it could easily be confused with Contribution Page entries.

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              sonicthoughts shawn holt
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: