TIP: You can type at any time to perform a new search.
Account Move Line Sale Info
account_move_line_sale_info · OCA/account-financial-tools
Security findings
Migration considerations
- Raw `cr.execute()` INSERT/UPDATE/DELETE bypasses the ORM (no compute/constrains/tracking/mail): `UPDATE account_move_line aml SET sale_line_id = sm.sale_line_id FROM account_move_line aml2 INNER JOIN stock_move sm ON aml2.stock_move_id = sm.id WHERE aml.id = aml2.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): `UPDATE account_move_line aml SET sale_line_id = sol.id FROM account_move_line aml2 INNER JOIN account_move am ON am.id = aml2.move_id INNER JOIN sale_order_line_invoice_rel rel ON rel.invoice_line_id = aml2.id INNER JOIN sale_order_line sol ON rel.order_line_id = sol.id AND sol.product_id = aml2.product_id WHERE aml.id = aml2.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): `UPDATE account_move_line aml SET sale_order_id = sol.order_id FROM sale_order_line AS sol WHERE aml.sale_line_id = sol.id RETURNING aml.move_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): `UPDATE account_move_line aml SET sale_order_id = so.id FROM sale_order so LEFT JOIN account_move_line aml2 ON aml2.sale_order_id = so.id WHERE aml2.move_id = aml.move_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): `update account_move_line aml set sale_line_id = sol.id FROM account_move_line aml2 INNER JOIN sale_order so ON so.id = aml2.sale_order_id INNER JOIN sale_order_line sol ON so.id = sol.order_id AND sol.product_id = aml2.product_id WHERE aml.id = aml2.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.
- Repository
- OCA/account-financial-tools · module folder · Try on Runboat
- Module version
- 1.0.0
- Category
- Generic
- Folder size
- 0.06 MB
- License
- AGPL-3
- Application
- No
- Auto-installable
- No
- Website
- https://github.com/OCA/account-financial-tools
- Last tracking update
- 2026-08-07 08:42:53
- Authors
- Odoo Community Association (OCA), ForgeFlow S.L.
- Maintainers
- Odoo Community Association (OCA), ForgeFlow S.L.
- Committers
- Weblate, OCA-git-bot, oca-ci, IsabelAForgeFlow
- Odoo dependencies
- Python dependencies
- None
- System dependencies
- None
- Required by
- None
- Description
This module will add the sale order line to journal items. The ultimate goal is to establish the sale order line as one of the key fields to reconcile the Goods Delivered Not Invoiced accrual account.
Code Analysis
Views touched (4)
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
view_account_move_line_filter |
Journal Items | account.move.line | Inherits account.view_account_move_line_filter | |
view_move_form |
account.move.form | account.move | form | Inherits account.view_move_form |
view_move_line_form |
account.move.line.form | account.move.line | form | Inherits account.view_move_line_form |
view_move_line_tree |
account.move.line.tree | account.move.line | tree | Inherits account.view_move_line_tree |
HTTP endpoints (0)
No HTTP endpoints found for this module.
Models touched (4)
New fields (0)
No new fields.
Public methods (0)No public methods.
New fields (2)
-
sale_line_idMany2one → sale.order.linecomodel_name='sale.order.line'copy=Falseindex=Trueondelete='set null'string='Sale Order Line' -
sale_order_idMany2one → sale.ordercomodel_name='sale.order'copy=Falseindex=Trueondelete='set null'related='sale_line_id.order_id'store=Truestring='Sales Order'
No public methods.
New fields (0)
No new fields.
Public methods (0)No public methods.
New fields (0)
No new fields.
Public methods (0)No public methods.
Loading…
Loading…
Loading…
Loading…
Loading…
- Status
- Open migration PR — not merged yet for this version
- CI status
- checks failing
- Open since
- 264 days ago
- Last activity
- 63 days ago
- Repository
- OCA/account-financial-tools
- Pull request
- [19.0][MIG] account_move_line_sale_info (#2201)