Historical Stock Quantity Adjustment - تعديل المخزون بتاريخ سابق
by Ahmed Nour https://www.yourwebsite.com$ 49.00
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Invoicing (account) |
| Lines of code | 906 |
| Technical Name |
an_backdated_inventory |
| License | LGPL-3 |
| Website | https://odoosa.net |
| Versions | 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Invoicing (account) |
| Lines of code | 906 |
| Technical Name |
an_backdated_inventory |
| License | LGPL-3 |
| Website | https://odoosa.net |
| 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 17.0 🔒 LGPL-3 📦 Inventory/Inventory💡 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) |
⭐ Key Features
|
📊
Historical Stock CalculationCalculate the exact stock quantity at any past date using SQL-based move analysis. See what the stock was on any historical date. |
🕑
Backdated Stock Moves & EntriesCreates properly backdated stock moves, valuation layers, and journal entries all stamped with your chosen historical date. |
🚀
Future Move ConsiderationAutomatically factors in all stock moves after the adjustment date, showing projected "Today Qty After" impact. |
|
📦
Bulk Product LoadingWizard to load all products from a specific location or across all internal locations with one click. Perfect for year-end bulk corrections. |
🏷
Lot/Serial & Package TrackingFull support for lot/serial numbers, packages, and owner tracking. Adjustments are precise down to the lot level. |
🌐
Timezone-Aware ProcessingAll date calculations respect user timezone with proper UTC conversion. Stock moves stamped at end-of-day in your local time. |
⚠️ The Problem This Solves
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 between the adjustment date and today
📷 Screenshots
Main list view showing historical quantities and their impact on today's stock
Load by Location wizard — bulk load all products from a location
Form view with real-time calculations
Stock move created with the historical date
Journal entry with backdated date
Stock valuation layer with backdated timestamp
🛠 How It Works — Example
Scenario: 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.
📄 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 |
🎯 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 |
📞 Need Help or Customization?
|
💬
WhatsApp+966 53 692 9391 |
✉
Emailahmednour@outlook.com |
🌐
Websiteodoosa.net |
© 2025 Ahmed Nour - Professional Odoo Solutions
Please log in to comment on this module