%20(1300%20x%20200%20px).png?width=450&height=69&name=Short%20Haircut%20Photo%20Banner%20Email%20Header%20(1300%20x%20300%20px)%20(1300%20x%20200%20px).png)
🔍 Report Overview
The report gives you a detailed breakdown of:
- Product levels by company and product line
- Current stock, required stock levels, and items on order
- Cost prices and value on hand for each product, line, and company
The first page includes summary totals:
- Total quantity on hand
- Total quantity on order
- Total value on hand
📈 Key Terms Explained
| Term | Description |
|---|---|
| Sell Price | The retail price of the product (excluding sales tax). |
| Gross Profit % | Calculated as: (Ex-Tax Sell Price – Average Cost) / Ex-Tax Sell Price × 100 |
| Quantity in Stock | The number of units currently available. |
| Warning Level | Reordering alert level. A warning appears when stock reaches or falls below this number. |
| Maximum | The ideal stock level you aim to maintain after a reorder. |
| On Order | Quantity currently ordered but not yet received. |
| Average Cost | Based on the formula: (Previous Inventory Value + New Order Cost Ex-Tax) / (Previous Qty + New Order Qty) |
| Buy Price | Purchase price of the product at the time the report is run (can be used instead of average cost). |
| Value on Hand | Total inventory value, calculated as: Average Cost or Buy Price × Quantity on Hand |
🛠 Accessing the Report
To generate the report: Tools > Reports > Inventory > Inventory Control Report
