Overview
Standard Odoo gives a product list but no ready way to see, in one Excel file, what each item really earns once purchase price and landed costs are factored in. This module adds a suite of XLSX (and one PDF) reports that compare sales price against landed purchase cost per unit, break landed costs down by purchase order, show a month-by-month sales matrix, list stock by lot and expiry date, and surface open sales-order quantities still to deliver or invoice. Reports run from dedicated wizards under Accounting/Finance Reports or from print buttons on products and sales orders, with scheduled jobs keeping the underlying cost figures fresh.
Key Features
- Generates a 'Sales PRICE vs Purchase PRICE' analysis per product showing unit price, landed cost per UoM, quantities, taxes and lot/expiry details, viewable on screen or exported to Excel.
- Calculates and stores per-product landed cost from purchase orders, including additional cost percentage and total cost per unit, shown on a dedicated Product Cost tab.
- Produces a month-by-month (Jan-Dec) sales matrix per product template with totals, percentage of total and color-coded positive/negative values.
- Exports an Inventory Valuation with Landed Cost report per receipt, totaling stock valuation plus validated landed costs.
- Prints a Lot/Serial stock report (PDF and Excel) listing on-hand quantity, lot numbers and expiration dates per product.
- Generates an Open Sales Orders Lines report comparing ordered, delivered, invoiced and remaining-to-deliver/invoice quantities and amounts.
- Adds a Vendor/Customer column and a running on-hand balance to the stock move line list, with a Recompute Balances action.
- Filters reports by date range, partner, product category, product, currency and credit-note inclusion through guided wizards.
- Keeps cost data current with a daily cron that refreshes product landed costs and a 10-minute cron that recomputes stock balances.
- Tracks key product changes (type, category, sales price, units of measure, tags) in the chatter for audit visibility.