You can easily open the Stock Details report from the Odoo Inventory module.<\/p>\n\n\n\n
To access it, go toInventory \u2192 Reporting \u2192 Stock Details<\/strong>.<\/strong> The Stock Details report provides several filters to help you narrow down your data. You can filter products based on options like Available in POS<\/strong>, Can be Sold<\/strong>, Can be Purchased<\/strong>, Favourites<\/strong>, Warnings<\/strong>, Archived<\/strong>, Available Products<\/strong>, Negative Forecasted Quantity<\/strong>, and Negative Quantity<\/strong>.<\/p>\n\n\n\n For example, the \u201cAvailable in POS\u201d filter shows products that can be sold in the POS system, while \u201cNegative Quantity\u201d shows products where the stock level is below zero.<\/p>\n\n\n\n You can also group the report using fields such as Brand<\/strong>, Product Type<\/strong>, Product Category<\/strong>, and POS Product Category<\/strong>. These groupings help you organize the report based on your business needs. For instance, grouping by Product Type will display products under categories such as Consumable, Storable Product, and Service.<\/p>\n\n\n\n If you need extra filtering or grouping options, the system allows you to create Custom Filters<\/strong> and Custom Groups<\/strong> by selecting additional fields like Pricelist, Tax Amount, Active status, Alert Date, and more.<\/p>\n\n\n\n A Quick Search option is also available, where you can search products by Brand<\/strong> or Category<\/strong> directly without applying filters.<\/p>\n\n\n\n The report provides detailed information about each product. It shows the Product<\/strong> along with its code and name, as well as the Brand<\/strong> associated with it. Both the Master HSN<\/strong> and Branch HSN<\/strong> codes are displayed as defined in the product master.<\/p>\n\n\n\n The Barcodes<\/strong> field shows the product\u2019s EAN code for easy identification. Products are organized under Product Categories<\/strong>, which follow a four-level structure: Division, Department, Category, and Subcategory.<\/p>\n\n\n\n The report also displays the applicable Tax %<\/strong> for the product. Stock-related details include the Onhand<\/strong> quantity, which shows how much of the product is currently available, the Incoming<\/strong> quantity that represents items purchased and expected to arrive, and the Outgoing<\/strong> quantity indicating how much has been sold.<\/p>\n\n\n\n Forecasted:<\/strong> Predicts future demand, sales, and key performance indicators using historical data, market trends, and real-time business information.<\/p>\n\n\n\n The Export option allows users to download the Stock Details report in Excel format. Before exporting, users can apply filters, groupings, or search options to customize the data they want to download.<\/p>\n\n\n\n Once the desired view is ready, clicking the Export All \/ Export <\/strong>button will generate an Excel file based on the selected conditions.<\/p>\n\n\n\n The Stock Details report in Odoo Inventory helps users view complete information about all products stored in the warehouse. It […]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[634],"tags":[99,596,629],"class_list":["post-34000","post","type-post","status-publish","format-standard","hentry","category-reports","tag-inventory","tag-report","tag-stock-details-report"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34000","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/comments?post=34000"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34000\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=34000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=34000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=34000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Only users with the Inventory Manager<\/strong> role can view this report. Once the report is opened, it will display all the available product information in a single screen.<\/p>\n\n\n\n![\"\"](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Report-Stock-Details-Navigation-1024x273.png\")
<\/figure>\n\n\n\nUsing Filters, Grouping, and Search Options<\/strong><\/h2>\n\n\n\n
![\"\"](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Report-Stock-Details-Search-1024x475.png\")
<\/figure>\n\n\n\nUnderstanding the Fields in the Stock Details Report<\/strong><\/h2>\n\n\n\n
Formula: Forecasted = Onhand + Incoming \u2013 Outgoing<\/code><\/pre>\n\n\n\n![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Report-Stock-Details-Fields-1024x582.png\")
<\/figure>\n\n\n\nExporting the Stock Details Report<\/strong><\/h2>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Report-Stock-Details-Export-1-1024x177.png\")
<\/figure>\n\n\n\n![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Report-Stock-Details-Export-Data-1024x646.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"