{"id":33984,"date":"2025-11-26T11:33:21","date_gmt":"2025-11-26T11:33:21","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=33984"},"modified":"2025-12-11T04:52:14","modified_gmt":"2025-12-11T04:52:14","slug":"how-to-view-the-stock-valuation-report-in-odoo-inventory","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/reports\/how-to-view-the-stock-valuation-report-in-odoo-inventory\/","title":{"rendered":"How to View the Stock Valuation Report in Odoo Inventory"},"content":{"rendered":"\n

The Stock Valuation Report in Odoo is a useful tool for keeping track of your inventory. It shows all the stock movements, including what has been added, removed, transferred internally, or adjusted. This report also helps calculate the total value of your products and monitor stock levels over a specific period. By summarizing all transactions, it gives a clear view of inventory performance and ensures accurate reporting.<\/p>\n\n\n\n

Accessing the Stock Valuation Report<\/h2>\n\n\n\n

To open the Stock Valuation Report, go to Inventory Management > Reporting > Basic Reports > Stock Valuation Report<\/strong>. Only users with the Inventory Manager<\/strong> role can access this report. Once opened, the report allows you to see all stock movements, including incoming and outgoing stock, internal transfers, adjustments, and the total value of your inventory<\/p>\n\n\n\n

\"Odoo<\/figure>\n\n\n\n

Using the Quick Search and Filter<\/h2>\n\n\n\n

When generating the report, a Quick Search and Filter pop-up will appear. Certain fields are mandatory, including Product, Warehouse, From Date, and To Date<\/strong>. If any of these are left empty, the system will show a message specifying which field is missing. You also need to select the company<\/strong> to view stock for products located under that company.<\/p>\n\n\n\n

You can filter the report either by Product<\/strong> or Category<\/strong>. By default, the Product option is selected. If Product is chosen, you can select one or more products to include. If Category is selected, you can pick a product category to include all items within that category.<\/p>\n\n\n\n

You also need to choose a warehouse<\/strong> and a date range to define the period for which the report will be generated. The system provides options to print the report in Excel<\/strong> or view it in a tree format<\/strong> for a hierarchical view of stock details.<\/p>\n\n\n\n

\"Odoo<\/figure>\n\n\n\n
\"Odoo<\/figure>\n\n\n\n

Understanding the Fields in the Report<\/h2>\n\n\n\n

The Stock Valuation Report shows many details about your inventory. When using Tree View<\/strong>, the report displays the selected date range on the left and the warehouse location on the right. It lists products based on your chosen filter, along with product codes, names, department, category, sub-category, and brand.<\/p>\n\n\n\n

\"Odoo<\/figure>\n\n\n\n

The report also shows important stock information. Opening Stock<\/strong> is the quantity available at the start of the reporting period, and its value is calculated by multiplying the quantity by the product cost. Incoming Stock<\/strong> and Outgoing Stock<\/strong> display the quantities received and issued during the period, along with their calculated values. Internal Stock<\/strong> shows transfers between warehouses, and Adjustment Stock<\/strong> reflects any corrections made. Ending Stock<\/strong> shows the quantity available at the end of the period and its total value.<\/p>\n\n\n\n

    \u2022 Opening Stock Value = Opening Stock Quantity \u00d7 Cost PriceI\n    \u2022 Incoming Stock Value = Incoming Stock Quantity \u00d7 Cost Price\n    \u2022 Outgoing Stock Value = Outgoing Stock Quantity \u00d7 Cost Price\n    \u2022  Internal Stock Value = Internal Stock Quantity \u00d7 Cost Price\n    \u2022 Adjustment Stock Value = Adjustment Stock Quantity \u00d7 Cost Price\n    \u2022 Ending Stock Value = Ending Stock Quantity \u00d7 Cost Price<\/code><\/pre>\n\n\n\n
Generating and Viewing the Report in Excel<\/h2>\n\n\n\n
If you choose to print the report in Excel, all the fields from the tree view are included. The Excel report adds the Company<\/strong> field and renames the location field as Warehouse<\/strong>.<\/p>\n\n\n\n
The report in Excel is titled Inventory and Stock Valuation Report<\/strong>. This makes it easy to share or analyze stock data outside Odoo.<\/p>\n\n\n\n
\"Odoo<\/figure>\n","protected":false},"excerpt":{"rendered":"
The Stock Valuation Report in Odoo is a useful tool for keeping track of your inventory. It shows all the […]<\/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,626],"class_list":["post-33984","post","type-post","status-publish","format-standard","hentry","category-reports","tag-inventory","tag-report","tag-stock-valuation-report"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33984","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=33984"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33984\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=33984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=33984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=33984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}