我试图将模块从odoo 8迁移到odoo 12,并且在odoo 12环境中尝试安装odoo 8模块时收到此错误。
psycopg2.ProgrammingError: column reference "account_analytic_id" is ambiguous
LINE 18: ..., sub.product_id, sub.partner_id, sub.country_id, sub.accoun...
这是我怀疑错误来自的代码块
class AccountInvoiceReport(models.Model):
_inherit = 'account.invoice.report'
cost_center_id = fields.Many2one(
'account.cost.center',
string='Cost Center',
readonly=True
)
account_analytic_id = fields.Many2one(
'account.analytic.account',
string='Analytic Account',
readonly=True
)
def _select(self):
return super(AccountInvoiceReport, self)._select() + \
", sub.cost_center_id as cost_center_id, " + \
"sub.account_analytic_id as account_analytic_id"
def _sub_select(self):
return super(AccountInvoiceReport, self)._sub_select() + \
", ail.cost_center_id as cost_center_id, " + \
"ail.account_analytic_id as account_analytic_id"
def _group_by(self):
return super(AccountInvoiceReport, self)._group_by() + \
", ail.cost_center_id, " + \
"ail.account_analytic_id"
只需使用删除查询部分account_analytic_id
,因为它已经在account.invoice.report
Odoo 12中。
可以在这里看到
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句