Allocation issue Multi Event Registrations with checkboxes
Follow up to #94 (closed)
Using Existing Database
Registered for event:
Choose Basic Registration Price set line line items options for Event, Guest Fee, and Extra Meals -- All Checkboxes
Event 820 Guest 100 Meals 225 Total 1,145.00
Edited Event Changed selections Remove meals (Checkboxes) Recorded refund $225
Contribution status shows $920
However, Bookkeeping report shows -225
In SQL
The contribution looks as expected:
select c.id,c.contact_id,c.total_amount,c.fee_amount,c.net_amount,c.trxn_id,c.receive_date,c.contribution_status_id,cov.name
from civicrm_contribution c
join civicrm_option_value cov on cov.value = c.contribution_status_id and cov.option_group_id = 11 and cov.value = c.contribution_status_id where c.id = 16095
The Line Items are fine
select li.id,li.entity_table,li.entity_id,li.contribution_id,li.label,li.line_total,li.financial_type_id,ft.name
from civicrm_line_item li join civicrm_financial_type ft on ft.id = li.financial_type_id where li.contribution_id = 16095
civicrm_financial_trxn appears to be where we start to go off
select cft.id,cft.from_financial_account_id, cft.to_financial_account_id,cft.trxn_date,cft.trxn_id, cft.total_amount,cft.status_id
from civicrm_financial_trxn cft
where cft.id >= '18121'
The issue appears to be in civicrm_entity_financial_trxn
join civicrm_financial_trxn cft on cft.id = eft.financial_trxn_id and cft.trxn_date >= '2019-11-04'
where eft.id >= 77057
order by eft.financial_trxn_id
This may be an issue with Data Types (Checkboxes) or an issue with this client Database.
Will comment with Steps to reproduce on a clean d7master/wpmaster
If I cannot reproduce, I will close.