Bitwerf · Odoo apps

Inventory Analysis

See which products move, which tie up your money, how old your stock is, and what will run out or pile up.

$29 one-time per Odoo version · Odoo 17, 18, 19 and 20 · Community and Enterprise
Buy for Odoo 20.0Buy for Odoo 19.0Buy for Odoo 18.0Buy for Odoo 17.0
Sold and installed through the official Odoo Apps Store.

Odoo tells you how much stock you have, not how well it moves. Choose a period and warehouses, and one analysis computes for every product: turnover with FSN classes, XYZ classes by stock value, stock age, out-of-stock risk with a suggested order quantity, overstock, and a movement summary from opening to closing stock.

An analysis of the last twelve months: classes, stock value and excess at a glance.

What it does

Turnover and FSN classes

Usage (deliveries minus customer returns, plus components consumed) divided by the average stock of every day in the period. Scaled to a year, the turnover classes each product as fast moving, slow moving or non-moving, with thresholds you set per analysis.

XYZ classes by stock value

Closing stock at cost, highest values first: X up to 70% of the value, Y up to 90%, Z for the rest. Each product shows its share of the value and a combined FSN-XYZ code, so NX marks expensive stock that does not move.

Stock age

The stock at the end of the period split by receipt date, newest receipts first: 0-30, 31-60, 61-90, 91-180, 181-365 and over 365 days, with the average and the oldest age in days.

Out-of-stock risk

Daily usage, open receipts and open deliveries give a forecast and its days of cover. Products that run out within the horizon (30 days unless you change it), or whose forecast falls below zero, are flagged with a suggested order quantity.

Overstock

Forecast stock beyond 90 days of usage (or the limit you choose) is excess, shown with its value at cost. Stock of products without usage in the period counts in full.

Movement summary

Opening stock, receipts, vendor returns, deliveries, customer returns, manufactured, consumed, adjustments in and out, transfers in and out, and closing stock, for any period up to today.

Per warehouse or together

A line per product and warehouse, or one line per product for several warehouses, where transfers between them do not count. Narrow the analysis to product categories or products.

Lists, pivot and graph

Every report opens as a list, pivot or graph, with filters for the FSN and XYZ classes, out-of-stock risk and overstock, and grouping by warehouse, category or class. New analyses start with your previous thresholds.

How to use it

  1. Install the module; it needs only Inventory.
  2. Go to Inventory > Reporting > Inventory Analysis and create an analysis.
  3. Choose the period and warehouses and, if you like, product categories or products. Adjust the thresholds.
  4. Click Compute, then open Turnover, Stock value XYZ, Stock age, Out of stock, Overstock or Movements.
  5. Change the period or a threshold and click Recompute. Analyses are kept, so you can come back to them.

Screenshots

Turnover and FSN classes per product and warehouse.

Turnover and FSN classes per product and warehouse.

Stock age by receipt date.

Stock age by receipt date.

Out-of-stock risks with days of cover and a suggested order quantity.

Out-of-stock risks with days of cover and a suggested order quantity.

Need it to work differently?

We build custom Odoo modules and changes to this one at a fixed price, from €950 excluding VAT. Small modules are usually delivered within five working days, tested on your Odoo version. Describe what you need to hello@bizzkitt.ai.

All Odoo apps by Bitwerf

Bitwerf is a trade name of BizzKitt B.V., Frederikstraat 67, 3034 LD Rotterdam, the Netherlands (KvK 42149345, VAT NL869932354B01). Questions: hello@bizzkitt.ai · Support · Privacy · Terms