From bb40e74438a731ea4cf9cb3978acc9be52212ce8 Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Sun, 21 May 2017 00:14:06 +0530 Subject: [PATCH] CRM-20585, changed query since to financial accoun holds deferred revenue now ---------------------------------------- * CRM-20585: Correct the from and to accounts for deferred revenue transactions https://issues.civicrm.org/jira/browse/CRM-20585 --- CRM/Report/Form/Contribute/DeferredRevenue.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Report/Form/Contribute/DeferredRevenue.php b/CRM/Report/Form/Contribute/DeferredRevenue.php index 9447082bc8..72f5a5e324 100644 --- a/CRM/Report/Form/Contribute/DeferredRevenue.php +++ b/CRM/Report/Form/Contribute/DeferredRevenue.php @@ -302,7 +302,7 @@ class CRM_Report_Form_Contribute_DeferredRevenue extends CRM_Report_Form { ON entity_financial_trxn_item.entity_id = {$this->_aliases['civicrm_financial_item']}.id AND entity_financial_trxn_item.entity_table = 'civicrm_financial_item' INNER JOIN civicrm_financial_trxn {$this->_aliases['civicrm_financial_trxn_1']} - ON {$this->_aliases['civicrm_financial_trxn_1']}.from_financial_account_id = {$this->_aliases['civicrm_financial_account']}.id + ON {$this->_aliases['civicrm_financial_trxn_1']}.to_financial_account_id = {$this->_aliases['civicrm_financial_account']}.id AND {$this->_aliases['civicrm_financial_trxn_1']}.id = entity_financial_trxn_item.financial_trxn_id INNER JOIN civicrm_entity_financial_trxn financial_trxn_contribution ON financial_trxn_contribution.financial_trxn_id = {$this->_aliases['civicrm_financial_trxn_1']}.id -- 2.25.1