Skip to Content

Historical Stock Quantity Adjustment

by
Odoo

$ 48.90

v 19.0 Third Party
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Discuss (mail)
• Inventory (stock)
Lines of code 893
Technical Name an_backdated_inventory
LicenseLGPL-3
Websitehttps://www.yourwebsite.com
Versions 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Discuss (mail)
• Inventory (stock)
Lines of code 893
Technical Name an_backdated_inventory
LicenseLGPL-3
Websitehttps://www.yourwebsite.com
Versions 17.0 18.0 19.0

Historical Stock Quantity Adjustment

View and correct stock quantities at any past date with automatic future move consideration

Odoo 19.0

What Makes This Module Different?

1
Get Historical Qty

Calculate exact stock quantity at any past date
2
Correct It

Set the quantity that should have been at that date
3
See Today's Impact

Auto-calculates effect on current stock (considers future moves)

The Problem This Solves

Common Scenario: It's January and you discover your December 31st closing stock was wrong. You need to correct the historical quantity, but standard Odoo inventory adjustments only work with current dates.

The Historical Stock Quantity Adjustment module solves this by:

  • Calculating the exact stock quantity at any past date - Not today's quantity, but what it was (or should have been) on that specific date
  • Allowing you to correct that historical quantity - Set the correct value that should have been recorded
  • Automatically considering moves after that date - Shows you "Today Qty After" which accounts for all stock movements that happened between the adjustment date and today
Historical Stock Quantity Adjustment List View

Main list view showing historical quantities and their impact on today's stock

How It Works - Example

Scenario: You want to correct stock for Product X at Location A on December 31, 2024

Field Value Meaning
Adjustment Date 31/12/2024 The historical date you want to correct
Current Qty 100 Calculated stock at 31/12/2024 (based on moves up to that date)
Target Qty 120 What the stock SHOULD have been on 31/12/2024
Difference +20 The adjustment needed (auto-calculated)
Today Qty 80 Current stock today (includes moves after 31/12)
Today Qty After 100 What today's stock will be after applying (+20)

Result: A backdated stock move for +20 units is created on 31/12/2024, and your current stock automatically increases from 80 to 100.

Load by Location Wizard

Load by Location wizard - bulk load all products from a location

Key Features

Historical Quantity Calculation

Accurately calculates what stock quantity was at any past date by analyzing all stock moves up to that date.

Future Move Consideration

Shows "Today Qty After" - automatically factors in all moves that happened AFTER your adjustment date.

Backdated Records

Creates stock moves, journal entries, and valuation layers with the historical date for proper accounting.

Bulk Operations

Load all products from a location or all internal locations. Apply adjustments to multiple products at once.
Adjustment Form View

Form view with real-time calculations

What Gets Created (All Backdated)

Record Type Description
Stock Move Created with your adjustment date (end of day)
Stock Move Line With lot/serial tracking if applicable
Stock Quant Updated quantity on hand
Stock Valuation Layer With backdated timestamp for inventory value
Journal Entry Accounting entry with the historical date
Stock Move Created

Stock move created with the historical date

Journal Entry Created

Journal entry with backdated date

How to Use

Method 1: Individual Adjustment

  1. Go to Inventory > Operations > Historical Adjustments
  2. Click New
  3. Select Product, Location, and Adjustment Date
  4. The system calculates Current Qty (stock at that date)
  5. Enter Target Qty (what it should have been)
  6. Review Today Qty After (impact on current stock)
  7. Click Apply Adjustment

Method 2: Bulk Load by Location

  1. Click Load by Location button
  2. Select Adjustment Date (defaults to Dec 31 of previous year)
  3. Choose Location or check All Internal Locations
  4. Click Load Products then Create Adjustments
  5. Set target quantities and apply
Tip: The adjustment date defaults to December 31st of the previous year - perfect for year-end inventory corrections.
Stock Valuation Layer

Stock valuation layer with backdated timestamp

Perfect For

Year-End Closing

Correct December 31st stock quantities after discovering discrepancies in January

 Audit Adjustments

Make corrections on the exact date required by auditors
POS Session Delays

Fix stock when POS sessions close after midnight but sales were from the previous day

 Data Migration

Set opening balances on historical dates during system migrations

Technical Details

Timezone Handling

Stock moves are created at end of day (23:59:59) in your user's timezone, then converted to UTC. This ensures proper period-end reporting.

Dependencies

stock, stock_account, mail

Access Rights

Stock Users: Read only | Stock Managers: Full access

Support

  • Author: Ahmed Nour
  • Version: 19.0.1.0.0
  • License: LGPL-3

© 2025 Ahmed Nour - Historical Stock Quantity Adjustment for Odoo 19

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.