Purchase Order Report XLSX
This module extends the functionality of the purchase order list view and allows you to export the selected orders to an XLSX spreadsheet.
auto_awesome What this module does
AI-generated from the code · Odoo 19.0Adds a 'Purchase Order XLSX' export option on purchase orders, producing a spreadsheet with one row per order line (vendor, dates, product, quantity, unit price, discount, taxes and subtotal).
Users can export purchase orders to an Excel (XLSX) file directly from the purchase order screen, using the new "Purchase Order XLSX" report available in the print/report menu of purchase orders.
The spreadsheet lists one row per order line, with columns for order reference, vendor, order date, expected date, product, description, quantity, unit of measure, unit price, discount (%), taxes and subtotal. Quantities, prices, discounts and subtotals are shown as numbers, dates as dates, and the header row is highlighted.
- Section or note lines of an order are written as a single merged row across the sheet, so the structure of the order stays readable.
- The sheet is set up for printing in landscape, fitted to one page wide, with a standard header and footer, and the header row is frozen so it stays visible while scrolling.
- When a single order is exported, the worksheet is named after that order; when several are exported, the sheet is called "Purchase Orders".
The module works on purchase orders (purchase.order) and their order lines, and relies on the XLSX report helper to build the file. It does not change any data, add checks or send anything automatically; it only adds the export report.
Depends on
Models and fields (1)
- report.purchase_order_report_xlsx.purchase_order_xlsx · new model
Text generated by AI (DeepSeek) from reading the Odoo 19.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 1 confirmed, 8 with no information of 9 versions.
Sources · Odoo 19.0
Confirmed on 2026-11-03 in branch 19.0 of OCA/purchase-reporting.
terminal Installation and usage
OCA documentation · Odoo 19.0Usage
Source · Odoo 19.0Go to the purchase order list view, select the orders you want to export and click on Print > Purchase Order XLSX.
The export can be customised via two methods on the purchase.order object:
_report_xlsx_fields This method allows you to modify the column selection and ordering. The default list includes: order reference, vendor, order date, expected date, product, description, quantity, unit of measure, unit price, discount, taxes and subtotal.
_report_xlsx_template This method allows you to alter or extend the underlying XLSX template (column headers, cell formats, column widths and data expressions).
No verified information in OCA: Installation, Configuration.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.