Overview
Purchase Register Report for Odoo 19 consolidates POs, vendor bills, and debit notes with PDF and Excel export for purchase managers and finance teams.
Supports v 19.0 — available directly on the Odoo Apps Store.
Description
The Purchase Register Report module addresses a gap in standard Odoo Purchase reporting by giving purchase managers, accounts payable teams, and finance controllers a single, consolidated register of purchase orders, vendor bills, and debit notes. Instead of reviewing these documents separately, users can generate one Purchase Register Report with advanced filters, view the results in an interactive list, and export the data as PDF or Excel for further review.
Key Features of the Purchase Register Report
- Dedicated report menu added under Purchase → Reporting for direct access to the Purchase Register Report
- Advanced report wizard to filter by date range, vendor, document state, and payment state before generating the report
- Interactive list view with optional columns, group by, and advanced filters for analyzing purchase register data inside Odoo
- PDF export to download the Purchase Register Report as a printable document
- Excel export to move full report data outside Odoo for further analysis
- Consolidated view of POs, vendor bills, and debit notes in a single purchase register
- State-wise filtering by Draft, Posted, or Cancelled document states
- Vendor-wise reporting to generate the register for selected vendors only
- Date range filter using Start Date and End Date to define the reporting period
- Payment state filter for bills and debit notes by paid, unpaid, or partial status
- Optional columns that can be toggled on or off in the list view as needed
- SQL-based report generation designed for fast results with large purchase datasets
How It Works
After installing the module, a new Purchase Register Report menu appears under Purchase → Reporting. Opening this menu launches a wizard where the user sets filters such as date range, vendor, document state, and payment state. Once the report is generated, the data is displayed in an interactive list view that supports optional columns, group by, and advanced filters. From this list view, users can trigger a PDF action to produce a printable Purchase Register Report, or use the Excel download button to export the same data for offline analysis.
Business Use Cases
Accounts payable teams can use the Purchase Register Report to review all vendor bills and debit notes for a specific period without switching between multiple Odoo views. Purchase managers can filter the register by vendor to check purchase activity with a particular supplier, or by document state to isolate draft, posted, or cancelled transactions. Finance controllers can apply the payment state filter to identify unpaid or partially paid bills and debit notes that need follow-up. Because the report can be exported to PDF, it is also useful for sharing a formatted purchase register with stakeholders who do not have direct access to Odoo, while the Excel export supports further reconciliation or reporting work outside the system.
Frequently Asked Questions
Does this report include purchase orders as well as vendor bills?
Yes. The Purchase Register Report consolidates purchase orders, vendor bills, and debit notes into one register.
Can I filter the report by a specific vendor?
Yes. The report wizard allows filtering by vendor so the register can be generated for selected vendors only.
Can I export the report to Excel?
Yes. The module provides an Excel export option in addition to the PDF export, allowing the report data to be analyzed outside Odoo.
Can I filter by payment status?
Yes. Bills and debit notes can be filtered by payment state, including paid, unpaid, and partial.
Is the list view customizable?
The list view supports optional columns that can be toggled on or off, along with group by and advanced filters for further analysis.
