| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Invoicing (account) • Discuss (mail) • Inventory (stock) |
| Lines of code | 792 |
| Technical Name |
purchase_cost_report |
| License | LGPL-3 |
| Website | https://aceleradora.la |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Invoicing (account) • Discuss (mail) • Inventory (stock) |
| Lines of code | 792 |
| Technical Name |
purchase_cost_report |
| License | LGPL-3 |
| Website | https://aceleradora.la |
Purchase Cost Report in Purchase Currency
Know the real import cost of your products in the currency you actually paid.
When your company buys in a foreign currency (e.g. EUR or USD) but operates in a local currency (e.g. ARS), Odoo's standard reports show all costs in the company currency. This module adds a dedicated valuation report that shows the real unit and total cost of each received product in the purchase order currency, including landed costs converted at the exchange rate of the date of each cost.
Access it with one click from the Purchase Order or the Vendor Bill.
Key Features
Costs in Purchase Currency
Unit and total vendor cost shown in the PO currency — no more manual currency conversions.
Landed Costs Converted at Cost Date
Each landed cost is converted to the PO currency using the exchange rate at the date of the landed cost invoice, even if the invoice is in a third currency (e.g. ARS freight invoice on a EUR purchase).
Import Cost Percentage
Instantly see what percentage of extra cost (freight, customs, insurance) you incurred to import, relative to the vendor invoice total.
What the Report Shows
| Column | Description |
|---|---|
| Product | Product name and description |
| Ordered / Received Qty | Quantities from the PO and actual receipts |
| Vendor Unit Cost | Price per unit in PO currency (directly from the PO line) |
| Vendor Total Cost | Unit cost × received quantity, in PO currency |
| Landed Costs | Sum of all landed costs allocated to this product, converted to PO currency at the rate of each cost's invoice date. Breakdown per landed cost shown as sub-rows. |
| Total Unit Cost | (Vendor + Landed Costs) / Received Qty in PO currency |
| Total Cost | Vendor + Landed Costs in PO currency |
| Import Cost % | Total Landed Costs / Total Vendor Cost × 100 |
On-Screen Wizard + PDF Report
📊 Interactive Wizard
- Tab 1 – Product Summary: all products with full cost breakdown
- Tab 2 – Landed Cost Summary: one row per landed cost with clickable links to the landed cost and its vendor invoice
- Tab 3 – Detail per Product: full cross-reference of product × landed cost
- Import cost % badge displayed prominently in the header
- "Print PDF" button inside the wizard
🖨️ PDF Report
- Main table: products with unit/total costs and landed cost sub-rows
- Summary grid: one row per landed cost with origin currency and OC amount
- Highlighted import cost percentage banner
- Accessible from Print menu on the Purchase Order
Smart Button Visibility
The "Valuación" button appears automatically on:
- ✅ Purchase Orders — only when state is Purchase Order or Done AND at least one line has a storable product
- ✅ Vendor Bills — only when the invoice has lines linked to a PO with storable products
- ❌ Hidden on service-only invoices, freight bills, and draft orders
Multi-Currency Logic
The module handles the following scenarios for landed cost conversion:
Amount used directly — no conversion needed.
Amount converted from invoice currency → PO currency using the exchange rate on the invoice date of the landed cost.
Amount converted from company currency → PO currency using the rate on the landed cost date.
Requirements
- Odoo 19.0 Community or Enterprise
- Modules:
purchase_stock,stock_landed_costs - Landed Costs feature enabled in Inventory settings
- Multi-currency enabled in Accounting settings (for cross-currency conversion)
About Aceleradora LA
We build practical Odoo modules for Latin American businesses, focused on import/export workflows, multi-currency operations, and local regulatory requirements.
🌐 aceleradora.la | 📧 info@aceleradora.la | 🐙 github.com/aceleradora-la
Please log in to comment on this module