| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 876 |
| Technical Name |
stock_inventory_adjustment |
| License | LGPL-3 |
| Website | https://odootips.com |
| Versions | 15.0 16.0 17.0 18.0 19.0 |
Ideal for warehouses, retail, and distribution centers. This module lets you create an inventory adjustment, capture counted quantities, compute shortages/surpluses, and automatically generate stock moves with a printable PDF.
- ✅ Multiple Inventory Types - All products, selected products, category, lot/serial, manual, Excel import
- ✅ Automatic Differences - Computes shortages and surpluses instantly
- ✅ Stock Moves - Generates adjustment moves upon validation
- ✅ PDF Report - Printable report with all lines, shortages, and surpluses
- ✅ Multi-Company - Works across multiple companies/warehouses
- ✅ Excel Import - Load counted quantities from spreadsheet
- ✔ Community
-
✔
Enterprise
(On-premises) - ✔ Odoo.sh
- ✘ Online
6 Inventory Types
All, Selected, Category, Lot/Serial, Manual, Excel Import
Real-time Differences
Shortages (red) and surpluses (green) calculated instantly
Excel Import
CODE/QTY/LOT columns, .xlsx/.xls/.csv formats
PDF Report
Print all lines, shortages, and surpluses with totals
- Create adjustments
- Start inventory
- Validate / Cancel
- Delete (Draft only)
- View adjustments
- View lines
- Read-only access
Access from: Inventory â Operations â Inventory Adjustments
Inventory â Operations â Inventory Adjustments
View all adjustments with the following columns:
Reference
Adjustment name
Location
Inventoried location
State
Draft / In Progress / Validated
Click Create, select Location and Inventory Type.
📋 Inventory Types
All, Selected, Category, Lot/Serial, Manual, Excel Import
⚙ Options
Prefill Counted Qty, Include Exhausted
Click Start Inventory. State changes to In Progress and lines are generated.
Enter counted quantities. Differences are calculated automatically.
Theoretical
System quantity (read-only)
Counted
Physical quantity (editable)
Difference
Red = shortage, Green = surplus
Select Import from Excel, attach file, then click Start Inventory.
📗 File Format
pip install pandas==3.0.0 openpyxl==3.1.5
Review all lines, then click Validate. Stock moves are created automatically.
Shortages
Stock OUT from location
Surpluses
Stock IN to location
Open validated adjustment, go to Print â Inventory Adjustment Report.
📕 Report Contents
Open validated adjustment, go to Excel.
📕 Report Contents
Inventory result, the updated new quantity is shown
❓ What Odoo versions are supported?
Odoo 19 - Community and Enterprise on-premises are fully supported.
❓ Does this work with multi-company?
Yes, the module supports multiple companies and warehouses.
❓ Can I import counted quantities?
Yes. Use Import from Excel with CODE/QTY/LOT columns (.xlsx, .xls, .csv).
❓ What happens on validation?
Stock moves are created automatically for shortages (out) and surpluses (in).
❓ Do I need extra Python libraries?
For Excel import: pip install pandas==3.0.0 openpyxl==3.1.5
Need Help?
Contact us for technical support, bug reports, or feature requests.
Contact Support⏰ Response time: 24-48 hours
⭐ If you like this module, please leave a review on Odoo Apps ⭐
Please log in to comment on this module