odoomates / odooapps

250 stars 343 forks source link

accounting_pdf_reports, AmbiguousColumn: column reference "account_id" is ambiguous #147

Open akashr355 opened 2 months ago

akashr355 commented 2 months ago

Menu: Accounting -> Reporting -> Partner Reports -> Partner Ledger, V17.0

File "/accounting_pdf_reports/report/report_partner_ledger.py", line 61, in _sum_partner self.env.cr.execute(query, tuple(params)) File "/odoo/odoo/sql_db.py", line 332, in execute res = self._obj.execute(query, params) psycopg2.errors.AmbiguousColumn: column reference "account_id" is ambiguous LINE 6: AND account_id IN (2, 3)

odoo.addons.base.models.ir_qweb.QWebException: Error while render the template AmbiguousColumn: column reference "account_id" is ambiguous LINE 6: AND account_id IN (2, 3) ^

Template: accounting_pdf_reports.report_partnerledger Path: /t/t/t/div/table/t/tbody/tr[1]/td[2]/strong Node: