Sale Order Invoice Date

build Migration considerations

• Raw `cr.execute()` INSERT/UPDATE/DELETE bypasses the ORM (no compute/constrains/tracking/mail): `WITH sol AS ( SELECT sol.id AS id, max(move.invoice_date) AS invoice_date FROM sale_order_line_invoice_rel rel INNER JOIN sale_order_line sol ON rel.order_line_id = sol.id INNER JOIN account_move_line aml ON rel.invoice_line_id = aml.id INNER JOIN account_move move ON aml.move_id = move.id WHERE sol.invoice_status = 'invoiced' GROUP BY sol.id ) UPDATE sale_order_line SET invoice_date = sol.invoice_date FROM sol WHERE sale_order_line.id = sol.id` - re-check the table/column names still match after upgrading. migration-raw-sql-write · source
• Raw `cr.execute()` INSERT/UPDATE/DELETE bypasses the ORM (no compute/constrains/tracking/mail): `WITH so AS ( SELECT so.id AS id, max(sol.invoice_date) AS invoice_date FROM sale_order_line sol INNER JOIN sale_order so ON sol.order_id = so.id WHERE so.invoice_status = 'invoiced' AND sol.invoice_date IS NOT NULL GROUP BY so.id ) UPDATE sale_order SET invoice_date = so.invoice_date FROM so WHERE sale_order.id = so.id` - re-check the table/column names still match after upgrading. migration-raw-sql-write · source

Migration review checklist, not a compatibility verdict. No target version is selected: apply version-specific advice only when migrating to that version or later.