Nine reports, each answering a different question.
Inventory value comes from cost layers
Stock valuation builds value from the real cost layers rather than the latest purchase price. Two warehouses holding the same quantity can be worth different amounts, because their stock arrived at different times and prices.
The reports do not share one definition
Each has its own scope, and comparing figures across them directly is misleading:
- Supplier spend, and the spend column of PO performance, count only fully received orders — drafts, orders in transit and partial receipts are all excluded.
- Movement summary and ABC analysis see every movement, inbound and outbound alike.
So a discrepancy between those two groups is expected.
ABC analysis is about turnover, not profit
Items are ranked by movement value over the chosen window and split into three bands. Direction does not matter: an item that comes in a lot and goes out a lot lands in band A.
Which means band A is "fast-moving", not necessarily "most profitable".
The aging report counts layers, not items
Aging groups by the arrival date of each cost layer. One item can appear in several age bands at once, because different parts of it arrived at different times.
Order sourcing tracing
Order sourcing shows which layers — and therefore which purchase orders — a sale was drawn from. It is the only place a sale can be followed back to its supplier.
The CSV is what you are looking at
Every report exports to CSV. The file is exactly the filtered rows on screen, including your own warehouse access restriction. So two people can export the same report and get different files.