All in One Inventory Reports | All in One Stock Reports
by DevIntelle Consulting Service Pvt.Ltd https://www.devintellecs.com$ 147.98
In-App Purchases| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Purchase (purchase) • Sales (sale_management) • Discuss (mail) |
| Lines of code | 17150 |
| Technical Name |
dev_all_in_one_inventory_reports |
| License | See License tab |
| Website | https://www.devintellecs.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Purchase (purchase) • Sales (sale_management) • Discuss (mail) |
| Lines of code | 17150 |
| Technical Name |
dev_all_in_one_inventory_reports |
| License | See License tab |
| Website | https://www.devintellecs.com |
All In One Inventory Reports
All In One Inventory Reports module provides a comprehensive suite of advanced analytical and operational reports for your Odoo inventory. This bundle includes crucial reports such as FSN-XYZ Analysis, ABC Analysis, Inventory Aging, Stock Valuation, Stock Card, Coverage Analysis, Rotation, and Out of Stock reports, empowering you with in-depth insights for strategic decision-making and efficient stock management.
Inventory FSN-XYZ Analysis Report
The Inventory FSN-XYZ Analysis Report is an
advanced dual-classification tool designed for
Inventory Managers and Supply Chain Heads. It
combines FSN Analysis (Fast, Slow,
Non-Moving based on turnover ratio or sales
quantity) with XYZ Analysis (High, Medium,
Low Value based on consumption value) to provide a
comprehensive view of your inventory health.
This module helps businesses prioritize items that
are both fast-moving and high-value (FX), identify
dead stock that locks up capital (NZ), and make
strategic
Procurement & Liquidation Decisions.
Configure custom thresholds for FSN (Turnover
Ratio/Sales Qty) and XYZ (Value %), filter by
Warehouse/Location/Category/Product and date
range, and generate detailed reports in
PDF and Excel or analyze
interactively On-Screen.
Features
- Multi-Format Reporting: View interactive data On-Screen (List & Pivot), or export professional reports in PDF and Excel formats.
- Comprehensive FSN-XYZ Matrix: Classify products into 9 actionable categories (e.g., FX, SY, NZ) combining speed of movement and inventory value.
- Flexible FSN Configuration: Set custom thresholds for Fast/Slow moving items based on Turnover Ratio or Sales Quantity.
- XYZ Value Analysis: Define percentage thresholds (e.g., Top 70%, Next 20%, Last 10%) to identify High, Medium, and Low value items.
- Advanced Filtering: Analyze by specific Company, Warehouse, Location, Product Category, or individual Products. Include/Exclude Zero Stock items.
Menu Access
Easily access the FSN-XYZ Analysis Report menu under the Inventory > Reporting menu.
General & FSN Configuration
Select Date Range, Company, Products, Categories, and filter by Warehouses/Locations. Option to include Zero Stock items. Configure FSN Fast/Slow thresholds based on Turnover Ratio or Sales Quantity. View the FSN Classification Legend.
XYZ Configuration
Define percentage thresholds for High (X), Medium (Y), and Low (Z) value items for precise Pareto analysis.
FSN-XYZ Matrix Guide
Reference the FSN-XYZ Matrix Chart to understand the 9 distinct classification categories (e.g., FX, SY, NZ).
Report Actions
Quickly generate reports with dedicated buttons: View Report on Screen, Generate PDF Report, or Generate Excel Report.
On-Screen List Analysis
Analyze detailed item data in a list view, displaying Turnover Ratio, Unit Cost, Stock Value, FSN-XYZ Code, and Aging.
Advanced Search & Filtering
Utilize advanced search filters and Group By options to organize data by FSN-XYZ Code, Warehouse, or Category.
Pivot View Analysis
Perform multidimensional analysis using the Pivot view to visualize stock distribution and value across different FSN and XYZ categories.
PDF Report (Turnover Ratio)
Generate a professional PDF report calculated FSN basis on Turnover Ratio, featuring summary statistics and detailed product lists.
PDF Report (Sales Quantity)
Generate the PDF report FSN basis on Sales Quantity analysis for alternative insights.
Excel Export
Export the complete FSN-XYZ analysis to a formatted Excel file for further external processing and sharing.
Analysis History
Access previously generated reports and historical data through the Analysis History menu for trend analysis and record-keeping.
Inventory ABC Analysis Report
The Inventory ABC Analysis Report in Odoo
is a strategic inventory management tool designed
to help businesses optimize their stock levels
based on the Pareto Principle (80/20 Rule).
It segments inventory into Class A (High
Value), Class B (Medium Value), and
Class C (Low Value) items.
By focusing resources on high-value items, you can
Reduce Carrying Costs and
Improve Cash Flow. This tool allows you to
configure custom classification thresholds, choose
between Value-based or
Quantity-based analysis, view on-screen
analysis like List View and
Pivot View, and generate comprehensive
reports in PDF and Excel formats.
Features
- Multi-View Analysis: View detailed reports in List and Pivot views directly on screen, or export to professional PDF and Excel formats.
- Smart ABC Classification: Automatically categorizes products into Class A, B, or C based on cumulative consumption value or quantity percentages.
- Configurable Thresholds: Set your own percentage thresholds for Class A and B items (e.g., A=70%, B=90%) to match your business model.
- Advanced Filtering: Filter analysis by Company, Date Range, Warehouse, Location, Product, and Category.
- Comprehensive Data: Insight into Quantity Consumed, Unit Cost, Consumption Value, Stock On Hand, and Stock Value for every item.
Menu Location
Easily find the ABC Analysis Report in Odoo under the Inventory > Reporting menu.
Report Configuration
Set up the report: Select Date Range, Company, Warehouse, Locations, and filter by Products or Categories. Set detailed ABC Classification settings like Analysis Basis (by Consumption Value or Quantity) and custom Thresholds for Class A and B.
Report Options
Generate reports instantly with dedicated buttons: View Report on Screen, Print PDF Report, or Generate Excel Report.
On-Screen List Analysis
Analyze item-level details in a list view, clearly showing the calculated ABC Class, Consumption Value, and Cumulative Percentages.
Advanced Search & Filtering
Utilize advanced search filters and Group By options to organize your analysis by ABC Class, Company, Warehouse, or Product Category.
Pivot View Analysis
Perform multidimensional analysis using the Pivot view to visualize consumption values and stock levels across different ABC classes and warehouses.
Formatted PDF Report
Download a professional, printable PDF report grouped by ABC Class, providing a clear snapshot of your inventory classification.
Excel Export
Export the complete ABC analysis data to Excel format for further processing, sharing, or external analysis.
Inventory Aging Report
The Inventory Aging Report app is a powerful tool designed to give you deep insights into your stock's health by categorizing inventory based on its age. With fully dynamic aging intervals (e.g., 0-30, 30-60, 60-90 days), you can tailor the analysis to your specific business needs. The module offers robust filtering by Warehouse, Location, Product, and Category, allowing you to isolate slow-moving stock effectively. Built with a high-performance SQL engine, it handles large datasets instantly. Visualize your data with interactive Tree, Pivot, and Graph views, or export professional PDF and Excel reports for management meetings.
Features
- Real-time on-screen analysis with Tree and Pivot and Graph views.
- Dynamic bucket intervals (e.g., set aging days to 30, 45, 60 etc.)
- Advanced filtering by Warehouse, Internal Location, Product, or Category.
- Export Reports to Excel (XLSX) and PDF with detailed breakdown.
- SQL-Optimized High Performance for large inventory data (100k+ records).
Inventory Aging Menu
Easily access the Inventory Aging Report from the Reporting menu.
Wizard Configuration: Set Aging Date, Period, and Location Filters
Configure your report by selecting an aging date, defining the period length in days, and filtering by specific warehouses or locations.
Filter by Product Category or Products for Focused Analysis
Refine your report by filtering for specific product categories or individual products to focus on relevant inventory data.
Export Options: View On-Screen, Print PDF, or Export Excel
Choose to view the report directly on screen, generate a printable PDF, or export to Excel for further processing.
Detailed On-Screen Analysis with Dynamic Aging Buckets
Analyze your inventory with dynamic aging buckets directly on the screen, providing immediate insights into stock age.
Group By Product Category or Products or Warehouse
Easily group results by Product Category, Product, or Warehouse to organize and view data according to your needs.
Pivot View Analysis for Data Aggregation
Utilize pivot views to aggregate data, enabling powerful multi-dimensional analysis of your inventory aging.
Graph View for Visual Stock Age Representation
Visualize stock aging distribution clearly with graph views, making it easier to spot trends and issues.
Generated PDF Report
Produce clean, professional PDF reports ready for printing or sharing with management and stakeholders.
Excel Report Output in Spreadsheet Format
Download the full report in Excel format for further data manipulation, calculations, and custom reporting.
Inventory Coverage Analysis Report
The Inventory Coverage Analysis Report in
Odoo is a critical tool for maintaining optimal
inventory levels. It calculates how long your
current stock will last based on historical
consumption (Average Daily Sales - ADS) or valid
static coverage days.
By identifying Critical (Stockout risk),
Risk (Low coverage), Healthy, and
Overstock items, businesses can make
data-driven purchasing decisions, optimize working
capital, and prevent lost sales. The module
features a comprehensive Dashboard,
detailed Coverage Analysis Data,
Historical Snapshots for trend analysis,
and specialized views for Critical,
Overstock, and Risk products.
Analyze your inventory data effectively with
on-screen List View and
Pivot View for dynamic multidimensional
analysis. Generate professional PDF reports
for meetings and detailed Excel exports for
offline data crunching. This module provides deep
insights into your inventory health, financial
exposure, and reordering needs.
Features
- Smart Coverage Dashboard: A visual overview of inventory health, financial impact, and warehouse risk matrices.
- Dual Calculation Methods: Calculate coverage based on Average Daily Sales (ADS) or Static Coverage Days.
- Comprehensive Status Classification: Automatically categorizes items into Critical, Risk, Healthy, and Overstock segments.
- Deep Impact Analysis: Analyze Critical Products, Risk Products, and Overstock Products in dedicated views to prioritize actions.
- Historical Trend Analysis: Track Stock Value Trends and Status Trends over time with Historical Snapshots.
- Financial Metric Visualization: View Financial Impact graphs and Warehouse Risk Matrices to understand the monetary value at risk or in excess.
- Advanced Filtering & Reporting: Configure extensive filters (Company, Warehouse, Date Range), view report directly on screen to see List View and Pivot View analysis, and export to PDF, Excel Report.
Dashboard Menu
Easily access the Coverage Dashboard from the reporting menu in Odoo.
Executive Dashboard
A comprehensive dashboard giving a bird's-eye view of your inventory Health. Track All Products, identifying Critical, Risk, and Overstock items instantly. Monitor Total Stock Value, predict Stockouts in 7 Days, and analyze Coverage Health and Financial Impact. It also features a Warehouse Risk Matrix and quick lists for Top 10 Products to Reorder and Top 10 Overstocked Products.
Status Calculation & Value Metrics:
- Critical: Stock is 0 OR Coverage Days
- Risk: Coverage Days
- Overstock: Stock > Max Qty OR Coverage Days > 90 days. Highlights excess inventory tying up capital.
- Healthy: Inventory levels are balanced, falling between Risk and Overstock parameters.
- Stock Value: Calculated as Closing Stock × Unit Cost (from valuation layer), providing accurate financial valuation.
Key Dashboard Components:
- Coverage Health Chart: A donut chart visualising the percentage of inventory in each status (Critical, Risk, Healthy, Overstock) for quick health assessment.
- Financial Impact Chart: A bar chart breaking down the total monetary value held in each status, helping you prioritize high-value critical or overstocked items.
- Warehouse Risk Matrix: A heatmap-style pivot view showing the count of Critical and Risk items across different warehouses, allowing for targeted intervention.
- Top 10 Products to Reorder: An actionable list of the 10 most critical items needing immediate replenishment, sorted by lowest coverage.
- Top 10 Overstocked Products: A prioritized list of the top 10 items with the highest excess inventory value, ideal for clearance or promotion planning.
Report Wizard Menu
Accss the dedicated reporting wizard from the Reporting menu. This centralized hub allows you to generate new analysis reports, covering Multi-Company and Multi-Warehouse scenarios effortlessly.
Report Configuration
Configuring your report is simple yet powerful. Select specific Warehouses, Locations, or Product Categories to narrow down your analysis. Choose between ADS (Average Daily Sales) for consumption-based planning or Static Coverage Days for target-based stock levels. You can also toggle Internal Transfers to treat inter-warehouse moves as consumption.
On-Screen List View
Interact with your data directly in Odoo's List View. Sort by Coverage Days to find outliers, group by Coverage Status to batch-process reorders, and view color-coded lines indicating status health. This view supports standard Odoo searching and filtering.
Advanced Search & Filter
Utilize pre-built filters to isolate data for specific Vendors, Warehouses, or Product Categories. quickly switch between coverage statuses like "Show only Critical" or "Show only Overstock" to focus your workflow.
Pivot Analysis
Leverage the power of Odoo's Pivot view for multi-dimensional analysis. Drag and drop to analyze Total Stock Value by Category, Average Coverage Days by Warehouse, or compare consumption rates across different product lines.
Analysis Menus
Dedicated menus for deep dives: Coverage Data, Critical Products, Risk Products, Overstock Products, and Charts & Analysis.
Data & Visualization
Access a comprehensive list of all coverage data, which is also viewable as interactive Pivot tables and Graphs.
Critical Products View
A fast-track view for urgent procurement actions. This list filters specifically for items where Stock is Zero or Coverage is less than Vendor Lead Time. Use this to immediately generate Request for Quotations (RFQs) and prevent stockouts.
Overstock Products View
Identify capital trapped in excess inventory. This view highlights products exceeding maximum stock limits or 90+ days of coverage. Perfect for planning Clearance Sales or adjusting future purchase orders to optimize cash flow.
Health Distribution
Visualise the overall health of your inventory with intuitive graphs. See the proportion of your stock that is Healthy vs. at Risk. This macro-level view is essential for management reporting and KPI tracking.
Financial Impact
Go beyond quantities and see the Money involved. This graph breaks down inventory value by status, showing you exactly how much capital is tied up in "Overstock" (opportunity for cash release) vs. "Critical" (risk of lost revenue).
Warehouse Risk Matrix
A powerful comparison tool for multi-warehouse operations. This view highlights which warehouses are holding the most Critical or Overstock items, helping you balance inventory through internal transfers.
Historical Snapshots
Automatically create Daily, Weekly, or Monthly snapshots via Scheduled Actions to track past data. An auto-delete scheduler ensures meaningful data retention by removing snapshots older than 365 days.
Snapshot Data
View and filter through all recorded historical snapshots to compare past performance.
Stock Value Trend
Graph view showing how stock value and investment has evolved over time. This trend analysis supports specific deep-dives using Pivot View and List View.
Status Trend Analysis
Analyze how inventory status categories (Critical, Healthy, etc.) shift over time to measure improvement.
Professional PDF Report
Generate a comprehensive PDF report for easy sharing and offline analysis.
Excel Export
Export the complete dataset to Excel, including all calculated metrics and classifications.
Granular Data in Excel
The Excel report includes granular level data for deep-dive analysis and custom reporting.
Inventory FSN Analysis Report
The Inventory FSN Analysis Report is a
professional inventory classification tool
designed for Inventory Managers and Supply Chain
Heads. It segments stock items into
Fast Moving (F), Slow Moving (S),
and Non-Moving (N) categories based on
their consumption patterns and turnover ratios.
This module helps businesses
Optimize Inventory Investment by
identifying dead stock,
Improve Warehouse Efficiency by
prioritizing fast-moving items, and make
data-driven Procurement Decisions. You can
configure custom thresholds for Fast and Slow
categories, filter by Warehouse or Products or
Category, and view detailed analysis On-Screen or
export to
PDF
and Excel.
Features
- Multi-Format Output: Analyze data interactively on screen with List and Pivot views, or download professional PDF and Excel reports.
- Smart Classification: Automatically categorizes products into Fast, Slow, or Non-Moving based on configurable Turnover Ratio thresholds.
- Advanced Filtering: Filter analysis by Company, Warehouse, Location, Product, and Category. Option to include Zero Stock items.
- Comprehensive Metrics: View Opening/Closing Stock, Incoming/Outgoing quantities, Sales, Turnover Ratio, and Days Since Last Movement.
- Identify Dead Stock: Easily spot Non-Moving items (N) to take corrective actions and free up working capital.
Menu Access
Easily access the FSN Analysis Report wizard under the Inventory > Reporting menu.
Configuration Wizard
Configure the report with flexible options: Select Date Range, Company, Warehouse, Location, and filter by Products or Categories. Set custom thresholds for Fast Moving and Slow Moving items, and choose to include Zero Stock items.
Action Buttons
Generate reports instantly with dedicated buttons: View Report on Screen, Print PDF, or Export to Excel.
On-Screen List Analysis
Analyze item-level details in a list view, displaying Turnover Ratio, FSN Category, and Days Since Last Movement.
Advanced Search & Filtering
Utilize advanced search and Group By options to organize data by FSN Category, Warehouse, or Product Category.
Pivot View Analysis
Perform multidimensional analysis using the Pivot view to visualize stock distribution and value across different FSN categories.
Formatted PDF Report
Download a professional, printable PDF report containing summary statistics and detailed product classification.
Excel Export
Export the complete dataset to standard Excel format for further external processing and analysis.
Inventory Out of Stock Analysis Report
The
Inventory Out of Stock Analysis Report
application is a critical tool for Inventory
Managers and Supply Chain Heads to proactively
manage stock levels. It helps businesses identify
products that are Currently Out of Stock,
At Risk of running out, or
In Stock based on real-time sales velocity
and defined planning horizons.
With this module, you can perform advanced
analysis using parameters like
Stock Analysis Horizon and
Sales History dates. It calculates key
metrics such as Average Daily Sales (ADS),
Projected Demanded Quantity, and
Stock Value at Risk. You can filter by
Warehouse, Location, Category, or Product, and
view the results in interactive List and Pivot
views, or export them to PDF and
Excel for offline meetings and analysis.
Features
- Multi-Format Output: View interactive reports On-Screen (Tree/Pivot), or export to professional PDF and Excel formats.
- Stock Status Classification: Automatically segments products into 'Out of Stock' (Red), 'At Risk' (Orange), and 'In Stock' (Green).
- Sales Velocity Analysis: Calculates Average Daily Sales (ADS) based on historical date ranges to project future demand.
- Risk Assessment: Identifies 'Stock Value at Risk' and 'Out-of-Stock Days' to prioritize replenishment.
- Comprehensive Filtering: Filter by Company, Warehouse, Location, Product, and Category. Option to include items with Zero Sales.
Menu Access
Conveniently access the Out of Stock Analysis Report wizard directly from the Inventory > Reporting menu.
Configuration Wizard
Set powerful filtering options: Define the Date Range for sales history, set the Stock Analysis Horizon (days), and select specific Companies, Warehouses, and Locations. Drill down by selecting Products or Categories, and choose to view All Products, Out of Stock only, At Risk only, or Critical items.
Action Buttons
Generate your report with a single click: View interactive analysis directly On Screen, download a formatted PDF Report, or export data to Excel.
On-Screen List Analysis
View detailed metrics in a list format, including ADS, Demanded Quantity, Days coverage, and color-coded Stock Status.
Advanced Search & Filtering
Use the search bar to find specific items and apply Group By filters to aggregate data by Category, Stock Status, or Warehouse.
Pivot View Analysis
Perform multidimensional analysis using the Pivot view to analyze trends, totals, and stock distribution across categories and statuses.
Formatted PDF Report
Generate a clean, professional PDF report ideal for printing and sharing with stakeholders.
Excel Export
Export full dataset to Excel with formatting for further custom analysis and integration with external tools.
Inventory Turnover Analysis Report
The
Inventory Turnover Analysis Report
application is a powerful yet easy-to-use tool
designed to calculate and analyze your
Inventory Turnover Ratio and
Days Inventory Outstanding (DIO). It helps
businesses understand how efficiently they are
managing their stock by automatically classifying
items as
Fast, Normal, Slow, or Dead stock based on
their movement history.
With this module, you can easily filter your
analysis by selecting specific
Products or Product Categories, as well as
by Warehouse, Location, or Company. It features a
comprehensive On-Screen Analysis view,
allowing you to review detailed metrics directly
in Odoo without downloading files. For sharing and
external use, you can also generate professional
PDF Reports or export the data to
Excel with a single click.
Features
- Turnover Calculation: Industry-standard formula (COGS / Average Inventory) to measure stock efficiency.
- Stock Classification: Automatic segmentation into Fast Moving (>8), Normal (4-8), Slow (1-4), and Dead Stock (<1).
- Days Inventory Outstanding (DIO): Calculates the average number of days it takes to sell the entire inventory.
- Multi-Format Output: View interactive reports On-Screen (Tree/Pivot), or export to professional PDF and Excel formats.
- Dynamic Filtering: Filter by Date Range, Company, Warehouse, Internal Location, Product, and Category. Include/Exclude Zero Movement items.
Menu Access
Easy access to the Inventory Turnover Analysis wizard from the Reporting menu.
Report Configuration
Configure your analysis parameters: Select Date Range, filter by specific Companies, Warehouses, or Locations. Drill down to specific Products or Categories, and choose whether to include products with zero movement.
Generation Options
Choose your desired output format: View the interactive report on screen, generate a printable PDF, or export detailed data to Excel.
On-Screen Analysis (List View)
Detailed list view showing Opening/Closing quantities and values, COGS, Turnover Ratio, DIO, and automatic Stock Status classification (Fast/Slow/Dead).
Advanced Search & Grouping
Use the powerful search bar to filter results or Group By Category, Status, or Warehouse for aggregated insights.
Pivot Analysis
Analyze trends and totals using the dynamic Pivot view. Perfect for high-level management review of inventory performance across categories.
Professional PDF Report
Clean, formatted PDF output suitable for printing and sharing with stakeholders.
Excel Export
Full data export to Excel for custom calculations and integration with other financial tools.
Inventory XYZ Analysis Report
The Inventory XYZ Analysis Report in Odoo
is a complete inventory classification tool that
combines three methods: ABC (Value),
XYZ (Demand Pattern), and
FSN (Movement Speed).
This report helps businesses analyze demand
changes using the
Coefficient of Variation and classify
products as X (Stable Demand),
Y (Moderate Demand Changes), or
Z (Irregular Demand). These results can be
combined with ABC and FSN classifications to
easily identify important product groups, such as
high-value products with irregular demand.
The tool supports useful filters like negative
stock and zero stock, allows users to set custom
limits for all classifications, and provides clear
analysis through List View,
Pivot View, and Graph View. It also
includes detailed PDF and
Excel reports, with access to raw data for
deeper analysis.
Features
- 3-in-1 Classification: Perform ABC (Value), XYZ (Variability), and FSN (Frequency) analysis simultaneously in a single report.
- Advanced Visualizations: Analyze data effectively with dynamic list and Graph and Pivot views directly on the screen.
- Precise Segmentation: Filter results by specific classes (e.g., select only "A" class and "Z" class items) to target specific inventory problems.
- Customizable Logic: Configure detailed settings including custom thresholds for all classifications, inclusion of negative/zero stock, and sorting options.
- Professional Reporting: Generate detailed PDF reports with summary classifications and comprehensive Excel exports with raw movement data option.
Menu Location
Easily find the XYZ analysis tool in Odoo under the Inventory > Reporting menu options.
General Configuration
Define the scope of your report by selecting Date Range, Company, Products, Categories, Warehouses, and Locations. If left blank, it automatically includes all.
Classification Settings
Customize your analysis: Toggle ABC, XYZ, and FSN methods. Apply specific filters to isolate classes (e.g., only "A" or "Z" items) and configure precise threshold percentages for each classification logic.
Advanced Options
Refine data inclusion: Filter for Minimum Stock Balance, Negative Stocks, or Zero Balance items. Configure Sorting and Grouping preferences, and choose to include Raw Movement data in Excel exports.
On-Screen List View
View detailed analysis results directly on the screen in a list format, displaying item-specific metrics and classifications.
Smart Search & Filtering
Use the powerful Search View to filter and group your analysis results by various criteria like Classifications, Categories, or Suppliers.
Pivot Table Analysis
Perform multidimensional data analysis with the Pivot View to uncover trends across different inventory segments.
Graph Visualization
Visualize your inventory distribution and classification impact with dynamic Graph Views.
Professional PDF Report
Generate a comprehensive PDF report that presents detailed inventory analysis in a clean, printable format.
PDF Classification Summary
The PDF report includes a clear Classification Summary section, giving you a quick overview of your inventory mix.
Detailed Excel Export
Export the full dataset to Excel for further manipulation, showing comprehensive product details and calculated metrics.
Comprehensive Data Columns
The Excel export covers all key analysis fields.
Excel Classification Summary
Review the Classification Summary table directly within the exported Excel file for quick insights.
View Report Results
Easily access and review previously generated report results at any time from the dedicated menu in Odoo.
Stock Card Report
The Stock Card Report app is an essential tool for tracking the complete history of your inventory. It provides a detailed Stock Card / Product Card view, showing Opening Balances, In/Out movements, and Closing Balances for any date range. Features include support for Standard and Average Costing, dynamic filtering by Product, Category, and Location (including child locations), and grouping options. Generate professional PDF and Excel reports or analyze data directly on-screen with valid running balances.
Features
- Opening & Closing Balances: Accurate calculation of stock balances for any selected period.
- Unit Cost Support: Handles Standard Price and Average Costing valuations.
- Multi-Location Support: Filter by Location.
- Flexible Filtering: Filter by specific Products or Product Categories.
- Multi-Format Output: Export to PDF, Excel, or view On-Screen (Tree View and Pivot View).
- Group By Options: Organize report data by Category or Product.
Reporting Menu Access
Navigate to Reporting > Stock Card Report to open the report generation wizard.
All-In-One Configuration Wizard
Configure all report parameters in one screen: Select Date Range, Location/Company, Filter by Product/Category, apply Grouping, and toggle 'Include Zero Movements'.
Multiple Report Options
Choose your preferred output format with dedicated buttons: View On Screen for instant analysis, Print PDF for documentation, or Print Excel for spreadsheet work.
On-Screen Stock Card Analysis
Instantly view the generated Stock Card data in a dynamic Tree view, showing Opening, In, Out, and Closing balances calculated in real-time.
Search & Filter Analysis Details
Use the search bar and advanced filters to quickly locate specific products, categories, or transactions within the on-screen report results.
Pivot View Analysis
Switch to Pivot view for multi-dimensional analysis of stock movements, values, and costs across locations or categories.
PDF Report
The generated PDF is automatically organized based on your configuration. It prints page-by-page breakdowns grouped by Product or Product Category, ensuring clear and structured documentation.
Excel Report Output
Generate a detailed Excel report (.xlsx) for precise data analysis. The export includes all transaction details, quantities, and values, formatted ready for spreadsheet operations.
Stock Inventory Valuation Report
The Stock Inventory Valuation Report app is an audit-ready solution designed to validate your inventory value with precision. Unlike standard stock reports, this module reconstructs the inventory equation (Opening Stock + Purchases - Sales + Adjustments = Closing Stock) for any given period, ensuring mathematical accuracy and traceability. It sources data directly from Odoo's stock moves and valuation layers to provide a "single source of truth" for financial reconciliation. Whether you need a detailed product-by-product audit, a category-level executive summary, or a quick Excel export for external analysis, this tool delivers consistent results across all formats (Screen, PDF, Excel).
Features
- Proves the Closing Balance by calculating: Opening + In - Out + Adjustments.
- Accurate retroactive valuation for any past date, respecting Standard, AVCO, and FIFO methods.
- Drill down by Date Range, specific Product, Product Category, Warehouse, or Location.
- Switch between 'Detailed' for every product, 'Summary' for category totals, or 'Grand Total' only.
- Multi-Format Output: One-click generation for professional PDF reports, Excel spreadsheets, or interactive On-Screen views.
- Toggle display of Zero Quantity items, Internal Transfers, Adjustments, and choose between Signed or Absolute quantities.
Easy Menu Access
Accessible directly from Inventory > Reporting > Stock Inventory Valuation Report. This dedicated menu entry opens the wizard, ready for your configuration.
Comprehensive Data Filtering
Define the scope of your report with precision. Select a custom Date Range (From/To) to analyze specific periods. Filter data by selecting specific Warehouses or individual Locations. You can also narrow down results to a single Product or an entire Product Category.
Configuration: Mode & Method
Tailor the report output to your needs. Choose a Valuation Method (Standard, Average, FIFO) to check costs. Select a Report Mode: 'Detailed' for granular data, 'Summary' for category totals, or 'Grand Total' for a quick bottom line. Customize the Quantity Display to show Signed (ERP style) or Absolute values.
Display Options & Generation Actions
Fine-tune the content: Show Zero Quantity to include out-of-stock items, Include Adjustments for inventory corrections, and Include Internal Transfers or exclude them. Finally, use the action buttons to View on Screen, Print PDF, or Export to Excel.
Interactive On-Screen Analysis
Instantly analyze valuation data in a dynamic List View. The screen clearly displays primary columns: product details, Opening Quantity/Value, Purchase Inflow, Sales Outflow, Adjustment corrections, and the final Closing Quantity/Value.
Extended Analysis Columns
Reveal deeper insights by enabling optional columns. View the computed Unit Cost, separate Adjustment Values, specific Internal Transfer quantities, and even FIFO Remaining quantities and values for advanced costing analysis.
Search, Filter & Group Data
Leverage Odoo's powerful search bar on the report results. Quickly find specific products or apply Group By options like 'Category' to organize the list view for better readability and structural analysis.
Professional PDF Report
Generate a clean, formatted PDF report. The report header shows the selected filter criteria and the beginning of the data table.
Export to Excel
Download the complete dataset as an .xlsx file. Perfect for external auditors or financial teams who need to perform custom formulas, pivot tables, or further data manipulation.
Stock Rotation Report in Odoo
Stock Rotation Report is a production‑ready Odoo module that analyzes inventory movements and stock rotation metrics. It provides powerful filters such as date range, company, warehouse, location, product, category, and lot/serial numbers. The report can be viewed on screen, exported as PDF (QWeb), or downloaded in Excel (XLSX) format. It calculates opening and closing stock, purchases, sales, transfers, adjustments, production moves, returns, and the inventory turnover ratio . The module is multi‑company aware, respects unit‑of‑measure rounding, and is optimized for large datasets using SQL aggregation and caching.
Features
- Detailed inventory movement & stock rotation metrics (opening/closing stock, purchases, sales, transfers, adjustments).
- Flexible filters: date range, company, warehouse, location, product, category, lot/serial and expiry.
- Multiple outputs: interactive screen preview, PDF (QWeb) and Excel (XLSX) export.
- Inventory turnover ratio, multi-company support and performance-optimized SQL aggregation with caching.
Inventory >> Reporting >> Stock Rotation Report
In the report form, you can set filters such as date range, company, warehouse, location, product, lot/serial number, and expiry, and display options. You can also preview the report and download it in Excel, PDF, or CSV format.
If the report filters do not match any data, it shows a validation message.
This is the Stock Rotation / Inventory Movement report; it shows the preview.
You can also download the Excel report.
PDF Report
Here, the PDF report also shows a preview.
CSV Report
Version 1.0 | Released on : 13th February 2024
-
Is this app compatible with Odoo Enterprise?
- Yes, our app works with Odoo Enterprise as well as Community.
-
If need of customization in this app, How can i contact
?
- Please contact us on odoo@devintellecs.com
-
Do i get free support?
- Yes, you will get free support for 90days.
-
Do i get free updates?
- Yes, you will get free updates for lifetime.
-
Do i have to buy this module for each version ?
- Yes, you have to buy this module for each version.
Support
Why Us?
You May Also Like
Most Demandend Apps
Devintelle Odoo Services
Connect Us
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module