Turn purchase data into decision-ready Excel reports
One dialog to filter, lay out, template, schedule and email rich multi-sheet Purchase Order reports and product purchase history — without ever leaving Odoo.
The problem
Procurement teams live in Excel for supplier negotiations, budget reviews and vendor communication, but Odoo's native purchase views only offer on-screen pivots and lists. Getting a clean, filtered export with the right columns means manual copy-paste, screenshot workarounds or a developer request — and the same friction hits anyone who just needs a product's purchase history.
The solution
Purchase Order Excel Report puts filtering, layout, columns, templates, scheduling and email delivery in one dialog. Generate line-detail, summary, day-wise, multi-sheet or supplier-ranking workbooks in a click, save the configuration as a reusable template, and let scheduled auto-distribution keep stakeholders updated without repeating the setup.
Everything a buyer needs to report and share purchase data
Every capability below is implemented in the module.
One consolidated export dialog
Filter by vendor, buyer, category, product, PO status and date range in a single screen instead of hunting through menus.
Five report layouts
Line detail, summary totals, day-wise totals, a multi-sheet workbook and supplier ranking, all from the same export.
Configurable columns
Toggle order reference, dates, vendor, product, category, quantity, pricing, status, buyer and more to fit the audience of each report.
Saved filter templates
Recurring reports such as monthly spend by vendor load with one click instead of being reconfigured every time.
Scheduled auto-distribution
Turn on auto-distribute for weekly or monthly runs; a scheduled job checks due templates and generates and sends them automatically.
Branded email delivery
Recipients are validated first, the workbook is attached automatically, and delivery goes out from a saved mail template or a plain email.
Delivery log
Every generation and send is recorded with order/line counts, the total amount, state and error text on failure — a full audit trail.
Optional PDF export
Generate a matching PDF alongside the Excel workbook when a human-readable copy is needed too.
Product purchase-history export
Pull a product or variant's full vendor, cost and quantity history to XLS straight from the product list or form action menu.
How it works
Open the export dialog
Pick a saved template or set vendor, buyer, category, product, date and status filters.
Choose a layout
Detail, summary, day-wise, multi-sheet or supplier ranking, then preview the order and line counts.
Generate or send
Download the formatted Excel and optional PDF, or email it straight to validated recipients.
Track and repeat
Every run lands in the delivery log; save the config as a template or schedule it to repeat.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
This module supports Odoo 19 Community. It has no Enterprise-only dependencies.
Buy it on the Odoo App Store
Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.
Purchase Order Excel Report
One filter-and-export dialog producing five multi-sheet Excel layouts with the columns you pick, saved as reusable templates and delivered on a schedule with a branded email and a delivery log.
Buy on Odoo App Store