bad query: 
            WITH custom_currency_table(currency_id, rate) AS ((VALUES (46, 1.0), (1, 1.0), (172, 1.0), (156, 1.0), (170, 1.0), (2, 1.0), (171, 1.0), (168, 1.0), (47, 1.0)))
            -- Final select that gets the following lines:
            -- (where there is a change in the rates of currency between the creation of the move and the full payments)
            -- - Moves that don't have a payment yet at a certain date
            -- - Moves that have a partial but are not fully paid at a certain date
            SELECT
                   subquery.grouping_key,
                   ARRAY_AGG(DISTINCT(subquery.currency_id)) AS currency_id,
                   SUM(subquery.balance_currency) AS balance_currency,
                   SUM(subquery.balance_operation) AS balance_operation,
                   SUM(subquery.balance_current) AS balance_current,
                   SUM(subquery.adjustment) AS adjustment,
                   COUNT(subquery.aml_id) AS aml_count
              FROM (
                -- Get moves that have at least one partial at a certain date and are not fully paid at that date
                SELECT
                       account_move_line.currency_id AS grouping_key,
                       ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) AS balance_operation,
                       ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) AS balance_currency,
                       ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate AS balance_current,
                       (
                          -- adjustment is computed as: balance_current - balance_operation
                          ROUND( account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate
                          - ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places)
                       ) AS adjustment,
                       account_move_line.currency_id AS currency_id,
                       account_move_line.id AS aml_id
                  FROM "account_move_line_in_currency_2" AS "account_move_line",
                       account_account AS account,
                       res_currency AS aml_currency,
                       res_currency AS aml_comp_currency,
                       custom_currency_table,
                       -- Get for each move line the amount residual and amount_residual currency
                       -- both for matched "debit" and matched "credit" the same way as account.move.line
                       -- '_compute_amount_residual()' method does
                       -- (using LATERAL greatly reduce the number of lines for which we have to compute it)
                       LATERAL (
                               -- Get sum of matched "debit" amount and amount in currency for related move line at date
                               SELECT COALESCE(SUM(part.amount), 0.0) AS amount_debit,
                                      ROUND(
                                          SUM(part.debit_amount_currency),
                                          curr.decimal_places
                                      ) AS amount_debit_currency,
                                      0.0 AS amount_credit,
                                      0.0 AS amount_credit_currency,
                                      account_move_line.currency_id AS currency_id,
                                      account_move_line.id AS aml_id
                                 FROM account_partial_reconcile part
                                 JOIN res_currency curr ON curr.id = part.debit_currency_id
                                WHERE account_move_line.id = part.debit_move_id
                                  AND part.max_date <= '2024-05-31'::date
                             GROUP BY aml_id,
                                      curr.decimal_places
                           UNION
                               -- Get sum of matched "credit" amount and amount in currency for related move line at date
                               SELECT 0.0 AS amount_debit,
                                      0.0 AS amount_debit_currency,
                                      COALESCE(SUM(part.amount), 0.0) AS amount_credit,
                                      ROUND(
                                          SUM(part.credit_amount_currency),
                                          curr.decimal_places
                                      ) AS amount_credit_currency,
                                      account_move_line.currency_id AS currency_id,
                                      account_move_line.id AS aml_id
                                 FROM account_partial_reconcile part
                                 JOIN res_currency curr ON curr.id = part.credit_currency_id
                                WHERE account_move_line.id = part.credit_move_id
                                  AND part.max_date <= '2024-05-31'::date
                             GROUP BY aml_id,
                                      curr.decimal_places
                            ) AS ara
                 WHERE ((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" in (10))) AND ("account_move_line"."date" <= '2024-05-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) AND (("account_move_line"."journal_id" IS NULL  OR ("account_move_line"."journal_id" in (SELECT "account_journal".id FROM "account_journal" WHERE 
                        NOT EXISTS (
                            SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids"
                            WHERE "account_journal__user_ids"."journal_id" = "account_journal".id
                        )
                    ))) OR FALSE))
                   AND account_move_line.account_id = account.id
                   AND account_move_line.currency_id = aml_currency.id
                   AND account_move_line.company_currency_id = aml_comp_currency.id
                   AND account_move_line.currency_id = custom_currency_table.currency_id
                   AND account.account_type NOT IN ('income', 'income_other', 'expense', 'expense_depreciation', 'expense_direct_cost', 'off_balance')
                   AND (
                        account.currency_id != account_move_line.company_currency_id
                        OR (
                            account.account_type IN ('asset_receivable', 'liability_payable')
                            AND (account_move_line.currency_id != account_move_line.company_currency_id)
                        )
                   )
                   AND NOT EXISTS (
                        SELECT 1
                          FROM account_account_exclude_res_currency_provision
                         WHERE account_account_id = account_move_line.account_id
                           AND res_currency_id = account_move_line.currency_id
                   )
                   AND (
            NOT EXISTS (
                SELECT 1
                  FROM account_partial_reconcile part_exch
                 WHERE part_exch.exchange_move_id = account_move_line.move_id
                   AND part_exch.max_date <= '2024-05-31'::date
            )
        )
              GROUP BY account_move_line.id, aml_comp_currency.decimal_places,  aml_currency.decimal_places, custom_currency_table.rate
                HAVING ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) != 0
                    OR ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) != 0.0
                UNION
                -- Moves that don't have a payment yet at a certain date
                SELECT
                       account_move_line.currency_id AS grouping_key,
                       account_move_line.balance AS balance_operation,
                       account_move_line.amount_currency AS balance_currency,
                       account_move_line.amount_currency / custom_currency_table.rate AS balance_current,
                       account_move_line.amount_currency / custom_currency_table.rate - account_move_line.balance AS adjustment,
                       account_move_line.currency_id AS currency_id,
                       account_move_line.id AS aml_id
                  FROM "account_move_line_in_currency_2" AS "account_move_line"
                  JOIN account_account account ON account_move_line.account_id = account.id
                  JOIN custom_currency_table ON custom_currency_table.currency_id = account_move_line.currency_id
                 WHERE ((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" in (10))) AND ("account_move_line"."date" <= '2024-05-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) AND (("account_move_line"."journal_id" IS NULL  OR ("account_move_line"."journal_id" in (SELECT "account_journal".id FROM "account_journal" WHERE 
                        NOT EXISTS (
                            SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids"
                            WHERE "account_journal__user_ids"."journal_id" = "account_journal".id
 ...<message too long, truncated>

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2028, in __call__
    response = request._serve_db()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1616, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1643, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1847, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_http.py", line 237, in _dispatch
    response = super()._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
    result = endpoint(**request.params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 700, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 42, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 468, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 453, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3799, in get_report_informations
    lines = self._get_lines(options, all_column_groups_expression_totals)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1918, in _get_lines
    lines = self._fully_unfold_lines_if_needed(lines, options)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1947, in _fully_unfold_lines_if_needed
    to_insert = self._expand_unfoldable_line(line_dict['expand_function'], line_dict['id'], groupby, options, progress, 0,
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4038, in _expand_unfoldable_line
    expansion_result = expand_function(line_dict_id, groupby, options, progress, offset, unfold_all_batch_data=unfold_all_batch_data)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4149, in _report_expand_unfoldable_line_with_groupby
    rslt_lines = line._expand_groupby(line_dict_id, groupby, options, offset=offset, limit=limit_to_load, load_one_more=bool(limit_to_load), unfold_all_batch_data=unfold_all_batch_data)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5075, in _expand_groupby
    all_column_groups_expression_totals = self.report_id._compute_expression_totals_for_each_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2213, in _compute_expression_totals_for_each_column_group
    current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2367, in _compute_expression_totals_for_single_column_group
    formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2712, in _compute_formula_batch
    return getattr(self, engine_function_name)(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3156, in _compute_formula_batch_with_engine_custom
    rslt[(formula, expressions)] = custom_engine_function(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 152, in _report_custom_engine_multi_currency_revaluation_to_adjust
    return self._multi_currency_revaluation_get_custom_lines(options, 'to_adjust', current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 349, in _multi_currency_revaluation_get_custom_lines
    self._cr.execute(full_query, params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 321, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.GroupingError: column "account_move_line.currency_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 19:                        account_move_line.currency_id AS grou...
                                ^

bad query: 
            WITH custom_currency_table(currency_id, rate) AS ((VALUES (46, 1.0), (1, 1.0), (172, 1.0), (156, 1.0), (170, 1.0), (2, 1.0), (171, 1.0), (168, 1.0), (47, 1.0)))
            -- Final select that gets the following lines:
            -- (where there is a change in the rates of currency between the creation of the move and the full payments)
            -- - Moves that don't have a payment yet at a certain date
            -- - Moves that have a partial but are not fully paid at a certain date
            SELECT
                   subquery.grouping_key,
                   ARRAY_AGG(DISTINCT(subquery.currency_id)) AS currency_id,
                   SUM(subquery.balance_currency) AS balance_currency,
                   SUM(subquery.balance_operation) AS balance_operation,
                   SUM(subquery.balance_current) AS balance_current,
                   SUM(subquery.adjustment) AS adjustment,
                   COUNT(subquery.aml_id) AS aml_count
              FROM (
                -- Get moves that have at least one partial at a certain date and are not fully paid at that date
                SELECT
                       account_move_line.currency_id AS grouping_key,
                       ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) AS balance_operation,
                       ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) AS balance_currency,
                       ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate AS balance_current,
                       (
                          -- adjustment is computed as: balance_current - balance_operation
                          ROUND( account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate
                          - ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places)
                       ) AS adjustment,
                       account_move_line.currency_id AS currency_id,
                       account_move_line.id AS aml_id
                  FROM "account_move_line_in_currency_2" AS "account_move_line",
                       account_account AS account,
                       res_currency AS aml_currency,
                       res_currency AS aml_comp_currency,
                       custom_currency_table,
                       -- Get for each move line the amount residual and amount_residual currency
                       -- both for matched "debit" and matched "credit" the same way as account.move.line
                       -- '_compute_amount_residual()' method does
                       -- (using LATERAL greatly reduce the number of lines for which we have to compute it)
                       LATERAL (
                               -- Get sum of matched "debit" amount and amount in currency for related move line at date
                               SELECT COALESCE(SUM(part.amount), 0.0) AS amount_debit,
                                      ROUND(
                                          SUM(part.debit_amount_currency),
                                          curr.decimal_places
                                      ) AS amount_debit_currency,
                                      0.0 AS amount_credit,
                                      0.0 AS amount_credit_currency,
                                      account_move_line.currency_id AS currency_id,
                                      account_move_line.id AS aml_id
                                 FROM account_partial_reconcile part
                                 JOIN res_currency curr ON curr.id = part.debit_currency_id
                                WHERE account_move_line.id = part.debit_move_id
                                  AND part.max_date <= '2023-12-31'::date
                             GROUP BY aml_id,
                                      curr.decimal_places
                           UNION
                               -- Get sum of matched "credit" amount and amount in currency for related move line at date
                               SELECT 0.0 AS amount_debit,
                                      0.0 AS amount_debit_currency,
                                      COALESCE(SUM(part.amount), 0.0) AS amount_credit,
                                      ROUND(
                                          SUM(part.credit_amount_currency),
                                          curr.decimal_places
                                      ) AS amount_credit_currency,
                                      account_move_line.currency_id AS currency_id,
                                      account_move_line.id AS aml_id
                                 FROM account_partial_reconcile part
                                 JOIN res_currency curr ON curr.id = part.credit_currency_id
                                WHERE account_move_line.id = part.credit_move_id
                                  AND part.max_date <= '2023-12-31'::date
                             GROUP BY aml_id,
                                      curr.decimal_places
                            ) AS ara
                 WHERE ((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" in (10))) AND ("account_move_line"."date" <= '2023-12-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) AND (("account_move_line"."journal_id" IS NULL  OR ("account_move_line"."journal_id" in (SELECT "account_journal".id FROM "account_journal" WHERE 
                        NOT EXISTS (
                            SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids"
                            WHERE "account_journal__user_ids"."journal_id" = "account_journal".id
                        )
                    ))) OR FALSE))
                   AND account_move_line.account_id = account.id
                   AND account_move_line.currency_id = aml_currency.id
                   AND account_move_line.company_currency_id = aml_comp_currency.id
                   AND account_move_line.currency_id = custom_currency_table.currency_id
                   AND account.account_type NOT IN ('income', 'income_other', 'expense', 'expense_depreciation', 'expense_direct_cost', 'off_balance')
                   AND (
                        account.currency_id != account_move_line.company_currency_id
                        OR (
                            account.account_type IN ('asset_receivable', 'liability_payable')
                            AND (account_move_line.currency_id != account_move_line.company_currency_id)
                        )
                   )
                   AND NOT EXISTS (
                        SELECT 1
                          FROM account_account_exclude_res_currency_provision
                         WHERE account_account_id = account_move_line.account_id
                           AND res_currency_id = account_move_line.currency_id
                   )
                   AND (
            NOT EXISTS (
                SELECT 1
                  FROM account_partial_reconcile part_exch
                 WHERE part_exch.exchange_move_id = account_move_line.move_id
                   AND part_exch.max_date <= '2023-12-31'::date
            )
        )
              GROUP BY account_move_line.id, aml_comp_currency.decimal_places,  aml_currency.decimal_places, custom_currency_table.rate
                HAVING ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) != 0
                    OR ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) != 0.0
                UNION
                -- Moves that don't have a payment yet at a certain date
                SELECT
                       account_move_line.currency_id AS grouping_key,
                       account_move_line.balance AS balance_operation,
                       account_move_line.amount_currency AS balance_currency,
                       account_move_line.amount_currency / custom_currency_table.rate AS balance_current,
                       account_move_line.amount_currency / custom_currency_table.rate - account_move_line.balance AS adjustment,
                       account_move_line.currency_id AS currency_id,
                       account_move_line.id AS aml_id
                  FROM "account_move_line_in_currency_2" AS "account_move_line"
                  JOIN account_account account ON account_move_line.account_id = account.id
                  JOIN custom_currency_table ON custom_currency_table.currency_id = account_move_line.currency_id
                 WHERE ((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" in (10))) AND ("account_move_line"."date" <= '2023-12-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) AND (("account_move_line"."journal_id" IS NULL  OR ("account_move_line"."journal_id" in (SELECT "account_journal".id FROM "account_journal" WHERE 
                        NOT EXISTS (
                            SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids"
                            WHERE "account_journal__user_ids"."journal_id" = "account_journal".id
 ...<message too long, truncated>

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2028, in __call__
    response = request._serve_db()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1616, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1643, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1847, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_http.py", line 237, in _dispatch
    response = super()._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
    result = endpoint(**request.params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 700, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 42, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 468, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 453, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3799, in get_report_informations
    lines = self._get_lines(options, all_column_groups_expression_totals)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1918, in _get_lines
    lines = self._fully_unfold_lines_if_needed(lines, options)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1947, in _fully_unfold_lines_if_needed
    to_insert = self._expand_unfoldable_line(line_dict['expand_function'], line_dict['id'], groupby, options, progress, 0,
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4038, in _expand_unfoldable_line
    expansion_result = expand_function(line_dict_id, groupby, options, progress, offset, unfold_all_batch_data=unfold_all_batch_data)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4149, in _report_expand_unfoldable_line_with_groupby
    rslt_lines = line._expand_groupby(line_dict_id, groupby, options, offset=offset, limit=limit_to_load, load_one_more=bool(limit_to_load), unfold_all_batch_data=unfold_all_batch_data)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5075, in _expand_groupby
    all_column_groups_expression_totals = self.report_id._compute_expression_totals_for_each_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2213, in _compute_expression_totals_for_each_column_group
    current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2367, in _compute_expression_totals_for_single_column_group
    formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2712, in _compute_formula_batch
    return getattr(self, engine_function_name)(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3156, in _compute_formula_batch_with_engine_custom
    rslt[(formula, expressions)] = custom_engine_function(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 152, in _report_custom_engine_multi_currency_revaluation_to_adjust
    return self._multi_currency_revaluation_get_custom_lines(options, 'to_adjust', current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 349, in _multi_currency_revaluation_get_custom_lines
    self._cr.execute(full_query, params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 321, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.GroupingError: column "account_move_line.currency_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 19:                        account_move_line.currency_id AS grou...
                                ^

bad query: 
            WITH custom_currency_table(currency_id, rate) AS ((VALUES (46, 1.0), (1, 1.0), (172, 1.0), (156, 1.0), (170, 1.0), (2, 1.0), (171, 1.0), (168, 1.0), (47, 1.0)))
            -- Final select that gets the following lines:
            -- (where there is a change in the rates of currency between the creation of the move and the full payments)
            -- - Moves that don't have a payment yet at a certain date
            -- - Moves that have a partial but are not fully paid at a certain date
            SELECT
                   subquery.grouping_key,
                   ARRAY_AGG(DISTINCT(subquery.currency_id)) AS currency_id,
                   SUM(subquery.balance_currency) AS balance_currency,
                   SUM(subquery.balance_operation) AS balance_operation,
                   SUM(subquery.balance_current) AS balance_current,
                   SUM(subquery.adjustment) AS adjustment,
                   COUNT(subquery.aml_id) AS aml_count
              FROM (
                -- Get moves that have at least one partial at a certain date and are not fully paid at that date
                SELECT
                       account_move_line.currency_id AS grouping_key,
                       ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) AS balance_operation,
                       ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) AS balance_currency,
                       ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate AS balance_current,
                       (
                          -- adjustment is computed as: balance_current - balance_operation
                          ROUND( account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate
                          - ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places)
                       ) AS adjustment,
                       account_move_line.currency_id AS currency_id,
                       account_move_line.id AS aml_id
                  FROM "account_move_line_in_currency_2" AS "account_move_line",
                       account_account AS account,
                       res_currency AS aml_currency,
                       res_currency AS aml_comp_currency,
                       custom_currency_table,
                       -- Get for each move line the amount residual and amount_residual currency
                       -- both for matched "debit" and matched "credit" the same way as account.move.line
                       -- '_compute_amount_residual()' method does
                       -- (using LATERAL greatly reduce the number of lines for which we have to compute it)
                       LATERAL (
                               -- Get sum of matched "debit" amount and amount in currency for related move line at date
                               SELECT COALESCE(SUM(part.amount), 0.0) AS amount_debit,
                                      ROUND(
                                          SUM(part.debit_amount_currency),
                                          curr.decimal_places
                                      ) AS amount_debit_currency,
                                      0.0 AS amount_credit,
                                      0.0 AS amount_credit_currency,
                                      account_move_line.currency_id AS currency_id,
                                      account_move_line.id AS aml_id
                                 FROM account_partial_reconcile part
                                 JOIN res_currency curr ON curr.id = part.debit_currency_id
                                WHERE account_move_line.id = part.debit_move_id
                                  AND part.max_date <= '2024-05-31'::date
                             GROUP BY aml_id,
                                      curr.decimal_places
                           UNION
                               -- Get sum of matched "credit" amount and amount in currency for related move line at date
                               SELECT 0.0 AS amount_debit,
                                      0.0 AS amount_debit_currency,
                                      COALESCE(SUM(part.amount), 0.0) AS amount_credit,
                                      ROUND(
                                          SUM(part.credit_amount_currency),
                                          curr.decimal_places
                                      ) AS amount_credit_currency,
                                      account_move_line.currency_id AS currency_id,
                                      account_move_line.id AS aml_id
                                 FROM account_partial_reconcile part
                                 JOIN res_currency curr ON curr.id = part.credit_currency_id
                                WHERE account_move_line.id = part.credit_move_id
                                  AND part.max_date <= '2024-05-31'::date
                             GROUP BY aml_id,
                                      curr.decimal_places
                            ) AS ara
                 WHERE ((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" in (10))) AND ("account_move_line"."date" <= '2024-05-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) AND (("account_move_line"."journal_id" IS NULL  OR ("account_move_line"."journal_id" in (SELECT "account_journal".id FROM "account_journal" WHERE 
                        NOT EXISTS (
                            SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids"
                            WHERE "account_journal__user_ids"."journal_id" = "account_journal".id
                        )
                    ))) OR FALSE))
                   AND account_move_line.account_id = account.id
                   AND account_move_line.currency_id = aml_currency.id
                   AND account_move_line.company_currency_id = aml_comp_currency.id
                   AND account_move_line.currency_id = custom_currency_table.currency_id
                   AND account.account_type NOT IN ('income', 'income_other', 'expense', 'expense_depreciation', 'expense_direct_cost', 'off_balance')
                   AND (
                        account.currency_id != account_move_line.company_currency_id
                        OR (
                            account.account_type IN ('asset_receivable', 'liability_payable')
                            AND (account_move_line.currency_id != account_move_line.company_currency_id)
                        )
                   )
                   AND NOT EXISTS (
                        SELECT 1
                          FROM account_account_exclude_res_currency_provision
                         WHERE account_account_id = account_move_line.account_id
                           AND res_currency_id = account_move_line.currency_id
                   )
                   AND (
            NOT EXISTS (
                SELECT 1
                  FROM account_partial_reconcile part_exch
                 WHERE part_exch.exchange_move_id = account_move_line.move_id
                   AND part_exch.max_date <= '2024-05-31'::date
            )
        )
              GROUP BY account_move_line.id, aml_comp_currency.decimal_places,  aml_currency.decimal_places, custom_currency_table.rate
                HAVING ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) != 0
                    OR ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) != 0.0
                UNION
                -- Moves that don't have a payment yet at a certain date
                SELECT
                       account_move_line.currency_id AS grouping_key,
                       account_move_line.balance AS balance_operation,
                       account_move_line.amount_currency AS balance_currency,
                       account_move_line.amount_currency / custom_currency_table.rate AS balance_current,
                       account_move_line.amount_currency / custom_currency_table.rate - account_move_line.balance AS adjustment,
                       account_move_line.currency_id AS currency_id,
                       account_move_line.id AS aml_id
                  FROM "account_move_line_in_currency_2" AS "account_move_line"
                  JOIN account_account account ON account_move_line.account_id = account.id
                  JOIN custom_currency_table ON custom_currency_table.currency_id = account_move_line.currency_id
                 WHERE ((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" in (10))) AND ("account_move_line"."date" <= '2024-05-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) AND (("account_move_line"."journal_id" IS NULL  OR ("account_move_line"."journal_id" in (SELECT "account_journal".id FROM "account_journal" WHERE 
                        NOT EXISTS (
                            SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids"
                            WHERE "account_journal__user_ids"."journal_id" = "account_journal".id
 ...<message too long, truncated>

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2028, in __call__
    response = request._serve_db()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1616, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1643, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1847, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_http.py", line 237, in _dispatch
    response = super()._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
    result = endpoint(**request.params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 700, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 42, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 468, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 453, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3799, in get_report_informations
    lines = self._get_lines(options, all_column_groups_expression_totals)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1918, in _get_lines
    lines = self._fully_unfold_lines_if_needed(lines, options)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1947, in _fully_unfold_lines_if_needed
    to_insert = self._expand_unfoldable_line(line_dict['expand_function'], line_dict['id'], groupby, options, progress, 0,
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4038, in _expand_unfoldable_line
    expansion_result = expand_function(line_dict_id, groupby, options, progress, offset, unfold_all_batch_data=unfold_all_batch_data)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4149, in _report_expand_unfoldable_line_with_groupby
    rslt_lines = line._expand_groupby(line_dict_id, groupby, options, offset=offset, limit=limit_to_load, load_one_more=bool(limit_to_load), unfold_all_batch_data=unfold_all_batch_data)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5075, in _expand_groupby
    all_column_groups_expression_totals = self.report_id._compute_expression_totals_for_each_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2213, in _compute_expression_totals_for_each_column_group
    current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2367, in _compute_expression_totals_for_single_column_group
    formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2712, in _compute_formula_batch
    return getattr(self, engine_function_name)(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3156, in _compute_formula_batch_with_engine_custom
    rslt[(formula, expressions)] = custom_engine_function(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 152, in _report_custom_engine_multi_currency_revaluation_to_adjust
    return self._multi_currency_revaluation_get_custom_lines(options, 'to_adjust', current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 349, in _multi_currency_revaluation_get_custom_lines
    self._cr.execute(full_query, params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 321, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.GroupingError: column "account_move_line.currency_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 19:                        account_move_line.currency_id AS grou...
                                ^

bad query: 
            WITH custom_currency_table(currency_id, rate) AS ((VALUES (46, 1.0), (1, 1.0), (172, 1.0), (156, 1.0), (170, 1.0), (2, 1.0), (171, 1.0), (168, 1.0), (47, 1.0)))
            -- Final select that gets the following lines:
            -- (where there is a change in the rates of currency between the creation of the move and the full payments)
            -- - Moves that don't have a payment yet at a certain date
            -- - Moves that have a partial but are not fully paid at a certain date
            SELECT
                   subquery.grouping_key,
                   ARRAY_AGG(DISTINCT(subquery.currency_id)) AS currency_id,
                   SUM(subquery.balance_currency) AS balance_currency,
                   SUM(subquery.balance_operation) AS balance_operation,
                   SUM(subquery.balance_current) AS balance_current,
                   SUM(subquery.adjustment) AS adjustment,
                   COUNT(subquery.aml_id) AS aml_count
              FROM (
                -- Get moves that have at least one partial at a certain date and are not fully paid at that date
                SELECT
                       account_move_line.currency_id AS grouping_key,
                       ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) AS balance_operation,
                       ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) AS balance_currency,
                       ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate AS balance_current,
                       (
                          -- adjustment is computed as: balance_current - balance_operation
                          ROUND( account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate
                          - ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places)
                       ) AS adjustment,
                       account_move_line.currency_id AS currency_id,
                       account_move_line.id AS aml_id
                  FROM "account_move_line_in_currency_2" AS "account_move_line",
                       account_account AS account,
                       res_currency AS aml_currency,
                       res_currency AS aml_comp_currency,
                       custom_currency_table,
                       -- Get for each move line the amount residual and amount_residual currency
                       -- both for matched "debit" and matched "credit" the same way as account.move.line
                       -- '_compute_amount_residual()' method does
                       -- (using LATERAL greatly reduce the number of lines for which we have to compute it)
                       LATERAL (
                               -- Get sum of matched "debit" amount and amount in currency for related move line at date
                               SELECT COALESCE(SUM(part.amount), 0.0) AS amount_debit,
                                      ROUND(
                                          SUM(part.debit_amount_currency),
                                          curr.decimal_places
                                      ) AS amount_debit_currency,
                                      0.0 AS amount_credit,
                                      0.0 AS amount_credit_currency,
                                      account_move_line.currency_id AS currency_id,
                                      account_move_line.id AS aml_id
                                 FROM account_partial_reconcile part
                                 JOIN res_currency curr ON curr.id = part.debit_currency_id
                                WHERE account_move_line.id = part.debit_move_id
                                  AND part.max_date <= '2024-03-31'::date
                             GROUP BY aml_id,
                                      curr.decimal_places
                           UNION
                               -- Get sum of matched "credit" amount and amount in currency for related move line at date
                               SELECT 0.0 AS amount_debit,
                                      0.0 AS amount_debit_currency,
                                      COALESCE(SUM(part.amount), 0.0) AS amount_credit,
                                      ROUND(
                                          SUM(part.credit_amount_currency),
                                          curr.decimal_places
                                      ) AS amount_credit_currency,
                                      account_move_line.currency_id AS currency_id,
                                      account_move_line.id AS aml_id
                                 FROM account_partial_reconcile part
                                 JOIN res_currency curr ON curr.id = part.credit_currency_id
                                WHERE account_move_line.id = part.credit_move_id
                                  AND part.max_date <= '2024-03-31'::date
                             GROUP BY aml_id,
                                      curr.decimal_places
                            ) AS ara
                 WHERE ((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" in (10))) AND ("account_move_line"."date" <= '2024-03-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) AND (("account_move_line"."journal_id" IS NULL  OR ("account_move_line"."journal_id" in (SELECT "account_journal".id FROM "account_journal" WHERE 
                        NOT EXISTS (
                            SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids"
                            WHERE "account_journal__user_ids"."journal_id" = "account_journal".id
                        )
                    ))) OR FALSE))
                   AND account_move_line.account_id = account.id
                   AND account_move_line.currency_id = aml_currency.id
                   AND account_move_line.company_currency_id = aml_comp_currency.id
                   AND account_move_line.currency_id = custom_currency_table.currency_id
                   AND account.account_type NOT IN ('income', 'income_other', 'expense', 'expense_depreciation', 'expense_direct_cost', 'off_balance')
                   AND (
                        account.currency_id != account_move_line.company_currency_id
                        OR (
                            account.account_type IN ('asset_receivable', 'liability_payable')
                            AND (account_move_line.currency_id != account_move_line.company_currency_id)
                        )
                   )
                   AND NOT EXISTS (
                        SELECT 1
                          FROM account_account_exclude_res_currency_provision
                         WHERE account_account_id = account_move_line.account_id
                           AND res_currency_id = account_move_line.currency_id
                   )
                   AND (
            NOT EXISTS (
                SELECT 1
                  FROM account_partial_reconcile part_exch
                 WHERE part_exch.exchange_move_id = account_move_line.move_id
                   AND part_exch.max_date <= '2024-03-31'::date
            )
        )
              GROUP BY account_move_line.id, aml_comp_currency.decimal_places,  aml_currency.decimal_places, custom_currency_table.rate
                HAVING ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) != 0
                    OR ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) != 0.0
                UNION
                -- Moves that don't have a payment yet at a certain date
                SELECT
                       account_move_line.currency_id AS grouping_key,
                       account_move_line.balance AS balance_operation,
                       account_move_line.amount_currency AS balance_currency,
                       account_move_line.amount_currency / custom_currency_table.rate AS balance_current,
                       account_move_line.amount_currency / custom_currency_table.rate - account_move_line.balance AS adjustment,
                       account_move_line.currency_id AS currency_id,
                       account_move_line.id AS aml_id
                  FROM "account_move_line_in_currency_2" AS "account_move_line"
                  JOIN account_account account ON account_move_line.account_id = account.id
                  JOIN custom_currency_table ON custom_currency_table.currency_id = account_move_line.currency_id
                 WHERE ((((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" in (10))) AND ("account_move_line"."date" <= '2024-03-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) AND (("account_move_line"."journal_id" IS NULL  OR ("account_move_line"."journal_id" in (SELECT "account_journal".id FROM "account_journal" WHERE 
                        NOT EXISTS (
                            SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids"
                            WHERE "account_journal__user_ids"."journal_id" = "account_journal".id
 ...<message too long, truncated>

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2028, in __call__
    response = request._serve_db()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1616, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1643, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1847, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_http.py", line 237, in _dispatch
    response = super()._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
    result = endpoint(**request.params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 700, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 42, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 468, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 453, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3799, in get_report_informations
    lines = self._get_lines(options, all_column_groups_expression_totals)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1918, in _get_lines
    lines = self._fully_unfold_lines_if_needed(lines, options)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1947, in _fully_unfold_lines_if_needed
    to_insert = self._expand_unfoldable_line(line_dict['expand_function'], line_dict['id'], groupby, options, progress, 0,
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4038, in _expand_unfoldable_line
    expansion_result = expand_function(line_dict_id, groupby, options, progress, offset, unfold_all_batch_data=unfold_all_batch_data)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4149, in _report_expand_unfoldable_line_with_groupby
    rslt_lines = line._expand_groupby(line_dict_id, groupby, options, offset=offset, limit=limit_to_load, load_one_more=bool(limit_to_load), unfold_all_batch_data=unfold_all_batch_data)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5075, in _expand_groupby
    all_column_groups_expression_totals = self.report_id._compute_expression_totals_for_each_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2213, in _compute_expression_totals_for_each_column_group
    current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2367, in _compute_expression_totals_for_single_column_group
    formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2712, in _compute_formula_batch
    return getattr(self, engine_function_name)(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3156, in _compute_formula_batch_with_engine_custom
    rslt[(formula, expressions)] = custom_engine_function(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 152, in _report_custom_engine_multi_currency_revaluation_to_adjust
    return self._multi_currency_revaluation_get_custom_lines(options, 'to_adjust', current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 349, in _multi_currency_revaluation_get_custom_lines
    self._cr.execute(full_query, params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 321, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.GroupingError: column "account_move_line.currency_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 19:                        account_move_line.currency_id AS grou...
                                ^