Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-20530

Bookkeeping transaction report fails at acct credit filter

    Details

    • 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

          Activity

            People

            • Assignee:
              monish.deb Monish Deb
              Reporter:
              loganbear Logan Bear
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: