Overview
Advanced product reporting with XLSX export: purchase-to-cost analysis with landed cost per unit, stock movement by lot/serial with expiration, and invoice line product reports.
Key Features
- Product purchase report with landed cost breakdown
- Stock movement by lot/serial with expiration
- Invoice line product report
- Landed cost percentage calculation
- Running stock balance
- XLSX export
- Automated cron refresh
Data Models
Product Landed Cost
product.template.landed.cost| Field | Type | Info |
|---|---|---|
Product
product_id
|
Many2one | Tracked product |
Unit Price
unit_price
|
Monetary | Purchase price |
Cost Per Unit
cost_per_unit
|
Monetary | Total cost/unit |
Landed Cost %
landed_cost_percentage
|
Float | Additional cost % |
Extends Existing Models
stock.move.line
Adds 2 fields:
Partner (Many2one)
Balance (Float)
Adds actions: recompute_balance
Scheduled Automations
- Product Report Refresh — runs every 1 day
- Stock Balance Compute — runs every 1 day