{"id":34951,"date":"2025-12-09T10:28:21","date_gmt":"2025-12-09T10:28:21","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=34951"},"modified":"2025-12-11T05:03:10","modified_gmt":"2025-12-11T05:03:10","slug":"how-to-search-filter-and-group-the-grn-bill-details-report-in-odoo-invoicing","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/reports\/how-to-search-filter-and-group-the-grn-bill-details-report-in-odoo-invoicing\/","title":{"rendered":"How to Search, Filter and Group the GRN Bill Details Report in Odoo Invoicing"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The GRN Bill Details Report in Odoo Invoicing helps you easily track vendor bills created from Goods Received Notes. By using the search, filter and group options, you can quickly find the exact information you need.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Opening the GRN Bill Details Report<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To access the report, go to the main menu and open <strong>Invoicing<\/strong>. From there, click <strong>Reporting<\/strong>, then in <strong>Basic Reports<\/strong>, select <strong>GRN Bill Details<\/strong>. This will open the complete list of GRN related bills, which you can refine further using different tools.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Search Options in the Report<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The search bar allows you to quickly find records using important fields. You can type the <strong>GR Bill number, the vendor name, the vendor\u2019s bill number, or the purchase order number<\/strong>. You can also search by <strong>product name<\/strong>, <strong>HSN code<\/strong>, or the <strong>bill date<\/strong>. These search options help you directly jump to the information you want without scrolling through the full list.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Search-Options-in-the-GRN-Bill-Details-Report-1024x530.png\" alt=\"Odoo  Reports  Search Options in the GRN Bill Details Report\" class=\"wp-image-34986\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Search-Options-in-the-GRN-Bill-Details-Report-1024x530.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Search-Options-in-the-GRN-Bill-Details-Report-300x155.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Search-Options-in-the-GRN-Bill-Details-Report-768x398.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Search-Options-in-the-GRN-Bill-Details-Report-1536x796.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Search-Options-in-the-GRN-Bill-Details-Report.png 1830w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Applying Quick Search Options<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You can also use quick search fields in the report. Here, you can select a <strong>date range<\/strong> to view bills for a specific period, choose a <strong>product <\/strong>from the drop down list, or pick a particular <strong>vendor<\/strong>. You can also select a <strong>company<\/strong> if you work with multiple companies. Clicking the <strong>Search<\/strong> button will show the results immediately, and the <strong>Reset<\/strong> button clears all selections if you want to start again.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Quick-Search-Options-in-the-GRN-Bill-Details-Report-1024x530.png\" alt=\"Odoo Reports  Quick Search Options in the GRN Bill Details Report\" class=\"wp-image-34988\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Quick-Search-Options-in-the-GRN-Bill-Details-Report-1024x530.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Quick-Search-Options-in-the-GRN-Bill-Details-Report-300x155.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Quick-Search-Options-in-the-GRN-Bill-Details-Report-768x398.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Quick-Search-Options-in-the-GRN-Bill-Details-Report-1536x796.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Quick-Search-Options-in-the-GRN-Bill-Details-Report.png 1830w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Applying Filters for Detailed Results<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For more advanced searching, you can use filters available in the drop down beside the search bar. You can filter the report to show <strong>invoices, credit notes, posted bills, drafts, or cancelled bills<\/strong>. The <strong>bill date<\/strong> filter gives ready-to-use options like the last three months, quarterly views, and even the last three years. You can also choose a specific month, and the year will update automatically.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you need a more custom filter, you can add your own. When you click \u201c<strong>Add Custom Filter<\/strong>,\u201d a pop-up opens with options to choose the field, operation, and value. For example, you can filter by purchase order number and choose whether it should match exactly or just contain a certain text. After selecting the details, click <strong>Add<\/strong> to apply the filter.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Custom-Filter-in-the-GRN-Bill-Details-Report-1024x530.png\" alt=\"Odoo  Reports  Custom Filter in the GRN Bill Details Report\" class=\"wp-image-34990\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Custom-Filter-in-the-GRN-Bill-Details-Report-1024x530.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Custom-Filter-in-the-GRN-Bill-Details-Report-300x155.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Custom-Filter-in-the-GRN-Bill-Details-Report-768x398.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Custom-Filter-in-the-GRN-Bill-Details-Report-1536x796.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Custom-Filter-in-the-GRN-Bill-Details-Report.png 1830w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Grouping the Report for Better Analysis<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Grouping helps you organize the report in a meaningful way. By clicking the drop down in the search bar and selecting <strong>Group By<\/strong>, you can choose to group your data by <strong>GR Bill, vendor, company, purchase order number, or product<\/strong>. This makes it easier to compare related records.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can also group by <strong>bill date<\/strong>. Options include grouping by year, quarter, month, week, or day, depending on how detailed you want the report to be. If you want more grouping options, you can click \u201c<strong>Add Custom Group<\/strong>\u201d and choose from additional fields to organize the data in the way that suits your analysis.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Filter-and-Group-By-in-the-GRN-Bill-Details-Report-1024x530.png\" alt=\"Odoo  Reports  Filter and Group By in the GRN Bill Details Report\" class=\"wp-image-34992\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Filter-and-Group-By-in-the-GRN-Bill-Details-Report-1024x530.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Filter-and-Group-By-in-the-GRN-Bill-Details-Report-300x155.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Filter-and-Group-By-in-the-GRN-Bill-Details-Report-768x398.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Filter-and-Group-By-in-the-GRN-Bill-Details-Report-1536x796.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenth-Planet-Odoo-Reports-Filter-and-Group-By-in-the-GRN-Bill-Details-Report.png 1830w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The GRN Bill Details Report in Odoo Invoicing helps you easily track vendor bills created from Goods Received Notes. By [&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":[634],"tags":[731,606,730,508,729],"class_list":["post-34951","post","type-post","status-publish","format-standard","hentry","category-reports","tag-filter","tag-grn-bill-details-report","tag-group-by","tag-invoicing","tag-search"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34951","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=34951"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34951\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=34951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=34951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=34951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}