{"id":34952,"date":"2025-12-09T10:26:00","date_gmt":"2025-12-09T10:26:00","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=34952"},"modified":"2025-12-11T05:03:11","modified_gmt":"2025-12-11T05:03:11","slug":"how-to-filter-search-and-group-the-stock-location-report-data-in-odoo-inventory","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/inventory\/how-to-filter-search-and-group-the-stock-location-report-data-in-odoo-inventory\/","title":{"rendered":"How to Filter, Search and Group the Stock Location Report Data in Odoo Inventory"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Managing inventory becomes much easier when you know how to read and analyze stock reports. In Odoo Inventory, the Stock Location Report is one of the most helpful tools to understand where your products are stored and how much quantity is available. Different ways of filtering and grouping options make the Stock Location Report easy to understand and customize.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Accessing the Stock Location Report in Odoo Inventory<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To begin, navigate to <strong>Inventory <\/strong>module and click on<strong> Reporting<\/strong> under the<strong> Basic Reports<\/strong> select the <strong>Stock Location<\/strong>. This page gives you an overview of all products and their quantities across different warehouse locations.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"533\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Screen--1024x533.png\" alt=\"Odoo Inventory Stock Location Report Screen \" class=\"wp-image-34953\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Screen--1024x533.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Screen--300x156.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Screen--768x400.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Screen--1536x799.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Screen-.png 1855w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Quick Search Options in the Stock Location Report<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Stock Location Report offers quick search options to help you find information faster. You can search by <strong>warehouse<\/strong> to view stock stored in a specific location or search by <strong>product name <\/strong>or <strong>code.<\/strong> There is also an option to search by <strong>brand<\/strong> to filter products belonging to a particular brand. Additionally, if you work with multiple companies, you can search by <strong>company<\/strong> to view stock details for a specific business entity.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Quick-Search--1024x529.png\" alt=\"Odoo Inventory Stock Location Report Quick Search \" class=\"wp-image-34954\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Quick-Search--1024x529.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Quick-Search--300x155.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Quick-Search--768x397.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Quick-Search--1536x793.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Quick-Search-.png 1841w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After selecting your search choices, click <strong>Search<\/strong> to see the results. You can use one search option or combine several at the same time. If you want to remove all search options and start fresh, simply click the <strong>Reset<\/strong> button.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Using the Search Bar in the Stock Location Report<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The search bar helps you quickly find specific information in the report. You can search by <strong>product name <\/strong>or <strong>code<\/strong>, which makes it easy to locate any item. If you want to check stock in a particular area, search using the <strong>location name<\/strong> or <strong>warehouse name<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"325\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Search--1024x325.png\" alt=\"Odoo Inventory Stock Location Report Search \" class=\"wp-image-34955\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Search--1024x325.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Search--300x95.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Search--768x244.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Search--1536x488.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Search-.png 1855w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can also find items by searching the specific <strong>product category<\/strong> or by unique <strong>lot <\/strong>or <strong>serial numbers<\/strong>. This makes tracking items easier, especially if your inventory has many products.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Using Filters in the Stock Location Report<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You can narrow down the results using the filter options. When you click the small \u25bc dropdown icon in the search bar, you will find several helpful filters.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>Internal Location<\/strong> filter shows only the stock stored inside your company\u2019s warehouses, while the <strong>Transit Location<\/strong> filter displays items that are currently being moved from one place to another. To check products that are physically available, you can use the <strong>On Hand<\/strong> or <strong>In Stock<\/strong> filters.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"527\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Filter--1024x527.png\" alt=\"Odoo Inventory Stock Location Report Filter \" class=\"wp-image-34956\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Filter--1024x527.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Filter--300x154.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Filter--768x395.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Filter--1536x791.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Filter-.png 1855w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to identify items with stock shortages, the <strong>Negative Stock<\/strong> filter will highlight all products with quantities below zero. You can also filter by <strong>Incoming Date<\/strong>, which allows you to view products arrived within a selected date range whether by month, year or quarter. Additionally, the <strong>Starred Products<\/strong> option displays the items marked as favorites in the product master.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Applying Custom Filters<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you want more precise control,Odoo allows you to create your own custom filters. When you click <strong>Add Custom Filter<\/strong>, a popup window appears with a default rule that you can adjust. This lets you choose a field such as <strong>Product <\/strong>or <strong>Product Brand<\/strong> and apply an operator like contains, is equal to, does not contain, etc,.. and enter the value you want.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"520\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Custom-Filter--1024x520.png\" alt=\"Odoo Inventory Stock Location Report Custom Filter \" class=\"wp-image-34958\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Custom-Filter--1024x520.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Custom-Filter--300x152.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Custom-Filter--768x390.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Custom-Filter--1536x780.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Custom-Filter-.png 1841w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After entering the required value and clicking <strong>Add<\/strong>, the report updates instantly and displays a personalized and focused view of your stock information.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Using Group By Options in the Stock Location Report<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>Group By<\/strong> options in the Stock Location Report help you organise your data in a clearer and more meaningful way. By clicking the <strong>\u25bc <\/strong>drop down icon in the search bar, you will find several helpful group by options that you can choose how you want the information to be grouped.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Grouping by <strong>Location<\/strong> shows you the quantities stored in each specific area, making it easier to understand stock distribution inside or outside your warehouses. If your system handles multiple companies, grouping by <strong>Company<\/strong> helps you separate and analyze stock for each business entity.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"527\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Group-By--1024x527.png\" alt=\"Odoo Inventory Stock Location Report Group By \" class=\"wp-image-34959\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Group-By--1024x527.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Group-By--300x154.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Group-By--768x395.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Group-By--1536x791.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Group-By-.png 1855w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>Product<\/strong> grouping option lets you view the total quantity of each item across all locations, giving you a complete picture of product availability. You can also group by <strong>Lot\/Serial Number<\/strong> to see how products are tracked individually. These grouping options make it simple to compare, analyze, and manage your stock data efficiently.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Applying Custom Grouping Options<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you need more grouping options, clicking <strong>Add Custom Group<\/strong> shows additional fields that you can use. You can select fields such as <strong>Product Category <\/strong>or any other relevant field to structure the report according to your analysis needs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once a group is selected, the system instantly arranges the data based on that field, providing a personalized and more meaningful view of your stock information.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Saving Favorites for Quick Reuse<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Odoo allows you to save your search filters or grouping options for future use. To save your current search settings, open the drop down menu and select <strong>Save Current Search<\/strong>. You can name your saved filter, set it as the default view or share it with other users.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"349\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Favourites--1024x349.png\" alt=\"Odoo Inventory Stock Location Report Favorites \" class=\"wp-image-34962\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Favourites--1024x349.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Favourites--300x102.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Favourites--768x262.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Favourites--1536x524.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Stock-Location-Report-Favourites-.png 1841w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Saved filters can be reused anytime with one click, and they can be removed easily using the delete (trash) icon. This makes repeated reporting tasks faster and more convenient.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By using these features in the <strong>Stock Location Report<\/strong>, you can quickly find the exact information you need and analyze your stock more effectively.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Managing inventory becomes much easier when you know how to read and analyze stock reports. In Odoo Inventory, the Stock [&hellip;]<\/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":[382],"tags":[731,730,99,729,643],"class_list":["post-34952","post","type-post","status-publish","format-standard","hentry","category-inventory","tag-filter","tag-group-by","tag-inventory","tag-search","tag-stock-location-report"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34952","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=34952"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34952\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=34952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=34952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=34952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}