Description: Odoo By Adhoc 16
Commit: plugberry-payment:49ff3500  
Subject: [IMP] payment_mercado_pago_ux: new module to extend mrcado pago functionalities
Author: augusto-weiss
Committer: augusto-weiss
Commit: ingadhoc-uruguay:6ba14c48  
Subject: [I18N] Update translation terms from Transifex adhoc-odoo-16-0
Author: ADHOC - Bot
Committer: ADHOC - Bot
Commit: ingadhoc-enterprise-extensions:5372a84e  
Subject: [FIX] sale_subscription_loyalty_ux: correct name to the module
Author: Lara
Committer: Lara
Commit: ingadhoc-odoo-argentina-ee:5027c49c  
Subject: [ADD] l10n_ar_edi_ux: Adapting the zeep library
Author: Maximiliano Mezzavilla
Committer: Maximiliano Mezzavilla
Commit: ingadhoc-odoo-argentina:acd4f45f  
Subject: [FIX] l10n_ar_bank: Agregamos los datos del banco BANCO BMA S.A.U.
Author: Maximiliano Mezzavilla
Committer: Maximiliano Mezzavilla
Commit: ingadhoc-account-invoicing:403390a5  
Subject: [FIX] account_background_post: set background_post to false when copy invoice
Author: Camila
Committer: Camila
Commit: ingadhoc-sale:058f6f8b  
Subject: [IMP] sale_gathering: gatherinng orders will not be locked
Author: docker-odoo
Committer: docker-odoo
Commit: plugberry-pagos360:d97b138f  
Subject: Merge pull request #23 from plugberry/16.0-t-39710-maq
Author: augusto-weiss
Committer: GitHub
Commit: ingadhoc-stock:4c06c041  
Subject: [FIX]stock_ux: cancel remains in action_cancel
Author: mav-adhoc
Committer: mav-adhoc
Commit: ingadhoc-purchase:280e423f  
Subject: [IMP]purchase_stock_ux: deprecated cancel remain qty button
Author: mav-adhoc
Committer: mav-adhoc
Commit: ingadhoc-third-party-apps:f001c8b7  
Subject: [REF] ks_dashboard_ninja: update to latest available version
Author: jok-adhoc
Committer: Juan José Scarafía
Commit: ingadhoc-miscellaneous:d05cd8e6  
Subject: [FIX] portal_timesheet: add new record rules
Author: Celina Devigili
Committer: Celina Devigili
Commit: ingadhoc-argentina-sale:e3eb4288  
Subject: [FIX] l10n_ar_sale: error al hacer vista previa de pedido de venta
Author: Pablo Montenegro
Committer: Pablo Montenegro
Commit: ingadhoc-ingadhoc-odoo-saas:6d0cad0d  
Subject: [FIX] saas_provider: regex warning
Author: Juan José Scarafia
Committer: Juan José Scarafía
Commit: ingadhoc-ingadhoc-odoo-saas-adhoc2:2b2727f4  
Subject: [IMP] saas_client_adhoc: new cron to notify partner about news not readed [IMP] saas_client_adhoc: add new method for update partner notification
Author: Matias Peralta
Committer: Juan José Scarafía
Commit: ingadhoc-account-financial-tools:67644ba4  
Subject: [ADD] stock_account_ux: Add stock_account_ux module
Author: Rocío Vega
Committer: Rocío Vega
Commit: ingadhoc-account-payment:58cd91e4  
Subject: [FIX] _group: fix default_company sent to pay lines
Author: Juan José Scarafia
Committer: Juan José Scarafia
Commit: ingadhoc-product:86f12964  
Subject: [FIX] _management_group: usage with ecommerce + sale quoation
Author: Juan José Scarafia
Committer: Juan José Scarafia
Commit: ingadhoc-ingadhoc-demo:133bc57b  
Subject: [FIX]base_demo:add values to demo provider's fields
Author: Alexis
Committer: Alexis
Commit: ingadhoc-website:57070794  
Subject: [ADD] website_sale_three_discounts: add new module
Author: docker-odoo
Committer: docker-odoo
Commit: ingadhoc-project:4183dd51  
Subject: [ADD] project_ux: tasks stages page in project form
Author: mav-adhoc
Committer: mav-adhoc
Commit: ingadhoc-multi-company:1d200174  
Subject: [FIX] account_accountant_ux: allow to modify draft invoice company to a foreign company
Author: Rocío Vega
Committer: Rocío Vega
Commit: ingadhoc-aeroo_reports:363afaec  
Subject: [FIX] aeroo_report: get_lang from environment
Author: augusto-weiss
Committer: augusto-weiss
Commit: ingadhoc-partner:318548ec  
Subject: [FIX] partner_state: users perm
Author: mav-adhoc
Committer: mav-adhoc
Commit: plugberry-mercadopago:c9547149  
Subject: [IMP] Fix Refund method
Author: Martin Quinteros
Committer: Martin Quinteros
Commit: ingadhoc-delivery:231bd588  
Subject: [IMP]delivery_andreani: method to add data in obs field
Author: Alexis
Committer: Alexis
Commit: ingadhoc-multi-store:44af7531  
Subject: [FIX] _pay_group_ms: pay choosing custom debt
Author: Juan José Scarafia
Committer: Juan José Scarafia
Commit: ingadhoc-hr:46cb8641  
Subject: [I18N] Update translation terms from Transifex adhoc-odoo-16-0
Author: ADHOC - Bot
Committer: ADHOC - Bot
Commit: adhoc-cicd-odoo-odoo:3a1fe1fd  
Subject: Merge commit 'refs/pull/112460/head' of https://github.com/odoo/odoo into 16.0-7363
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-brand:82336864  
Subject: Translated using Weblate (Portuguese (Brazil))
Author: Rodrigo Macedo
Committer: Weblate
Commit: adhoc-cicd-oca-account-invoicing:0ef712b5  
Subject: Translated using Weblate (Italian)
Author: mymage
Committer: Weblate
Commit: adhoc-cicd-oca-bank-statement-import:54442526  
Subject: Merge commit 'refs/pull/699/head' of https://github.com/oca/bank-statement-import into 16.0-7356
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-odoo-design-themes:4cdab5d3  
Subject: [I18N] Update translation terms from Transifex
Author: Odoo Translation Bot
Committer: Odoo Translation Bot
Commit: adhoc-cicd-oca-crm:dbdad60b  
Subject: Update translation files
Author: Weblate
Committer: Weblate
Commit: adhoc-cicd-oca-e-commerce:36d05dd0  
Subject: Merge commit 'refs/pull/694/head' of https://github.com/oca/e-commerce into 16.0-7418
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-odoo-enterprise:cc57c843  
Subject: Merge commit 'refs/pull/36994/head' of https://github.com/odoo/enterprise into 16.0-7389
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-hr-expense:4e4ed264  
Subject: Translated using Weblate (Italian)
Author: mymage
Committer: Weblate
Commit: adhoc-cicd-oca-stock-logistics-workflow:83007ec1  
Subject: Translated using Weblate (Italian)
Author: mymage
Committer: Weblate
Commit: adhoc-cicd-oca-stock-logistics-warehouse:8f555423  
Subject: Merge commit 'refs/pull/1701/head' of https://github.com/oca/stock-logistics-warehouse into 16.0-7402
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-knowledge:80200664  
Subject: Translated using Weblate (Italian)
Author: mymage
Committer: Weblate
Commit: adhoc-cicd-oca-management-system:789bdaab  
Subject: Merge commit 'refs/pull/571/head' of https://github.com/oca/management-system into 16.0-7398
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-mis-builder:79c9ea34  
Subject: [BOT] post-merge updates
Author: OCA-git-bot
Committer: OCA-git-bot
Commit: adhoc-cicd-oca-manufacture:373b6c62  
Subject: Translated using Weblate (Japanese)
Author: Wang-TKurata
Committer: Weblate
Commit: adhoc-cicd-oca-partner-contact:6c6a70e8  
Subject: Translated using Weblate (Portuguese (Brazil))
Author: Rodrigo Macedo
Committer: Weblate
Commit: adhoc-cicd-oca-product-attribute:753ef1c6  
Subject: Merge commit 'refs/pull/1237/head' of https://github.com/oca/product-attribute into 16.0-7420
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-report-print-send:d1fe5b28  
Subject: Translated using Weblate (Italian)
Author: mymage
Committer: Weblate
Commit: adhoc-cicd-oca-reporting-engine:45a5a018  
Subject: Translated using Weblate (Italian)
Author: mymage
Committer: Weblate
Commit: adhoc-cicd-oca-sale-workflow:1cfcb69d  
Subject: Merge commit 'refs/pull/2683/head' of https://github.com/oca/sale-workflow into 16.0-7476
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-server-backend:6f820988  
Subject: Translated using Weblate (Portuguese (Brazil))
Author: Rodrigo Macedo
Committer: Weblate
Commit: adhoc-cicd-oca-server-auth:d146760e  
Subject: Translated using Weblate (Italian)
Author: Francesco Foresti
Committer: Weblate
Commit: adhoc-cicd-oca-server-tools:e9cfae66  
Subject: Translated using Weblate (Italian)
Author: mymage
Committer: Weblate
Commit: adhoc-cicd-oca-server-ux:99d408c5  
Subject: Update translation files
Author: Weblate
Committer: Weblate
Commit: adhoc-cicd-oca-stock-logistics-barcode:cd4e9df1  
Subject: [BOT] post-merge updates
Author: OCA-git-bot
Committer: OCA-git-bot
Commit: adhoc-cicd-oca-stock-logistics-request:fe81b6be  
Subject: Translated using Weblate (Italian)
Author: mymage
Committer: Weblate
Commit: adhoc-cicd-oca-social:e1a6ac31  
Subject: Merge commit 'refs/pull/1020/head' of https://github.com/oca/social into 16.0-7468
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-stock-logistics-availability:5549c34f  
Subject: Translated using Weblate (Portuguese (Brazil))
Author: Rodrigo Macedo
Committer: Weblate
Commit: adhoc-cicd-oca-account-analytic:a6cfa5f9  
Subject: Merge commit 'refs/pull/511/head' of https://github.com/oca/account-analytic into 16.0-7375
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-website:c270d19f  
Subject: Update translation files
Author: Weblate
Committer: Weblate
Commit: adhoc-cicd-oca-web:64164bed  
Subject: Translated using Weblate (Italian)
Author: mymage
Committer: Weblate
Commit: adhoc-cicd-oca-account-reconcile:30347654  
Subject: Translated using Weblate (Turkish)
Author: Metin GÜLSOY
Committer: Weblate
Commit: adhoc-cicd-oca-purchase-workflow:6790caa3  
Subject: Merge commit 'refs/pull/1814/head' of https://github.com/oca/purchase-workflow into 16.0-7475
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-project:1d29a0f3  
Subject: Translated using Weblate (Portuguese (Brazil))
Author: Rodrigo Macedo
Committer: Weblate
Commit: adhoc-cicd-oca-product-pack:3409f1df  
Subject: Merge commit 'refs/pull/114/head' of https://github.com/oca/product-pack into 16.0-7421
Author: docker-odoo
Committer: docker-odoo
Commit: adhoc-cicd-oca-timesheet:80446c68  
Subject: Update translation files
Author: Weblate
Committer: Weblate
Version: 16.0
Config: Adhoc Conf con tests
Total time: 16m
Date Level Type Message
2024-06-18 13:11:55 INFO runbot Init build environment with config Adhoc Conf con tests
2024-06-18 13:11:55 Starting step base from config Adhoc Conf con tests
2024-06-18 13:11:55 INFO runbot Using Dockerfile Tag odoo:adhoc-odoo-16
2024-06-18 13:12:14 INFO server odoo.modules.loading:303 1 modules loaded in 8.91s, 9027 queries (+9027 extra)
2024-06-18 13:12:27 INFO server odoo.modules.loading:303 14 modules loaded in 6.16s, 5292 queries (+5292 extra)
2024-06-18 13:12:27 Step base finished in 29s
2024-06-18 13:12:27 Starting step all from config Adhoc Conf con tests
2024-06-18 13:12:27 INFO runbot Using Dockerfile Tag odoo:adhoc-odoo-16
2024-06-18 13:12:55 INFO server odoo.modules.loading:303 1 modules loaded in 10.43s, 9027 queries (+9027 extra)
2024-06-18 13:21:38 INFO server odoo.addons.l10n_uy_currency_update.models.res_company:41 Currency Provider configured as BCU for next companies: (UY) Company
2024-06-18 13:22:46 INFO server odoo.addons.l10n_uy_currency_update.models.res_company:41 Currency Provider configured as BCU for next companies: (UY) Company
2024-06-18 13:24:26 INFO server odoo.addons.l10n_uy_currency_update.models.res_company:41 Currency Provider configured as BCU for next companies: (UY) Company
2024-06-18 13:24:26 INFO server odoo.addons.l10n_ar_currency_update.models.res_company:46 Currency Provider configured as AFIP for next companies: (AR) Exento
2024-06-18 13:24:26 INFO server odoo.addons.l10n_uy_currency_update.models.res_company:41 Currency Provider configured as BCU for next companies: (UY) Company
2024-06-18 13:24:26 INFO server odoo.addons.l10n_ar_currency_update.models.res_company:46 Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista
2024-06-18 13:24:32 INFO server odoo.addons.l10n_uy_currency_update.models.res_company:41 Currency Provider configured as BCU for next companies: (UY) Company
2024-06-18 13:24:32 INFO server odoo.addons.l10n_ar_currency_update.models.res_company:46 Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista, (AR) Responsable Inscripto
2024-06-18 13:24:44 INFO server odoo.addons.l10n_ar_edi.models.res_company:216 Setting demo certificate from to OdooCert9 in (AR) Responsable Inscripto company
2024-06-18 13:24:44 INFO server odoo.addons.l10n_ar_edi.models.res_company:216 Setting demo certificate from to OdooCert2 in (AR) Monotributista company
2024-06-18 13:24:44 INFO server odoo.addons.l10n_ar_edi.models.res_company:216 Setting demo certificate from to OdooCert1 in (AR) Exento company
2024-06-18 13:27:04 INFO server odoo.modules.loading:303 609 modules loaded in 843.64s, 386318 queries (+388077 extra)
2024-06-18 13:27:04 INFO server odoo.modules.loading:303 610 modules loaded in 0.96s, 242 queries (+242 extra)
2024-06-18 13:27:10 INFO server odoo.addons.l10n_uy_currency_update.models.res_company:41 Currency Provider configured as BCU for next companies: Muebleria UY
2024-06-18 13:27:10 INFO server odoo.addons.l10n_ar_currency_update.models.res_company:46 Currency Provider configured as AFIP for next companies: (AR) Exento, Muebleria ARG, company_2_data
2024-06-18 13:27:16 INFO server odoo.addons.l10n_uy_currency_update.models.res_company:41 Currency Provider configured as BCU for next companies: Muebleria UY
2024-06-18 13:27:16 INFO server odoo.addons.l10n_ar_currency_update.models.res_company:46 Currency Provider configured as AFIP for next companies: (AR) Exento, Muebleria ARG, company_1_data, company_2_data
2024-06-18 13:27:16 INFO server odoo.addons.l10n_uy_currency_update.models.res_company:41 Currency Provider configured as BCU for next companies: Muebleria UY
2024-06-18 13:27:16 INFO server odoo.addons.l10n_ar_currency_update.models.res_company:46 Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista (Unit Tests), (AR) Responsable Inscripto (Unit Tests), Muebleria ARG, company_2_data
2024-06-18 13:28:03 INFO runbot Getting results for build 57520-16-0
2024-06-18 13:28:03 Step all finished in 15m
2024-06-18 13:28:03 Starting step setup from config Adhoc Conf con tests
2024-06-18 13:28:03 INFO runbot Using Dockerfile Tag odoo:adhoc-odoo-16
2024-06-18 13:28:04 INFO runbot Step setup finished in 0s
2024-06-18 13:28:04 Starting step run from config Adhoc Conf con tests
2024-06-18 13:28:04 INFO runbot Start running build 57520-16-0
2024-06-18 13:28:04 INFO runbot Using Dockerfile Tag odoo:adhoc-odoo-16
2024-06-18 13:28:11 INFO server odoo.modules.loading:303 1 modules loaded in 0.01s, 0 queries (+0 extra)
2024-06-18 13:28:11 INFO server odoo.modules.loading:303 14 modules loaded in 0.10s, 0 queries (+0 extra)
2024-06-18 13:34:03 INFO server odoo.modules.loading:303 1 modules loaded in 0.01s, 0 queries (+0 extra)
2024-06-18 13:34:03 INFO server odoo.modules.loading:303 1 modules loaded in 0.01s, 0 queries (+0 extra)
2024-06-18 13:34:09 INFO server odoo.modules.loading:303 610 modules loaded in 5.50s, 0 queries (+0 extra)
2024-06-18 13:34:09 INFO server odoo.modules.loading:303 610 modules loaded in 5.34s, 0 queries (+0 extra)
2024-06-18 13:45:30 INFO server odoo.modules.loading:303 1 modules loaded in 0.01s, 0 queries (+0 extra)
2024-06-18 13:45:43 INFO server odoo.modules.loading:303 610 modules loaded in 5.46s, 0 queries (+0 extra)
2024-06-18 14:02:48 WARNING server odoo.http:2048 No se ha seleccionado WS AFIP
2024-06-18 14:03:54 WARNING server odoo.http:2048
Por restricciones de seguridad no tienes permiso para acceder a los informes de 'Usuario' (res.users).
Ponte en contacto con tu administrador para pedirle acceso si es necesario
2024-06-18 14:08:12 WARNING server odoo.http:2048 El Diario seleccionado no se puede usar en esta transacción, por favor seleccione uno que no use documentos, ya que estos son solo para Facturas.
2024-06-18 14:08:21 WARNING server odoo.http:2048 El Diario seleccionado no se puede usar en esta transacción, por favor seleccione uno que no use documentos, ya que estos son solo para Facturas.
2024-06-18 14:08:28 WARNING server odoo.http:2048 El Diario seleccionado no se puede usar en esta transacción, por favor seleccione uno que no use documentos, ya que estos son solo para Facturas.
2024-06-18 14:22:21 WARNING server odoo.http:2048 Se requiere la fecha de Facturación / Reembolso para validar este documento.
2024-06-18 19:22:37 ERROR server odoo.sql_db:324
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>
2024-06-18 19:22:37 ERROR server odoo.http:2050
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...
                                ^
2024-06-18 19:23:01 ERROR server odoo.sql_db:324
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>
2024-06-18 19:23:01 ERROR server odoo.http:2050
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...
                                ^
2024-06-18 19:23:09 ERROR server odoo.sql_db:324
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>
2024-06-18 19:23:09 ERROR server odoo.http:2050
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...
                                ^
2024-06-18 19:44:08 ERROR server odoo.sql_db:324
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>
2024-06-18 19:44:08 ERROR server odoo.http:2050
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...
                                ^
2024-06-19 14:49:15 INFO runbot Kill build 57520-16-0