Global Warehouse KPIs
What sells, what moves, and what has been sitting too long
Three tables on one screen: sales by category and month with their share, receipts against issues month by month, and the list of lots past the number of days you define as obsolete.
How you get it
Every development works in all three Odoo environments. The only thing that changes is how we deliver it.
Odoo Online (SaaS)
You do not need the ability to install modules. A Millora consultant comes in with temporary access that you authorize and implements it with Odoo Studio. When they are done, you revoke the access.
Odoo.sh or your own server
You receive the module and the installation guide by email as soon as payment clears. Install it yourself, or we install it with you.
Installation · shell
# 1 · copia el módulo a tu addons_path
cp -r millora_kpis_globales_de_almacen /mnt/extra-addons/
# 2 · reinicia y actualiza la lista de apps
odoo-bin -u all -d tu_base --stop-after-init
# 3 · instala desde Apps
# busca "Global Warehouse KPIs"What it solves
The problem
Month-end in a warehouse is three questions, and today they get answered in three different places.
What sold comes from a sales report. Whether stock moved has to be inferred by comparing receipts and issues, which nobody cross-references. And what is stagnant comes from nowhere: you find out when somebody trips over a dusty pallet.
Separately, each says little. Together they tell the whole story: a category selling well but whose receipts have outpaced its issues four months running is accumulating a problem, however healthy the sales report looks.
How it works
You pick the period and run it. Three tables come out.
Sales by category and month, with the total and each category's share. The percentage is what matters: it tells you whether a category actually grew or whether only the month did.
Receipts against issues, month by month. Units in and units out, side by side. When the receipts column beats the issues column several months running, that is overstock forming — months before it shows up as a space problem.
Obsolete lots. And here is the design decision that makes the report useful: you define how many days without movement make a product obsolete. There is no universal number — ninety days is an eternity for a perishable and nothing for a spare part. The threshold is yours, and the system lists the lots that crossed it.
Where it fits
This is the management report: three aggregate figures, monthly, to review at close.
If what you need is the detail — how many days that lot has been sitting, or which area the product stalls in — that comes from Lot aging and Aging by location. This one tells you there is a problem; those tell you where.
What it does not do
It does not warn. No alerts, no replenishment, no action of any kind: these are reports somebody has to open. Their value comes from making them a month-end habit, not from installing them.
It does not analyse products without lots. Obsolescence detection works on lots; anything untracked stays out of that table.
It does not replace accounting reports. It talks about units and days, not value.
And it depends entirely on classification: if product categories are wrong, the sales-by-category table means nothing. Worth reviewing them first.
What changes
Month-end stops being three separate queries and becomes one screen you read in two minutes.
And overstock stops being discovered when it no longer fits: it shows up as a receipts column that has been beating the issues column for a quarter.
What's included
- Shows sales by category and month, with each category's share
- Compares units received against units issued, month by month
- Lists the lots that crossed the no-movement threshold
- Lets you define how many days make a product obsolete
- Bounds all three reports to the date range you choose
- Presents the result as separate tables, ready to read at close
- Runs with no prior setup and no external tooling
Requirements
- Inventory and Sales modules active
- Product categories properly assigned: the sales table depends on them
- Products tracked by lot, so obsolescence detection reaches them
- Your own obsolescence criterion: how many days without movement are too many in your business
- Stock movements recorded up to date
You might also need
Fulfillment Restock Calculator
How many units to ship to the marketplace warehouse, with numbers
Inventory & warehouse
Fulfilment Appointments
So the appointment doesn't fall through over something already known
Inventory & warehouse
Containers
You know what each unit cost you before the ship docks
Inventory & warehouse