Incorrect event fee Balance & Total Paid in Participant Listing report

Scenario nr.1:

1. Event registration with Price Set
2. fee is 20 euro and is paid
3. Price set is changed. 30 euro more is required
4. The Contribution tab shows correct amounts for Amount and Balance Due
5. The Participant Listing report shows something different (Fee = 50 Total Paid = 50 Balance = 0)

Scenario nr.2

1. Event registration with Price Set
2. fee is 50 euro and is not paid
3. payment of 20 euro is recorded
4. Both the contribution tab and the Participant listing report show correct figures.

It seems to me there is a bug in the calculation of the Total Paid and Balance due in the Participant Report. Because at all other places in CiviCRM in scenario 1 the Balance is correct.

changed title from Incorrect event fee Balance Due and Total Paid in Participant Listing report to Incorrect event fee Balance & Total Paid in Participant Listing report

changed the description

mentioned in issue #310 (moved)

Agreed with diagnosis that if the Participant Listing Report shows 50 paid in this workflow then it is a bug.

@magnolia61 will you be creating a patch to fix this? Perhaps we could trade QA on it if you were able to QA something else from @monish.deb ?

Unfortunately this would be beyond my coding skills. I can read code a bit and can create only very small adjustments. By testing and diagnosing I'm trying to help make CiviCRM better. I would be more than happy to help test different scenarios... (also for PR's you need help with)

added needs:concept approval triaged type:request labels

@magnolia61 Can you paste a screenshot of the priceset used for your event? I tried replicating this on my setup but was unable to do so.

Thanks.

The priceset contains two selects of different financial types.

The contribution screen shows the balance of 30 euro

I still can't replicate it :-(. I tried by following the below steps -

• Created two select price fields on a priceset with different financial type.
• Added this set to an event.
• Registered a participant using 1st option eg $10. Completed the registration.
• Changed the selection to another field with a higher amount. Status is now set to "partially paid".
• Contribution tab and the participant report displays the correct balance amount for me.

It would be really helpful if you can add a quick screencast to replicate the issue ?

:-) I think I finally found the needle in the haystack on where the problem originates. Or maybe I should say that I found the right haystack to look in, because I do not know where in code the cause lies.

Anyway I have a priceset that looks like this:

BASIC FEE FNTYPE A (select, required, financial type: FNTYPE_A)
* 50
* 100
OPTIONAL FNTYPE A (checkbox, optional, financial type: FNTYPE_A)
* 50
OPTIONAL FNTYPE B (checkbox, optional, financial type: FNTYPE_B)
* 50

I have two different outcomes for the 'Balance Due' when following two different scenarios:

SCENARIO A

1. register for an event with this priceset. Contribution Pending. Select BASIC FEE: 50
2. record payment for this 50 euro. Contribution is not completed.
3. Go to the event participation. Edit it and change the priceset from to: BASIC FEE 100
4. result is that the total fee is 100 (of which 50 is already paid)
5. Look at the event/participantListing report. It shows: Net amount: 100, Total Paid: 50, Balance: 50

SCENARIO B

1. register for an event with this priceset. Contribution Pending. Select BASIC FEE: 50
2. record payment for this 50 euro. Contribution is not completed.
3. Go to the event participation. Edit it and check the checkbox for the OPTIONAL FNTYPE_A: 50
4. result is that the total fee is 100 (of which 50 is already paid)
5. Look at the event/participantListing report. It shows: Net amount: 100, Total Paid: 50, Balance: 50

SCENARIO C (different financial types)

1. register for an event with this priceset. Contribution Pending. Select BASIC FEE: 50
2. record payment for this 50 euro. Contribution is not completed.
3. Go to the event participation. Edit it and check the checkbox for the OPTIONAL FNTYPE_B: 50
4. result is that the total fee is 100 (of which 50 is already paid)
5. Look at the event/participantListing report. It shows: Net amount: 100, Total Paid: 100, Balance: 0

EVENT PARTICIPANT LISTING REPPORT

PRELIMINARY CONCLUSION

When changing pricesets of a particpant things are ok as long as its the same financial type. When not: the balance due is messed up Why? I do not have a clue :-)

@jitendra @JoeMurray I managed to create my first screen recording ever. :-) Hopefully this will be helpful to understand the issue.

@magnolia61 This does look similar to financial#34 (closed)

PR https://github.com/civicrm/civicrm-core/pull/14763 attempts to solve this but is not quite there.

I'll take a look at this as soon as I can.

The use case I can reproduce is when changing event registration, removing a line item of financial type A and adding a line item of financial type B will cause the allocation of the total amount to be wrong by financial type, but the Total will be correct.

@magnolia61 I do think this is related to https://github.com/civicrm/civicrm-core/pull/14763

Can you test the PR and see if it solves your issue?

It does have failing tests that need to be addressed, but the results I get on it are very good.

Hi @kcristiano, I tried again with current master & 14763 applied.
Unfortunately the report is even more off than earlier in my screencast. When I edit all three contributions, all have the proper amount for total, paid and balance due though!

:-) This is solved by @eileen with https://github.com/civicrm/civicrm-core/pull/15664 Tested all 3 scenarios above and Participant listing report show correct amount paid & balance due. And Bookkeeping report doesn't show ghost line items. :-)

mentioned in issue financial#94 (closed)

changed milestone to %5.20.0

closed