Stock Valuation Layer Accounting Date
This module adds Accounting Date field in stock.valuation.layer, enabling the report output based on this field.
Accounting Date is computed (and stored in the record) based on the following logic:
- If a journal entry linked to the stock.valuation.layer record, take the date of the journal entry.
- Otherwise, convert create_date (datetime) of the stock.valuation.layer record to date, with consideration to user's timezone.
auto_awesome What this module does
AI-generated from the code · Odoo 16.0Adds an Accounting Date to stock valuation layers, taken from the linked posted journal entry or the record's creation date, and lets you view stock valuation as of that accounting date.
This module adds a new Accounting Date field to stock valuation records (stock.valuation.layer). The date is calculated automatically and stored: if the valuation is linked to a posted journal entry, the journal entry's date is used; otherwise the record's creation date is used, adjusted to the user's timezone.
The new field appears on the stock valuation layer form and list views, right after the creation date, so users can see and sort by it.
A new button, "Valuation as of Accounting Date", is added to the Inventory Report at Date wizard (stock.quantity.history). It opens the stock valuation layer list filtered to records whose Accounting Date is on or before the chosen date, and only for storable products. This gives an alternative view of valuation based on accounting dates rather than the standard inventory date.
During installation, the module creates the database column and fills it for existing records: first from posted journal entries, then from the creation date where no journal entry exists. No other business rules, emails or scheduled jobs are added.
Depends on
Models and fields (2)
- stock.valuation.layer · extends an existing modelaccounting_date
- stock.quantity.history · extends an existing model
Text generated by AI (DeepSeek) from reading the Odoo 16.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 2 confirmed, 7 with no information of 9 versions.
Sources · Odoo 16.0
Confirmed on 2026-11-03 in branch 16.0 of OCA/stock-logistics-warehouse.
terminal Installation and usage
OCA documentation · Odoo 16.0Usage
Source · Odoo 16.0- Go to Inventory > Reporting > Inventory Valuation and click 'Inventory at Date'.
- In the wizard, select a date in 'Inventory at Date', and click 'Valuation as of Accounting Date' (note that 'hh:mm:ss' part of the selection in 'Inventory at Date' is ignored in this context).
No verified information in OCA: Installation, Configuration.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.