Skip to Content

Stock Inventory Adjustment

by
Odoo

$ 19.90

v 19.0 Third Party 34
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Discuss (mail)
Lines of code 876
Technical Name stock_inventory_adjustment
LicenseLGPL-3
Websitehttps://odootips.com
Versions 15.0 16.0 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 • Inventory (stock)
• Discuss (mail)
Lines of code 876
Technical Name stock_inventory_adjustment
LicenseLGPL-3
Websitehttps://odootips.com
Versions 15.0 16.0 17.0 18.0 19.0
Stock Inventory Adjustment | PDF Report & Excel Import
Compare theoretical vs. counted quantities and generate stock moves automatically

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
▶ Watch on YouTube
  • ✔ Community
  • ✔
    Enterprise
    (On-premises)
  • ✔ Odoo.sh
  • ✘ Online
Odoo Version
19.0
⭐ Key Features
📋
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

📖 Documentation
🔑 1. Access & Roles
Manager Group
  • Create adjustments
  • Start inventory
  • Validate / Cancel
  • Delete (Draft only)
User Group
  • View adjustments
  • View lines
  • Read-only access
Access configuration
Requirements: Access to internal locations and products.
📂 2. Menu Navigation

Access from: Inventory → Operations → Inventory Adjustments

Menu navigation
Inventory → Operations → Inventory Adjustments
📋 3. List View

View all adjustments with the following columns:

List view
Reference

Adjustment name

Location

Inventoried location

State

Draft / In Progress / Validated

➕ 4. Create Adjustment

Click Create, select Location and Inventory Type.

Create form
📋 Inventory Types

All, Selected, Category, Lot/Serial, Manual, Excel Import

⚙ Options

Prefill Counted Qty, Include Exhausted

▶ 5. Start Inventory

Click Start Inventory. State changes to In Progress and lines are generated.

Start inventory
Lock: Only 1 inventory in progress per location. Complete or cancel before starting another.
📝 6. Edit Lines

Enter counted quantities. Differences are calculated automatically.

Edit lines
Theoretical

System quantity (read-only)

Counted

Physical quantity (editable)

Difference

Red = shortage, Green = surplus

📥 7. Excel Import

Select Import from Excel, attach file, then click Start Inventory.

Excel import
📗 File Format
✔ CODE: Internal ref or barcode
✔ QTY: Counted quantity
✔ LOT: Optional (if tracked)
Formats: .xlsx, .xls, .csv | Requires: pip install pandas==3.0.0 openpyxl==3.1.5
✅ 8. Validate Inventory

Review all lines, then click Validate. Stock moves are created automatically.

Validate inventory
Shortages

Stock OUT from location

Surpluses

Stock IN to location

Important: Once validated, the adjustment cannot be edited or cancelled.
📄 9. PDF Report

Open validated adjustment, go to Print → Inventory Adjustment Report.

PDF report
📕 Report Contents
✔ Header with details
✔ All lines with differences
✔ Shortages & Surpluses sections
📄 10. Excel Report

Open validated adjustment, go to Excel.

Excel report
📕 Report Contents
✔ Header with details
✔ All lines with differences
✔ Shortages & Surpluses sections
📄 9. Result

Inventory result, the updated new quantity is shown

Result
❓ 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

  • 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.
The base app module was a great start, so we collaborated with Wilder to make some necessary changes to handle specific needs for one of our clients. Work and support has been great all round, it is a pleasure working with Wilder.
by
Sheldon Stroebel
on 5/22/26, 2:03 PM


There are no comments yet!