It is a Tuesday morning at a mid-sized furniture plant. The production head walks into the warehouse to release the cutting list for a new hotel order. The fabric callout is 80 meters of slate-grey velvet. The stock card says 90 meters available. He releases the order.
By Wednesday afternoon, the cutter calls. The 90 meters are actually three short rolls received eleven months apart, and the dye lots do not match. Two of the three rolls have darkened in storage. There is enough usable fabric for 40 meters of the order, not 80.
Now the project manager has three bad options. Hold the order and re-cost it. Source a new dye lot and add four weeks to the schedule. Or absorb the cost of unusable inventory and explain the margin hit at month-end.
This scenario plays out somewhere in furniture manufacturing every single day. The cause is almost never a sourcing problem. It is a visibility problem.
Nobody saw that the velvet stock had been ageing on the shelf for the better part of a year because the system showed one number, “90 meters available,” with no signal about how long any of it had been there.
A inventory aging report is what closes that gap. It tells you not just how much stock you have but how long each piece has been sitting, in which location, in which lot, at which cost.
For a furniture business, where dye lots drift, foam degrades, and capital sits in expensive raw material, this single piece of visibility is the difference between catching a problem on Tuesday and discovering it on Wednesday afternoon.
This blog explains the Inventory Aging Report in Odoo alongside what other inventory features support it, and how a furniture manufacturer can put it to work.
What is a stock ageing report in Odoo?
A stock ageing report in Odoo shows how long each item in inventory has been sitting in stock since the date it was received. It groups stock into time periods so a furniture manufacturer can see which materials are moving and which are not. In Odoo, this analysis is built into the Stock Valuation reporting screen as a pivot view, and shows the on-hand quantity and value of inventory by purchase date.
What does Inventory Aging Report Solve?
Fabric drifts between dye batches. Older rolls become unusable for orders that require colour consistency across panels of one finished piece.
Foam degrades physically. PU and HR foam progressively lose density and yellow. After 12 to 18 months in storage, foam intended for premium upholstery often no longer meets the spec.
Hardware and trims retire. A specialty hinge for a console launched 18 months ago is no longer in the catalogue, but the residual stock remains on the shelf.
Finished goods sit when collections refresh. Seasonal pieces that did not sell through become candidates for write-down.
Capital sleeps. Furniture materials carry high unit costs. A roll of premium velvet alone can run into thousands of dollars. Money locked in slow-moving raw material is money the next production cycle cannot use.
How do you start using the inventory aging report in Odoo?
Step 1: Enable reporting access. The Reporting menu in Inventory is only accessible to users with admin access. Add the operations head, the warehouse manager, and finance.
Step 2: Enable lot and serial number tracking. Turn it on under Inventory, Configuration, Settings, Traceability for any material where lot consistency matters. This is what lets the Stock Valuation pivot view slice by lot rather than only by product.
Step 3: Build a monthly review cadence. The report is only useful if someone acts on it. Most furniture operations benefit from a monthly review with procurement, design, and finance in the same room, so decisions on slow-moving stock are made by people who understand the design pipeline behind them.
Explore more Odoo Inventory Reports for furniture manufacturers
| Stock Reports in Odoo | What insight it offers? |
| Stock Ageing Pivot | How long has each item been sitting? |
| Stock Report | What is my current and historical stock level and value? |
| Dead Stock Report | Which items have not moved at all? |
| Stranded Inventory Report | What stock is sitting in unusual locations? |
| Forecasted Report | Will I have enough to fulfill open orders? |
| Replenishment Report | What do I need to order, and when? |
See it configured for a real furniture operation
Our team has implemented these inventory capabilities for furniture manufacturers across residential, modular kitchen, and contract seating segments. If you want to see what a properly configured stock ageing and replenishment flow looks like for your product mix, reach out and we will walk through it.
