Skip to main content
Odoo Community Association

Stock Move Actual Date

Beta License: AGPL-3 OCA/stock-logistics-workflow Translate me on Weblate Try me on Runboat

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.

Table of contents

Configuration

  • Go to Settings > Users & Companies > Groups.

  • Open ‘Modify Actual Date’ and add the users who are allowed to edit the actual date of completed records (e.g., pickings, scraps).

Usage

Use the Actual Date field in the following transfer and scrap scenarios:

  • If you are late in processing a transfer or scrap in Odoo and wish to record the transaction with the actual transfer date, fill in the Actual Date field in the picking or scrap form. The Actual Date of the picking or scrap is then propagated to its corresponding stock moves and stock move lines, and is also passed to the journal entry as the date.

  • You can also update the Actual Date of a completed picking or scrap if you belong to the ‘Modify Actual Date’ group. This operation updates the date of the related journal entries, re-proposing a new sequence to them as necessary.

Use the Actual Date field in the following stock valuation reporting scenarios:

  1. Go to Inventory > Reporting > Inventory Valuation and click ‘Inventory at Date’.

  2. 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).

Use the Actual Date field in the following stock quantity history reporting scenarios:

  1. Go to Inventory > Reporting > Stock and click ‘Inventory at Date’.

  2. In the wizard, select a date in ‘Inventory at Date’, and click ‘Inventory as of Actual Date’ (note that the ‘hh:mm:ss’ part of the selection in ‘Inventory at Date’ is ignored in this context).

Note: You can also use this feature along with stock_quantity_history_location.

Known issues / Roadmap

Updating the Actual Date of a completed receipt picking for a foreign currency purchase does not trigger a recalculation of the amounts in the associated journal entries, even if the currency rate for the new date differs.

For the Actual Date of existing stock move and stock move line records created before this module was installed, the user’s timezone will not be considered, and only the date part from the ‘date’ field in the UTC timezone will be assigned.

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

  • Quartile

Contributors

  • Quartile:

    • Aung Ko Ko Lin

    • Yoshi Tashiro

Maintainers

This module is maintained by the OCA.

Odoo Community Association

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

Current maintainers:

yostashiro aungkokolin1997

This module is part of the OCA/stock-logistics-workflow project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.

Release files for odoo-addon-stock-move-actual-date 18.0.1.1.0.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Built distribution (wheel)

Table of built distributions (wheels) for odoo-addon-stock-move-actual-date 18.0.1.1.0.1
File Interpreter ABI Platform
odoo_addon_stock_move_actual_date-18.0.1.1.0.1-py3-none-any.whl Python 3 none any Details

Release files / odoo_addon_stock_move_actual_date-18.0.1.1.0.1-py3-none-any.whl

Download URL odoo_addon_stock_move_actual_date-18.0.1.1.0.1-py3-none-any.whl
Size 43.9 kB
Tags Python 3
SHA-256 checksum
How to use checksums
b9f8d6c6b68e8578318fc1b3d91cf8412101e3f7f443cdc67e1e5b95d54d92de
BLAKE2b-256 checksum
How to use checksums
e6e254e6951b873f56171322e628d87b42ab34d5b60e2c658f3a756f2064e633
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.12.3
Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page