Consumption report and movements
Inventory answers two management questions: where material goes and what it costs. It has three outputs for that.
Consumption report
Open it from Inventory → Stock → More actions → Report.
- Choose the period.
- Choose how to group: by item, task, employee, branch or warehouse.
- If needed, filter by warehouse, item, branch or employee.
- Click Generate.
Each line shows the quantity consumed, the cost (valued at the unit cost on the item's record), the number of entries and the date of the first and last one. It can be exported to CSV.
It tells you which customer or site consumes the most, which person uses more than usual or which warehouse empties first.
Movement ledger
Everything that happens in inventory is recorded: receipts, reservations, issues, consumption, returns, recounts and transfers, with who recorded it, in whose name and on which task.
It is downloaded in CSV from the consumption report, from each item's record and from each warehouse's record. It is the record to turn to when a count does not add up.
Material in the task report
With inventory subscribed, the Excel task report includes each task's material, its cost and what was left unsettled. See Task reports.