TIP: You can type at any time to perform a new search.
Stock Move Actual Date
stock_move_actual_date · OCA/stock-logistics-workflow
Security findings
Migration considerations
- Raw `cr.execute()` INSERT/UPDATE/DELETE bypasses the ORM (no compute/constrains/tracking/mail): `ALTER TABLE stock_move ADD COLUMN actual_date DATE; UPDATE stock_move SET actual_date = DATE(date);` - 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): `ALTER TABLE stock_move_line ADD COLUMN actual_date DATE; UPDATE stock_move_line SET actual_date = DATE(date);` - 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.1.0
- Category
- Stock
- Folder size
- 0.08 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
- Odoo Community Association (OCA), Quartile
- Maintainers
- Odoo Community Association (OCA), Quartile
- Committers
- Aungkokolin1997, Weblate, OCA-git-bot, oca-ci, yostashiro
- Odoo dependencies
- Python dependencies
- None
- System dependencies
- None
- Required by
- mrp_stock_move_actual_date
- Description
This module adds an Actual Date field to the stock picking, stock scrap, stock move, and stock move line models. This field allows users to record the actual date on which a stock transfer or stock scrap took place, in case the transaction in Odoo is processed after the fact. It also adds an Actual Date field to the Stock Valuation Layer model, enabling reporting based on this field. This field is computed and stored according to the following logic: - If a posted journal entry exists, its date is used. - If there is no journal entry, the stock move's actual date is used - Otherwise, convert create_date (datetime) of the stock.valuation.layer record to date, with consideration to user's timezone. It also provides stock quantity history reporting based on the actual date.
Code Analysis
Views touched (15)
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
stock_move_line_view_search |
stock.move.line.search | stock.move.line | search | Inherits stock.stock_move_line_view_search |
stock_scrap_form_view |
stock.scrap.form | stock.scrap | form | Inherits stock.stock_scrap_form_view |
stock_scrap_form_view2 |
stock.scrap.form2 | stock.scrap | form | Inherits stock.stock_scrap_form_view2 |
stock_scrap_search_view |
stock.scrap.search | stock.scrap | search | Inherits stock.stock_scrap_search_view |
stock_scrap_tree_view |
stock.scrap.tree | stock.scrap | tree | Inherits stock.stock_scrap_tree_view |
stock_valuation_layer_form |
stock.valuation.layer.form | stock.valuation.layer | form | Inherits stock_account.stock_valuation_layer_form |
stock_valuation_layer_search |
stock.valuation.layer.search | stock.valuation.layer | search | Inherits stock_account.view_inventory_valuation_search |
stock_valuation_layer_tree |
stock.valuation.layer.tree | stock.valuation.layer | tree | Inherits stock_account.stock_valuation_layer_tree |
view_move_line_tree |
stock.move.line.tree | stock.move.line | tree | Inherits stock.view_move_line_tree |
view_move_search |
stock.move.search | stock.move | search | Inherits stock.view_move_search |
view_move_tree_actual_date_inherit |
stock.move.tree | stock.move | tree | Inherits stock.view_move_tree |
view_picking_form |
stock.picking.form | stock.picking | form | Inherits stock.view_picking_form |
view_picking_internal_search |
stock.picking.search | stock.picking | search | Inherits stock.view_picking_internal_search |
view_picking_tree |
stock.picking.tree | stock.picking | tree | Inherits stock.vpicktree |
view_stock_quantity_history |
Inventory Report at Date | stock.quantity.history | Inherits stock.view_stock_quantity_history |
HTTP endpoints (0)
No HTTP endpoints found for this module.
Models touched (9)
New fields (0)
No new fields.
Public methods (0)No public methods.
New fields (0)
No new fields.
Public methods (0)No public methods.
New fields (2)
-
actual_dateDatecopy=Falsehelp='If set, the value is propagated to the related journal entries as the date.'tracking=True -
is_editable_actual_dateBooleancompute='_compute_is_editable_actual_date'string='Is Editable'
-
create(self, vals_list)@api.model_create_multi -
write(self, vals)
New fields (2)
-
actual_dateDatecompute='_compute_actual_date'store=True -
actual_date_sourceDatehelp='Technical field to store the actual_date of the source document.'
-
create(self, vals_list)@api.model_create_multi
New fields (1)
-
actual_dateDaterelated='move_id.actual_date'store=True
No public methods.
New fields (0)
No new fields.
Public methods (0)No public methods.
New fields (0)
No new fields.
Public methods (2)-
open_at_actual_date(self) -
open_qty_at_actual_date(self)
New fields (0)
No new fields.
Public methods (1)-
do_scrap(self)
New fields (1)
-
actual_dateDatecompute='_compute_actual_date'help="The actual date is determined as follows:\n- If a posted journal entry exists, its date is used.\n- If there is no journal entry, the stock move's actual date is used.\n- Otherwise, the record's creation date (timezone-aware) is used."store=True
No public methods.
Loading…
Loading…
- Status
- Open migration PR — not merged yet for this version
- CI status
- checks failing
- Open since
- 136 days ago
- Last activity
- 74 days ago
- Repository
- OCA/stock-logistics-workflow
- Pull request
- [19.0][MIG] stock_move_actual_date: Migration to 19.0 and rename to stock_date_done (#2346)