Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.19
-
Fix Version/s: 4.7.20
-
Component/s: Accounting Integration, CiviReport
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
-
Verified?:No
Description
When running a bookkeeping transaction report and filtering by a credit code or name, report fails with "DB Error: no such field". Checking log, I found:
sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'financial_account_civireport_credit_1.credit_accounti...")
This problem can be duplicated in http://dmaster.demo.civicrm.org/
The problem is only with the credit side. Report works when filtering by debit.
Attachments
Issue Links
- links to