Odoo : Get Sales Order, error

[Elise]

Hi,

For the past few days, the node “Get many” Sales Order doesn’t work anymore.
Before, it worked perfectly.

Even if I remove the filters, I have an error.

Here is the error:
“Invalid field sale.report.order_id in leaf (‘order_id’, ‘=’, 453)” while evaluating “\nfor record in self: record[‘x_order_id_sale_report_count’] = self.env[‘sale.report’].search_count([(‘order_id’, ‘=’, record.id)])\n”

Thanks a lot for your help

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[mariana-na]

Hi @Elise ,

What version of n8n are you on and how did you set up n8n?
I’ve tried this on our latest version - v.1.59.4 - and was able to get the records.

Could you make sure you’re using the latest version and then try again?
Additionally, have you made any changes to your workflow, node parameters or Odoo subscription recently?