TIP: You can type at any time to perform a new search.
Stock Move Line Qty Picked
stock_move_line_qty_picked · OCA/stock-logistics-workflow
Security findings
Migration considerations
- Raw `cr.execute()` INSERT/UPDATE/DELETE bypasses the ORM (no compute/constrains/tracking/mail): `UPDATE stock_move_line SET qty_picked = CASE WHEN picked OR state = 'done' THEN quantity ELSE 0 END WHERE qty_picked IS NULL OR (qty_picked = 0 AND (picked OR state = 'done') AND quantity != 0)` - 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 stock_move_line SET picked = TRUE WHERE qty_picked > 0 AND NOT picked AND state NOT IN ('done', 'cancel'); UPDATE stock_move m SET picked = TRUE WHERE NOT m.picked AND m.state NOT IN ('done', 'cancel') AND EXISTS (SELECT 1 FROM stock_move_line ml WHERE ml.move_id = m.id AND ml.picked)` - 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/stock-logistics-workflow · module folder · Try on Runboat
- Module version
- 1.4.0
- Category
- Inventory
- Folder size
- 0.05 MB
- License
- AGPL-3
- Application
- No
- Auto-installable
- No
- Website
- https://github.com/OCA/stock-logistics-workflow
- Last tracking update
- 2026-10-03 23:56:57
- Authors
- Camptocamp, Odoo Community Association (OCA), BCIM
- Maintainers
- Camptocamp, Odoo Community Association (OCA), BCIM
- Committers
- Simone Orsi, Jacques-Etienne Baudoux, Carlos Dauden, Akim Juillerat, Sébastien Alix, LauraCForgeFlow, Weblate, OCA-git-bot, oca-ci
- Odoo dependencies
- Python dependencies
- None
- System dependencies
- None
- Required by
- barcode_stock, mrp_stock_move_line_qty_picked, shopfloor, stock_location_fill_state_qty_picked, stock_storage_type_move_line_qty_picked
- Description
This module adds a `qty_picked` field on `stock.move.line` to allow scanning different quantities without having to update the `quantity` field, what would modify existing reservations. It is meant to restore the behaviour we had in previous versions with `qty_done` field, but using another name to avoid clashing with the field defined in Odoo Enterprise's Stock barcode module.
Code Analysis
Views touched (4)
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
view_move_line_form |
stock.move.line.form | stock.move.line | form | Inherits stock.view_move_line_form |
view_picking_form |
stock.picking.form | stock.picking | form | Inherits stock.view_picking_form |
view_stock_move_line_detailed_operation_tree |
stock.move.line.operations.list | stock.move.line | list | Inherits stock.view_stock_move_line_detailed_operation_tree |
view_stock_move_line_operation_tree |
stock.move.line.operations.tree | stock.move.line | tree | Inherits stock.view_stock_move_line_operation_tree |
HTTP endpoints (0)
No HTTP endpoints found for this module.
Models touched (2)
New fields (1)
-
qty_pickedFloatcompute='_compute_qty_picked'digits='Product Unit of Measure'
No public methods.
New fields (2)
-
pickedBooleancopy=Falseinverse='_inverse_picked' -
qty_pickedFloatcopy=Falsedigits='Product Unit of Measure'inverse='_inverse_qty_picked'
No public methods.
Loading…
- Status
- Open migration PR — not merged yet for this version
- CI status
- green — ready to merge
- Open since
- 12 days ago
- Last activity
- 0 days ago
- Repository
- OCA/stock-logistics-workflow
- Pull request
- [19.0][MIG] stock_move_line_qty_picked: Migration to 19.0 (#2459)