How to Filter, Search and Group the GRN Bill Report Data in Odoo Invoicing

In Odoo Invoicing, the GRN Bill Report gives you a clear view of all goods received along with vendor details, bill numbers, purchase orders and bill dates. With powerful search, filter, and grouping tools, it becomes easy to review and analyze your purchase activities.

Accessing the GRN Bill Report in Odoo Invoicing

To open the GRN Bill Report, go to the Invoicing module from your dashboard. Then click on Reporting and under Basic Reports choose GRN Bill. This report provides an overview of all GR bills recorded in your system. Once the report loads, you can begin analyzing and customizing it using different search and filter tools.

By default, the report is field by Posted status, showing GR bills that have been finalized and completed.

Quick Search Options in the GRN Bill Report

The GRN Bill Report includes simple search options that help you search the information quickly. You can define a Date Range by selecting the start date and end date. This updates the report automatically and displays GR bills for that period.

You can also narrow down the report by selecting a Vendor from the vendor search field or choosing a
Company if you manage multiple companies in your Odoo system. After selecting your options, click Search to view the results. Multiple search options can be applied at the same time, and clicking Reset clears all selections so you can start fresh.

Using the Search Bar in the GRN Bill Report

The search bar gives you a quick way to find specific GR bills. You can search using the GR Bill number, Vendor Name, Vendor Bill No or PO Number, depending on what you want to track.

You can also search using the vendor’s GST Number, Mobile Number or the Bill Date if you want to focus on bills created on a particular day. These search options help you instantly locate the exact GR bill or vendor record without scrolling through the entire report.

Using Filters in the GRN Bill Report

Filters make it easier to view specific types of GR bills. When you click the ▼ drop down icon in the search bar, Odoo displays predefined filter options. You can filter based on status such as Posted, Draft or Cancelled, depending on whether you want finalized, pending, or cancelled entries. If you want to see only inventory-related GR bills, you can choose the Invoice or Credit Note filters.

For date-based filtering, the Bill Date filter allows you to view bills from a selected month, quarter, or even the last three years.

Applying Custom Filters

If you want more precise control,Odoo allows you to create your own custom filters. When you click Add Custom Filter, a popup window appears with a default rule that you can adjust. This lets you choose a field such as PO Number or Vendor Name and apply an operator like contains , is equal to or does not contain, etc,.. and enter the value you want.

After entering the required value and clicking Add, the report updates instantly and displays only the GRN Bill records that meet your selected criteria.

Using Group By Options in the GRN Bill Report

Grouping your data helps you compare and understand GR bills more effectively. When you click the ▼ drop down icon in the search bar, Odoo displays predefined grouping options in the Group By section. Grouping by Vendor helps you see how many bills each vendor generated. Grouping by Company separates bills created by different business entities.

You can also group by PO Number to understand GR bills linked to each purchase order. If you want to study patterns over time, grouping by Bill Date lets you view the data by month, quarter, year, week or even by day. These grouping options give you a structured way to analyze your GRN data.

Applying Custom Grouping Options

If you need more grouping options, clicking Add Custom Group shows additional fields that you can use. You can select fields such as Bill Number, Payment or any other relevant GRN field to structure the report in a way that matches your analysis needs.

Once a group is selected, Odoo instantly arranges the data based on that field, giving you a more personalized and meaningful view of your GRN Bill records.

Saving Favorites for Quick Reuse

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 Save Current Search. You can name your saved filter, set it as the default view or share it with other users. 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.

By using these features in the GRN Bill Report, you gain clearer insights into your purchase activities, vendor performance and incoming goods. This helps you make better, more informed decisions and manage your procurement process more efficiently.