Idle Stock Tracker (تقرير المخزون الراكد) by LucidBrainz is a powerful inventory optimization solution for Odoo 18 that automatically identifies and tracks idle, stagnant, and dead stock across your warehouse locations, product categories, and multiple branches. Say goodbye to manual spreadsheet tracking and guesswork! This intelligent module helps you pinpoint products with zero movement during specified date ranges, track inventory by specific locations, filter by product categories, and generate professional Excel reports with bilingual headers (Arabic/English) for actionable insights. Perfect for warehouse managers, inventory controllers, supply chain professionals, multi-branch retail operations, manufacturing companies, distribution centers, e-commerce businesses, and any organization struggling with excess inventory, slow-moving stock, obsolete products, or cash flow tied up in dead inventory. The module features location-based tracking checkboxes, category-based filtering, intelligent stock movement analysis, multi-branch support with branch selection, flexible date range filtering, automatic idle stock detection algorithms, Excel report generation with Arabic title and headers, real-time on-hand quantity display, product code/barcode integration, and full category hierarchy display. It intelligently identifies three critical categories of idle inventory: (1) Products that moved during the period but NOT to tracked locations, (2) Products that moved to tracked locations but OUTSIDE the selected date range (before or after), and (3) Products with absolutely zero stock movements ever recorded but belong to tracked categories. The system gives you complete control through simple checkbox configurations on warehouse locations ("Track Stock Location") and product categories ("Track Product Category Location"), allowing you to focus analysis on critical inventory areas while ignoring irrelevant stock. When you generate a report, the module automatically compiles all idle products showing current on-hand quantities, product names, barcodes/internal codes, and full category paths, presenting everything in a beautifully formatted Excel spreadsheet with bilingual Arabic/English headers ("تقرير المخزون الراكد"), color-coded yellow headers, bordered cells, proper column widths, and date/branch information at the top. Ideal for businesses that want to reduce carrying costs by 30-40%, free up warehouse space, identify clearance sale opportunities, prevent stock obsolescence, improve cash flow, optimize purchasing decisions, reduce write-offs, plan promotional campaigns, and make data-driven inventory management decisions across multiple branches!

• Location Tracking Checkbox: Simple "Track Stock Location" checkbox on stock location form (appears after Replenish Location field). Enable tracking for critical warehouse locations like main stock, retail stores, or specific zones
• Category Tracking Checkbox: "Track Product Category Location" checkbox on product category form. Monitor specific categories (e.g., Electronics, Furniture, Saleable items) while ignoring irrelevant categories
• Multi-Branch Selection: Dropdown to select specific branch for idle stock analysis. Perfect for companies with multiple warehouses, distribution centers, retail stores, or regional offices across different cities
• Flexible Date Range: "Date From" and "Date To" datetime fields to analyze idle stock for any period (last week, last month, last quarter, custom range). Automatic validation prevents Date To being before Date From
• Excel & PDF Options: Report Type selection with radio buttons for XLS (Excel) or PDF format. Excel report is fully implemented with professional formatting. Instant download with one click on "Print Excel Sheet" button
• Intelligent Idle Detection: Three-layer algorithm identifies: (1) Products that moved but not to tracked locations, (2) Products that moved to tracked locations outside selected dates, (3) Products with zero movements ever
• Stock Move Analysis: Searches all stock.move records filtered by tracked product categories, tracked destination locations, branch locations, and creation dates. Uses efficient domain filters and lambda functions
• Smart Filtering Logic: Automatically filters movements: date range filtering (m.create_date >= date_from and
• Bilingual Excel Report: Report title in Arabic "تقرير المخزون الراكد" (Idle Stock Report) with 36px large font, centered, bold. Headers support both Arabic and English. Professional formatting for Middle East businesses
• Professional Excel Formatting: Yellow highlighted header cells (bg_color: yellow), bordered cells (border: 2), centered text alignment, custom column widths (A:A 40px, B:E 20px), merged title cells across columns
• Comprehensive Data Table: Report includes: Product Name (full name from product.product), Code (barcode or internal reference), On Hand (qty_available - real-time quantity), Category (full hierarchy display_name)
• Report Metadata: Top section shows: Date From (formatted datetime), Date To (formatted datetime), Branch Name (from res.branch), all displayed in yellow highlighted cells with proper labels
• Product Set Operations: Uses Python set operations (| operator) to merge three product categories without duplicates: not_stock_move_product | untracked_products | outer_products
• Zero Movement Detection: Identifies products where stock_move_ids = False (no movements at all) but categ_id.track_product_categ = True. Perfect for finding new/imported items never moved
• Movement Exclusion: Automatically excludes products that DID move to tracked locations during the selected period. Shows only truly idle/stagnant inventory that needs attention
• Historical Movement Analysis: "Outer moves" detection finds products moved to tracked locations before date_from or after date_to. Helps identify seasonal patterns or recently stocked items
• Real-Time Quantities: Displays current on-hand quantities (qty_available) at report generation time, not historical data. Shows actual stock levels that need clearance or attention
• Product Code Display: Shows product barcode field or internal reference in Code column. Easy product identification for warehouse staff, making physical inventory checks simple
• Full Category Hierarchy: Uses categ_id.display_name to show complete category path (e.g., "All / Saleable / Outdoor furniture"). Provides context for inventory decisions
• Easy Access Menu: Located at Reports → Inventory → Idle Stock Report. Seamlessly integrated into Odoo's reporting structure under Inventory submenu for quick access
• Simple Wizard Interface: Clean popup form with just 4 fields: Date From, Date To, Branch dropdown, Report Type radio buttons. Fill details and click "Print Excel Sheet" - report generates instantly
• Date Validation: @api.constrains decorator validates Date To must be after Date From. Raises ValidationError('Date From Must Not Be Before Date To') preventing incorrect reports
• Instant Download: Report generates and downloads immediately as XLSX file with filename format. No background processing, no waiting - immediate Excel file ready to analyze
• Model Inheritance: Extends stock.location (adds track_stock_loc boolean), product.category (adds track_product_categ boolean). Clean inheritance without modifying core Odoo models
• Abstract Report Model: Uses report.report_xlsx.abstract inheritance for XLSX generation. Implements _get_report_values() and generate_xlsx_report() methods following Odoo report patterns
• TransientModel Wizard: idle.stock.report uses TransientModel (temporary data automatically cleaned after generation). Keeps database clean without storing wizard records permanently
• Clean Code Architecture: Well-organized module structure with separate models/, wizard/, report/, views/ folders. Proper Python inheritance, descriptive variable names, clear logic flow
• XLWT Library Integration: Uses xlwt Python library for Excel generation with features: workbook.add_worksheet(), workbook.add_format(), sheet.write(), sheet.merge_range(), sheet.set_column()
• Configuration Views: XML views for stock.location form (inherit_id: stock.view_location_form), product.category form (inherit_id: product.product_category_form_view). Checkboxes positioned logically after related fields