CiviCRM Community Forums (archive)

We're finding that payments for multiple registrations events is hard to track.

In the interface
When I enable multiple participants on a paid event, the contribution is on the first participant, and the amount is the total due for all participants.  The subsequent participants (correctly) show as registered, but there's no record on the contributions tab and no way (that I've found) to tell that this registration was paid by someone else.   Is there something I'm not seeing?

Reporting
For the desk at the event, I'd like to be able to have a report that shows "status" "amount due" "amount paid" "balance" for every participant, and "paid by" for those paid by someone else.    I tried the Attendee List and Event Participant reports, but the fee level shows the **total** amount for the first participant **plus** the subsequent participants show their own amount, so if you just sum those, you've essentially double counted all the subsequent participants's fees.

Digging in to the database, I see that the civicrm_participant record for subsequent records shows "registered by" the first participant, and the contribution is tied to the first person's registration in the  civicrm_participant_payment table, so to get the report I need I could do some calculations,  but I'm hoping there's  better/easier way.

Thanks for any guidance

Thanks for your comment CiviTeacher.

Not sure I understand.  You say " explore the participation record deeper and you will see that it indicates the registration was paid for by someone else"  Is that something different than what I already noted the "registered by" field?  I ran through this on the 4.5 demo and as far as I can tell there's no change to this vs. my current version of 4.2.6.  I also checked the db schema http://d45.demo.civicrm.org/civicrm/participant/add?reset=1&action=add&context=standalone&eid=7 and I don't see anything new there. (Planning to upgrade but keep getting derailed by other urgent matters)

And thanks for the suggestion on extended report, but that still seems to show the **total** amount for the first record and **no** contribution for the subsequent record.

Here's what I'm getting on the reports...

Name   Status      Fee Amount   Contribution ID   Total Amount   Line Total
n 1      Registered   $395.00      2631         $ 790.00      $ 790.00
n 2      Registered   
$395.00                           $ 395.00


Here's what would be useful.  Wouldn't have to be just like this but something along these lines ...

Name   Status      Fee Amount   Contribution ID   Total Amount   Line Total
n 1      Registered   $395.00      2631         $ 790.00      $ 395.00
n 2      Registered   
$395.00                           $ 395.00  (paid for by n 1 on contribution 2631)