Three kinds of stock questions
Stock questions come at three speeds. Some are needed right now: how much of an item do we have, and where. Some are needed every morning: what fell below minimum overnight. And some are needed once a month: what is not moving, and how much money is sitting on the shelf because of it.
In most companies all three end up as an export from the ERP and an Excel file someone maintains. WizBI answers all three from the same data, in the chat, at the speed each one needs.
A stock status report in one question
Anyone with the right permissions can ask, in plain language, from their phone:
- "How much of item X do we have, by warehouse, and what is on order?"
- "Stock of product family Y across all warehouses, as a table."
- "Which items are at zero stock but have open customer orders?"
- "Stock movements of item X in the last 30 days: receipts, issues and transfers."
Below-minimum stock alerts
An alert is a question WizBI asks for you. Set the line once — per item, per family, or using the minimum level already kept in your ERP, if you keep one — and WizBI writes to you when stock crosses it.
You can get it two ways: an alert when an item drops below the line, or one list every morning at 07:00 with every item below minimum and the open purchase orders for each. Buyers usually prefer the list; managers usually prefer the alert for a few critical items.
The morning list can include what is already on order for each item, so the buyer sees the whole picture in one message.
Slow-moving and aging stock
Slow-moving inventory is money on a shelf. An inventory aging report shows which items have not moved, for how long, and what they are worth — so purchasing knows what to stop buying and sales knows what to push.
The same question works for 90 or 365 days, by product family, or only for items that are still being purchased.
Stock value and stock movements
A stock value report answers "how much is our inventory worth" by warehouse, by product family or at a given date, using the costs recorded in your ERP. A stock movements report shows what came in, what went out and what moved between warehouses for an item or a period.
Both can arrive on schedule — stock value on the first of every month to management and finance, for example.
The value WizBI reports is the one your ERP data gives. The official figure for your financial statements still comes from your finance team's own process.
Automations around your stock process
Answers, reports and alerts work from day one. When a stock routine repeats — the morning below-minimum review, the monthly slow-moving check — we can build an automation around it on request: defined with you, running under the permissions you set, with every action logged.
The answer is only as accurate as the data in the ERP — if a warehouse has not been counted in a while, the report will show what the system says, not what is on the shelf.
For Priority users, more examples are in Priority reports you can ask for in the chat.