Stock Inventory Backdate

Overview

This module allows you to create backdated inventory adjustments with a specific date and time. Unlike the standard Odoo inventory adjustment, this module creates stock moves with the exact backdated datetime you specify.

Features

• Dedicated Backdated Adjustment Form: Separate interface for creating backdated inventory adjustments
• Historical Inventory Position: View the theoretical inventory quantity at the backdated time
• Full Datetime Support: Specify both date and time for the adjustment
• Proper Backdating: All related records (stock moves, move lines, valuation layers, and account moves) are backdated correctly
• Multi-line Support: Adjust multiple products in a single backdated adjustment
• Lot/Serial Number Support: Handle products with lot/serial number tracking
• Package & Owner Support: Support for advanced tracking features

Usage

Creating a Backdated Inventory Adjustment

1. Go to Inventory > Operations > Backdated Adjustments
2. Click Create
3. Set the Adjustment Date & Time to the desired backdate
4. Select the Location where you want to adjust inventory

Option A: Load All Products 5. Click Load Products to automatically load all products with inventory at that location

• The system will calculate the theoretical quantity at the backdated time for each product

6. Adjust the Counted Quantity for each product as needed
7. The Difference column shows what will be adjusted
8. Click Validate to create the backdated stock moves

Option B: Add Individual Products 5. In the Inventory Lines tab, click Add a line 6. Select the Product you want to adjust

• The system will automatically calculate the Theoretical Quantity at the backdated time

7. Enter the Counted Quantity
   • The Difference is calculated automatically
8. Add more products as needed
9. Click Validate to create the backdated stock moves

Technical Details

How It Works

1. When you validate a backdated adjustment, the module creates standard stock moves
2. After the moves are processed, it updates the dates via SQL to ensure proper backdating:
   • Stock move date field
   • Stock move line date field
   • Stock valuation layer create_date field
   • Account move date field (if real-time valuation is enabled)

Models

• stock.inventory.backdate: Main model for backdated adjustments
• stock.inventory.backdate.line: Individual product lines in the adjustment

Security

• Stock Users can create, read, update, and delete backdated adjustments
• Stock Managers have full access

Version History

Version 17.0.2.0.0

• Complete redesign with dedicated backdated adjustment form
• Proper backdating of all related records
• Historical inventory position calculation
• Support for lot/serial numbers, packages, and owners

Version 17.0.1.1.0

• Changed fields from Date to Datetime
• Added time support to inventory adjustments

Version 17.0.1.0.0

• Initial release
• Basic backdating functionality

Author

Suherdy Yacob

License

AGPL-3