From cede597f4de2091f27d060bcc73e18bca747ab96 Mon Sep 17 00:00:00 2001 From: Dave Greenberg Date: Tue, 13 Oct 2015 15:06:54 -0700 Subject: [PATCH] CRM-17305 - Fix handling of processor fees in Participant Listing report. ---------------------------------------- * CRM-17305: Contribution fees are affecting reporting of total paid and balanace https://issues.civicrm.org/jira/browse/CRM-17305 --- CRM/Report/Form/Event/ParticipantListing.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/CRM/Report/Form/Event/ParticipantListing.php b/CRM/Report/Form/Event/ParticipantListing.php index 3be767c354..e985c2f927 100644 --- a/CRM/Report/Form/Event/ParticipantListing.php +++ b/CRM/Report/Form/Event/ParticipantListing.php @@ -543,9 +543,12 @@ ORDER BY cv.label ON (eft.entity_id = {$this->_aliases['civicrm_contribution']}.id) LEFT JOIN civicrm_financial_account fa ON (fa.account_type_code = 'AR') + LEFT JOIN civicrm_financial_account fae + ON (fae.account_type_code = 'EXP') LEFT JOIN civicrm_financial_trxn ft ON (ft.id = eft.financial_trxn_id AND eft.entity_table = 'civicrm_contribution') AND - (ft.to_financial_account_id != fa.id) + (ft.to_financial_account_id != fa.id) AND + (ft.to_financial_account_id != fae.id) "; } } -- 2.25.1