{"id":34926,"date":"2025-12-09T09:08:23","date_gmt":"2025-12-09T09:08:23","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=34926"},"modified":"2025-12-11T05:03:14","modified_gmt":"2025-12-11T05:03:14","slug":"how-to-filter-search-and-group-the-lot-serial-number-master-data-in-odoo-inventory","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/master\/how-to-filter-search-and-group-the-lot-serial-number-master-data-in-odoo-inventory\/","title":{"rendered":"How to Filter, Search and Group the Lot\/Serial Number Master Data in Odoo Inventory"},"content":{"rendered":"\n<p>Managing lot and serial numbers is important for tracking products, monitoring stock movements, and maintaining accurate inventory records. In Odoo Inventory, the Lot\/Serial Number Master provides a clear view of all lot and serial numbers along with product details, creation dates, and stock information. With powerful search, filter and grouping tools, it becomes easy to review and analyze your inventory data efficiently.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Accessing the Lot\/Serial Numbers Master in Odoo Inventory<\/strong><\/h2>\n\n\n\n<p>To open the Lot\/Serial Numbers, go to the <strong>Inventory<\/strong> module from your dashboard. Then click on <strong>Products<\/strong> and select <strong>Lot\/Serial Numbers<\/strong>. This screen provides an overview of all lots and serial numbers created in your system.<\/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-Lot-and-Serial-Numbers-Screen--1024x527.png\" alt=\"Odoo Inventory Lot and Serial Numbers Screen \" class=\"wp-image-34927\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Screen--1024x527.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Screen--300x154.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Screen--768x395.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Screen--1536x790.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Screen-.png 1844w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>By default, the Lot\/Serial Numbers Master is grouped by <strong>Product<\/strong>, allowing you to see lot and serial numbers organized under their respective products.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Using the Search Bar in the Lot\/Serial Numbers Master<\/strong><\/h2>\n\n\n\n<p>The search bar allows you to quickly locate specific lots or serial numbers. You can search using the <strong>Lot\/Serial Number<\/strong>, <strong>Product Name<\/strong> or <strong>Product Code<\/strong>. You can also search by the <strong>Created On<\/strong> date if you want to focus on lots created within a specific time frame.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"353\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Search--1024x353.png\" alt=\"Odoo Inventory Lot and Serial Numbers Search \" class=\"wp-image-34928\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Search--1024x353.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Search--300x103.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Search--768x265.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Search--1536x530.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Search-.png 1841w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>These search options help you find the exact record without scrolling through the entire details of the Lot\/Serial Numbers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Using the Filter Options in the Lot\/Serial Numbers Master<\/strong><\/h2>\n\n\n\n<p>Filters make it easier to view specific Lot or Serial Numbers. When you click the \u25bc drop down icon in the search bar, Odoo displays predefined filter options. For date-based filtering, you can select a <strong>Date <\/strong>Range<strong> <\/strong>to display lots created within a particular period such as the last three months, a specific quarter or even the last three years.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"265\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Filter--1024x265.png\" alt=\"Odoo Inventory Lot and Serial Numbers Filter \" class=\"wp-image-34929\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Filter--1024x265.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Filter--300x78.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Filter--768x199.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Filter--1536x397.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Filter-.png 1841w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You can also filter records based on stock status using options like <strong>On Hand<\/strong>, items currently <strong>With Customers<\/strong> or those approaching expiry using <strong>Expiration Alerts<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Applying Custom Filters<\/strong><\/h3>\n\n\n\n<p>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>On Hand Quantity<\/strong> or <strong>Location<\/strong> and apply an operator like contains or is equal to, greater than or less than 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=\"528\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Custom-Filter-1024x528.png\" alt=\"Odoo Inventory Lot and Serial Numbers Custom Filter\" class=\"wp-image-34930\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Custom-Filter-1024x528.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Custom-Filter-300x155.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Custom-Filter-768x396.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Custom-Filter-1536x792.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Custom-Filter.png 1841w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>After entering the required value and clicking <strong>Add<\/strong>, the system displays only the lot and serial number records that meet your selected conditions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Using Group By Options in the Lot\/Serial Number Report<\/strong><\/h2>\n\n\n\n<p>Grouping your data helps you understand inventory patterns more clearly. By clicking the \u25bc drop down icon in the search bar and opening the <strong>Group By<\/strong> section, you can organize data by <strong>Product<\/strong>, <strong>Location<\/strong> or <strong>Company<\/strong>. This allows you to see which products or warehouses have certain lots or serial numbers.<\/p>\n\n\n\n<p>You can also group by <strong>Creation Date<\/strong> to analyze inventory trends over time, with options like <strong>Year<\/strong>, <strong>Quarter<\/strong>, <strong>Month<\/strong>, <strong>Week<\/strong> or <strong>Day<\/strong>. These grouping options provide a structured way to review lot and serial number information.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Applying Custom Grouping Options<\/strong><\/h3>\n\n\n\n<p>For more advanced organization, Odoo lets you use custom grouping. Clicking <strong>Add Custom Group<\/strong> shows additional fields that can be used for grouping, such as <strong>Manufacture Date<\/strong>, <strong>IMEI 1 <\/strong>or any other relevant grouping option.<\/p>\n\n\n\n<p>Once a group is selected, Odoo arranges the data instantly based on your chosen field, providing a personalized view of your inventory and making it easier to analyze stock movements and lot-level performance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Saving Favorites for Quick Reuse<\/strong><\/h2>\n\n\n\n<p>Odoo allows you to save your search filters and grouping preferences for future use. To save your current 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=\"313\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Favorites-1024x313.png\" alt=\"Odoo Inventory Lot and Serial Numbers Favorites\" class=\"wp-image-34931\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Favorites-1024x313.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Favorites-300x92.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Favorites-768x234.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Favorites-1536x469.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Numbers-Favorites.png 1841w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Saved searches can be applied anytime with a single click, and unwanted filters can be removed using the delete (trash) icon. This feature makes repeated reporting faster and more convenient.<\/p>\n\n\n\n<p>By using these features in the Lot\/Serial Number Report, you gain clearer insights into your inventory, stock movements, and product traceability. This helps you make better, more informed decisions and manage your warehouse operations more efficiently.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Managing lot and serial numbers is important for tracking products, monitoring stock movements, and maintaining accurate inventory records. In Odoo [&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":[538],"tags":[731,730,99,447,729],"class_list":["post-34926","post","type-post","status-publish","format-standard","hentry","category-master","tag-filter","tag-group-by","tag-inventory","tag-lot-serial-number","tag-search"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34926","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=34926"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34926\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=34926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=34926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=34926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}