Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Warehouse
  3. Inventory and Stock Warehouse Report v 18.0
  4. Sales Conditions FAQ

Inventory and Stock Warehouse Report

by SprintERP Technologies https://sprinterp.com
Odoo

$ 18.00

v 18.0 Third Party
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Sales (sale_management)
• Discuss (mail)
• Purchase (purchase)
• Invoicing (account)
Lines of code 1253
Technical Name se_warehouse_report_app
LicenseLGPL-3
Websitehttps://sprinterp.com
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Sales (sale_management)
• Discuss (mail)
• Purchase (purchase)
• Invoicing (account)
Lines of code 1253
Technical Name se_warehouse_report_app
LicenseLGPL-3
Websitehttps://sprinterp.com
sprinterp-logo

Inventory and Stock Warehouse Report

Advanced inventory warehouse reporting system with stock aging, valuation, movement, transfer, and status analysis in PDF and Excel formats.

Key Module Highlights

Inventory Aging Movement
Non-Moving Dead Stock
Real-Time Stock Valuation
Location Transfer History
Multi-Scope Filtering
Dual PDF & Excel Exports

Inventory Reporting & Stock Audit Workflow

Step 1
Enable Inventory Report Access Rights

Navigate to Settings > Users & Companies > Users and select a user. Under the Other section, enable the "Manage Inventory and Stock Movement" checkbox to grant authorized managers access to generate advanced inventory aging, valuation, and transfer reports.

Odoo Inventory and Stock Warehouse Report Access Rights Configuration

Key Logic: Only users with this security group enabled will be able to view and access the dedicated warehouse analytical reporting menus and wizards.

Step 2
Standard Transactions Impacting Stock Intelligence

The reporting engine automatically monitors all source transactions like Purchase Orders, Receipts, and Sales Orders. When products are received into the warehouse, the system tracks their incoming quantity, cost methods, and operational dates to build the backend logs for aging and status tracking.

Odoo Purchase Orders and Receipts Stock Impact

Data Flow: Received quantities directly feed into the Opening/Closing stock valuation metrics, ensuring your analytical dashboards and Excel spreadsheets always stay real-time and error-free.

Step 3
Outgoing Stock & Sales Outflow Analysis

The system precisely captures outgoing quantities from confirmed Sales Orders and Deliveries. These logs allow the module to isolate sales velocity, analyze accurate inventory aging periods, and map exact stock movements away from your storage locations.

Odoo Sales Orders Stock Outflow Tracking

Key Benefit: Separating sales analytics helps management easily identify which warehouse products have high market demand vs those turning into slow-moving or dead stock.

Step 4
Real-Time Warehouse Stock Movement Auditing

Track completed warehouse operations such as Delivery Orders (WH/OUT) and Receipts directly within the audit engine. The system automatically locks down the effective operational dates, demand metrics, and actual moved quantities to keep your warehouse traceability clear and ready for validation.

Odoo Inventory Stock Movement and Delivery Validation

Traceability Insight: Validating these transfers automatically updates the multi-period analytical buckets, allowing inventory managers to generate structured audit trails instantly.

Step 5
Dedicated Warehouse Reporting Menu Hierarchy

Navigate to the Inventory > Reporting sub-menu to access the comprehensive analytics dashboard. Authorized inventory managers can easily trigger multi-period stock aging movement analysis, valuation summaries, and location transfer tracking sheets right from this centralized warehouse control view.

Odoo Advanced Inventory Reporting Menus

Access Security: This drop-down menu visibility is dynamically controlled and securely limited to users belonging to the "Manage Inventory and Stock Movement" group created in Step 1.

Step 6
Flexible Filtering & Scope Selection Wizard

Clicking the report menu opens an advanced Reporting Wizard. This dynamic interface allows you to configure custom aging period lengths, filter records instantly by specific Products or Categories, and define the precise reporting scope based on your target Warehouse or Stock Locations.

Odoo Inventory Report Configuration Wizard View

Dual Export Engine: Once filters are configured, you can download enterprise-grade analytics instantly by clicking either the Print PDF button (via QWeb) or the Print Excel button (via xlsxwriter).

Step 7
Instant Report Generation & Download Management

When the print action is executed, the reporting engine compiles live records in the background and presents a Download Wizard. This window displays the final file summary and an explicit cloud download link, allowing users to securely extract highly structured spreadsheets locally.

Odoo Excel Report Download Wizard Popup

Performance Benefit: Generating sheets via transient binary fields ensures minimal database overhead, allowing heavy analytical warehouse datasets with thousands of operational stock items to render seamlessly.

Step 8
Professional Multi-Period Excel Output Layout

The generated xlsxwriter spreadsheet features clean corporate gridlines, merged matrix headers, and auto-adjusted table columns. It isolates multi-bucket periods (like 0-30, 30-60 days) and breaks down operational logs into distinct Sale, Purchase, and Adjustment segments with computed inventory values.

Odoo Inventory Stock Aging Movement Excel Report Sheet

Management Dashboard: Compact landscape layouts allow tracking of product codes, internal names, and valuation parameters side-by-side, giving inventory supervisors management-ready insights instantly.

Step 9
Dynamic QWeb PDF Report Generation

By clicking the Print PDF button, the system triggers the native Odoo QWeb report template. It dynamically compiles all active inventory metrics, category structures, and valuation matrices into a professionally styled, document-ready format.

Odoo Inventory Report Print PDF Layout Action

Print Layout: The PDF engine utilizes clean landscape rendering, making it perfect for physical archiving, warehouse audit presentations, and attaching directly to company leadership update emails.

Step 10
Professionally Styled QWeb PDF Document Output

The compiled QWeb PDF report features a clean corporate layout with customized header branding and dynamic metadata alignment. It automatically builds granular analytics across extended buckets (e.g., 0-30, 30-60, 60-90, 90-120, and >120 Days) isolating transactional velocity streams into crisp tabular grids.

Odoo Stock Aging Movement QWeb PDF Report Output Layout

Corporate Ready: This landscape layout automatically calculates company parameters, currency indicators, and printed-on timestamp markers, making it fully optimized for quick boardroom analysis and financial reconciliation.

Step 11
Identify Non-Moving Stock Categories Easily

To monitor dormant inventory, click on the dedicated "Inventory And Stock Aging Without Movement Report" option under the reporting drop-down. This engine automatically filters out items that haven't registered any operational movement or transactional updates over specified intervals.

Odoo Inventory Aging Without Movement Reporting Options

Operational Audit: Spotting non-moving quantities helps warehouse operators clear out storage blockages, reduce holding overheads, and re-allocate capital investment from stagnant materials to high-velocity products.

Step 12
Dead Stock Configuration & Parameter Wizard

The Without Movement Report Wizard gives you granular control to trace inactive products. You can customize the period lengths to define what qualifies as stagnant stock, apply specific Category filters, and scope the analysis to localized warehouses or internal stock locations.

Odoo Inventory Without Movement Report Wizard

Targeted Actions: Just like the aging movement dashboard, you can trigger individual compilation processes to extract this stagnant data matrix instantly into high-fidelity PDF layouts or Excel spreadsheets.

Step 13
Dormant Inventory Financial Valuation Matrix (Excel)

The generated Without Movement Excel sheet provides an executive-level summary of stagnant products. It consolidates total non-moving quantities and their accumulated financial values, spreading them automatically across multiple historical buckets from 0-30 days up to over 120 days.

Odoo Stock Aging Without Movement Excel Report Sheet

Strategic Accounting: Having exact Total Qty and Total Value insights side-by-side allows financial controllers to write down depreciated assets accurately and make informed decisions during yearly warehouse audits.

Step 14
Auditable Non-Moving QWeb PDF Document Layout

The Without Movement PDF Report renders a structured audit matrix ready for executive review. It cleanly displays product codes, operational categories, total quantities, and valuation parameters, mapping dead stock assets precisely across time periods like 0-30 days up to >120 days.

Odoo Stock Aging Without Movement QWeb PDF Report Sheet

Corporate Compliance: Fully integrated with dynamic translation filters and multi-company parameter headings, this clean print layout is optimized for sharing directly during internal supply chain tracking meetings.

Step 15
Granular Location & Internal Shelf-Level Scoping

The reporting engine provides deep operational flexibility by allowing you to change the scope from an entire Warehouse to specific Internal Locations. You can explicitly select precise child locations and storage rows (like WH/Stock/Shelf 1 or Shelf 2) to analyze micro-level stock stagnation.

Odoo Inventory Stock Location Filtering Scope Wizard

Micro-Inventory Audit: This location-specific routing allows managers to clear slow-moving items from high-demand physical slots or internal corridors without scanning independent global analytics sheets.

Step 16
Location-Specific Excel Analytics Spreadsheet

The generated Excel output dynamically maps selected internal shelf parameters right inside the spreadsheet headers. Instead of generic summaries, it delivers focused aging records filtered strictly for child rows like WH/Stock/Shelf 1 and Shelf 2, displaying exact values alongside stagnant aging buckets.

Odoo Stock Location Filtered Excel Report Output

Data Validation: Dynamically extracting local shelf data points ensures that zone managers can run quick, isolated spot-checks on specific rows without confusing or polluting global warehouse counts.

Step 17
Location-Filtered QWeb PDF Executive Document

The compiled document layout automatically synchronizes child locations inside the corporate QWeb PDF headers. It tracks stagnant products sitting on designated shelf matrices like WH/Stock/Shelf 1 and Shelf 2, ensuring highly accurate tracking maps during physical stock adjustments.

Odoo Stock Location Filtered QWeb PDF Report View

Operational Audit: Clean physical page layouts allow floor teams to sign off on specific shelf purges, directly matching legal physical location criteria parameters perfectly.

Step 17
Location-Specific QWeb PDF Document Printing

The compiled PDF engine seamlessly echoes your child location parameters directly onto the corporate report header. It builds a clean, print-ready document filtering stale stock values specifically for child racks like WH/Stock/Shelf 1 and Shelf 2.

Odoo Stock Location Filtered QWeb PDF Report Output

Operational Audit: This provides warehouse supervisors with an official, signed-off physical printout of stagnant stocks located in a single targeted aisle, without cluttering macro-level accounting books.

Step 18
Advanced Inventory Stock Valuation Management

To calculate clear capital asset charts, click on the dedicated "Inventory And Stock Valuation Report" option under the main reporting dropdown hierarchy. This feature helps calculate stock valuations on a real-time basis.

Odoo Advanced Stock Valuation Reporting Menu Selection

Valuation Metrics: This analytical system acts as the core gateway to compute opening stock records, warehouse scrap movements, standard price adjustments, and closing stock valuation matrices.

Step 19
Product-Wise Inventory Stock Valuation Wizard

The Inventory Stock Valuation Wizard provides comprehensive configuration parameters. You can filter the data structure instantly based on specific Products or entire Categories, define a strict From/To Date range, and scope the calculation matrix directly to your selected warehouse assets.

Odoo Inventory Stock Valuation Configuration Wizard

Dual Compilations: Once products and operational bounds are assigned, you can immediately compile and download the financial results using either the Print PDF layout or the high-fidelity Print Excel engine.

Step 20
Comprehensive Real-Time Stock Valuation Sheet (Excel)

The generated Stock Valuation Excel report presents highly detailed corporate financial tracking. It isolates critical ledger buckets side-by-side—including Opening, Adjustment, Scrap, and Closing Stocks—with exact quantity and cost valuation metrics automatically mapped based on active product pricing rules.

Odoo Inventory Stock Valuation Excel Spreadsheet Output

Financial Traceability: Displaying Available Quantities, Cost Prices, and Sales Prices together allows auditors to analyze stock margins and clear profit/loss variations instantly without manual cross-examinations.

Step 21
Executive-Ready Stock Valuation QWeb PDF Document

The compiled QWeb PDF Valuation Report offers an official financial document for high-level management. It maps live quantity metrics and product values into crisp horizontal grids, maintaining clean line boundaries across complex parameters like Opening Stock, Scrap Stock, and net Stock Valuations.

Odoo Stock Valuation QWeb PDF Report Sheet

Corporate Branding: Featuring standard metadata timestamps, currency codes, and customizable company headers, this document is fully optimized to be printed out or shared during official corporate financial audits.

Step 22
Centralized Inventory Stock Status Reporting Menu

To audit internal and external logistics trends, click on the dedicated "Inventory And Stock Status Report" menu item under the reporting structure. This module provides quick analytical visibility over transfer operations across the organization.

Odoo Inventory Stock Status Reporting Menu Selection

Operational Auditing: This engine isolates standard warehouse transfers from customer or vendor returned stock activities, giving warehouse controllers deep operational overview patterns instantaneously.

Step 23
Custom Product & Warehouse Stock Status Wizard

The Stock Status Wizard grants refined control to analyze movement categories. You can multi-select targeted Products or Categories, bound the tracking period using active start/end calendars, and isolate the logistics flow strictly across your designated corporate Warehouse boundaries.

Odoo Inventory Stock Status Filtering Wizard

On-Demand Compilation: Once filtering items are configured, the dual layout links—Print PDF and Print Excel—instantly process background relational charts to deliver structured ledger metrics.

Step 24
Standard vs Return Transfers Operational Matrix (Excel)

The generated Stock Status Excel sheet provides high-fidelity tracking over logistical cycles. It isolates standard fulfillment streams from customer/vendor reverse logistics by splitting metrics into Incoming/Outgoing Transfers and Return Incoming/Return Outgoing Quantities side-by-side.

Odoo Inventory Stock Status Excel Sheet Output

Operational Audit: Having isolated standard vs return indicators allows warehouse supervisors to detect high product damage patterns, monitor supply-chain errors, and control internal material distributions easily.

Step 25
Official Stock Status QWeb PDF Output Layout

The compiled QWeb PDF Stock Status Report provides a clean, landscape-oriented document for warehouse compliance. It cleanly presents code segments, stock locations, and product categories alongside separate matrices for Fulfillment Transfers and Reverse Logistics Returns.

Odoo Inventory Stock Status QWeb PDF Report Sheet

Management Presentation: Integrated with explicit print timestamps, currency parameters, and company metadata rows, this clean layout is fully ready to be filed directly during supply chain audits or internal quality assessments.

Step 26
Advanced Warehouse Location Transfer Auditing Menu

To track historical inter-location stock movements, navigate to the Inventory > Reporting sub-menu and select the "Inventory And Stock Location Transfer Report". This layout allows management to trace internal distributions accurately across various warehouse rows.

Odoo Inventory Stock Location Transfer Reporting Menu Selection

Operational Auditing: This feature acts as the direct gateway to pull out deep analytical data sets, isolating transit histories, source slots, and destination locations for strict audit verification.

Step 27
Category-Wise Location Transfer Parameter Wizard

The Location Transfer Reporting Wizard provides multi-level selection features. You can filter historical data streams instantly by multiple Product Categories, bind the execution tracking window using clear calendar bounds, and scale the reporting scope strictly to your required Warehouse asset zones.

Odoo Inventory Stock Location Transfer Category Filter Wizard

Flexible Controls: Sorting transfers by entire categories allows inventory audit managers to map stock routing trends and internal movements collectively without creating isolated single-product entries.

Step 28
Historical Location Transfer Matrix QWeb PDF Output

The compiled QWeb PDF Location Transfer Report provides an executive-grade landscape view of historical stock routing. It cleanly tracks the exact Transfer Dates, Source Locations, Destination Locations, and ultimate Transfers Location Quantities for individual product lines across Sale, Purchase, and Adjustment cycles.

Odoo Inventory Stock Location Transfer QWeb PDF Report Sheet

Traceability Benefit: Having historical dates and exact source-to-destination routing points side-by-side allows supply chain managers to quickly audit stock velocity anomalies and optimize warehouse storage spaces without manual cross-referencing.

Step 29
Detailed Inter-Location Stock Routing Spreadsheet (Excel)

The generated Location Transfer Excel report delivers high-fidelity logistical matrix data. It cleanly structures and outputs historical tracking matrices—including Transfer Dates, Source/Destination nodes, and net Transferred Quantities—across customized cells optimized for large-scale data manipulation.

Odoo Inventory Stock Location Transfer Excel Sheet Output

Spreadsheet Advantage: Exporting tracking arrays directly into highly-formatted sheets allows corporate analysts to apply native filter rows, compute average transfer rates, and execute bulk multi-warehouse verification controls effortlessly.

Step 30
Complete Warehouse Stock Movement Tracking Gateway

To activate full-scale material traceability audits, navigate to the Inventory > Reporting menu structure and select the final "Inventory And Stock Movement Report" option [2]. This submenu serves as the engine gateway to compile comprehensive historical movement logs.

Odoo Inventory Stock Movement Reporting Menu Selection

Auditing Core: Triggering this report processes active operation lines, capturing stock changes, quantities moved, and destination statuses for high-integrity security compliance.

Step 31
Dynamic Stock Movement Filter & Scope Wizard

The Stock Movement Wizard provides an easy-to-use filtering layout. It allows users to control the auditing timeline by specifying active From Date and To Date ranges, while adjusting the analysis boundaries to focus on target Warehouse operations.

Odoo Inventory Stock Movement Report Configuration Wizard

Format Flexibility: After configuring the target timeline and scopes, you can extract the warehouse data logs seamlessly into structured layout presentation files using the Print PDF or Print Excel buttons.

Step 32
Full Operational Traceability Matrix QWeb PDF Output

The compiled QWeb PDF Stock Movement Report renders an all-inclusive historical log of warehouse lifecycle actions. It explicitly catalogs every move line with fields tracking the exact Inventory Date, Operation Types (such as Delivery Orders, Receipts, or Adjustments), Source/Destination Locations, and final moved Quantities (Qty).

Odoo Inventory Stock Movement QWeb PDF Report Sheet

Audit Integrity: Grouping standard deliveries and raw adjustment quantities into an official corporate print layout ensures that warehouse managers can track localized inventory leakage and verify transaction paths smoothly.

Step 33
Comprehensive Stock Movement Auditor Spreadsheet (Excel)

The generated Stock Movement Excel spreadsheet delivers deep-level operational datasets. It cleanly organizes transaction flows—including detailed Operation Types, raw Inventory Dates, and Source/Destination routing nodes—directly inside an analytical matrix optimized for immediate custom sorting.

Odoo Inventory Stock Movement Excel Spreadsheet Output

Data Security Analysis: Exporting large operational arrays into clean ledger formats gives data teams the power to run pivot matrices, audit multiple distribution changes, and cross-examine supply chain records without lag.

Key Features & Capabilities

Empower your warehouse operations with flexible filters and automated analytical reporting engines in Odoo.

Inventory Aging Movement

Generate dynamic stock aging reports with custom periods. Separate Sale, Purchase, and Adjustment buckets.

Non-Moving Stock Report

Easily detect dead lines and inactive quantities to manage holding costs and optimize space.

Stock Valuation Intelligence

Track Opening, Adjustment, Scrap, and Closing stock balances calculated through product cost methods.

Location Transfer Audit

Track histories between source and destination zones alongside accurate moved quantity metrics.

Flexible Scope Filters

Filter reports granularly by individual Products, Product Categories, Warehouses, or specific Stock Locations.

Dual Reporting Layouts

Export professional PDF layouts using QWeb or comprehensive styled tables via xlsxwriter.

Need Any Help?

Free 90 Days Support

Installation, Configuration & Bug Fixing support from our experts.

Email Support sales.sprinterp@gmail.com
Microsoft Teams abulkasim7214

© 2024 SprintERP Technologies. All Rights Reserved.

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.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with