Inventory reports
The inventory reports show what you have, where, what it is worth, what is expiring and what to order.
Open Reports›Inventory.
| Report | What it shows |
|---|---|
| Inventory Summary | Opening stock, quantity in, quantity out and closing stock for each item over a period. |
| Stock by Warehouse | The quantity on hand of each item in each warehouse on a date. |
| Stock Movement | Every stock in and out with its document, or one item's movements with a running balance. |
| Inventory Valuation Summary | Quantity on hand, average cost and stock value for each item on a date. |
| FIFO Cost Layers | What is left of each receipt, with its date, cost and age, for FIFO items; the average cost for moving-average items. |
| Stock Value vs GL | The stock value on hand against the inventory account balance in the general ledger, by account, branch and item. They should agree. |
| Batch & Expiry | Batches in stock with their expiry dates, days to expiry and value. Filter to expired or expiring stock. |
| Reorder Report | Items at or below their reorder level, with the shortfall and the preferred vendor. |
| Reorder by Warehouse | Items at or below their reorder level, with the available stock of each warehouse as a column, the total, the reorder level and the shortfall. Filter by warehouse, category, item, preferred vendor and item type. |
Stock being packed
Stock by Warehouse and Stock Movement show available stock only. Stock that is still being packed can't be sold yet, so it's left out. Turn on Show stock being packed to include it, kept apart from the available stock: Stock by Warehouse adds a (being packed) column for each warehouse holding some, and a Being Packed total.
If Stock Value vs GL shows a difference, see Inventory costing for the cost adjustment and re-post.
Can't find what you need? Write to info@exlerithub.com or chat with us on WhatsApp.