Product Inventory
Inventory balance and value per division and department as of a date, merged per product without splitting serial numbers. The month-end inventory valuation report.
Questions It Answers
- What is the inventory value of each warehouse at month end?
- Which products tie up the most value in the warehouse?
- What is the balance of product X in department Y, and how long since stock last came in?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Stock position as of a date (up to and including). Empty means today. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Department | Limits to one department (warehouse/outlet) inside the division; pre-filled from the role default when set. |
| Product Group | One group from the Product Group master. |
| Product Code | One product only - handy for tracing the history of a single item. |
| Inventory Balance | Filter by balance: > 0 hides empty products, < 0 finds negative stock, = 0 finds sold-out items. |
| Product Name | Search by name - partial (like) or exact (=). |
| Sorted by | Product code (default) or another available column. |
How To Read It
Nested result: Division > Department > product rows.
| Column | Meaning |
|---|---|
| Product Code, Product Name | Products with movement in that department. |
| Serial Number, Expiration Date | Balance split per serial number and expiry date. |
| Inventory Age | Inventory Age = days since the last stock-in of that product in that department up to the filter date. Items constantly re-bought always look young even if old stock has not moved. |
| Balance, Unit | Stock as of the filter date; the unit shown is the product's base unit that applies to that division/department; balances are in the base unit. |
| Cost of Goods Sold, Subtotal | The product's latest COGS in that division up to the filter date, and Balance x COGS. Department, division, and grand totals give the inventory value. |
The four balance reports on this menu differ only in columns: Product Inventory (serial numbers + COGS), without COGS (serial numbers, no value), without Serial Number (merged per product, with COGS and value), without Serial Number and COGS (merged per product, no value). Pick the leanest that fits - the valued ones are much slower because they look up COGS per row.
Why The Numbers May Differ
- Products that never had movement in that department are not shown, even if they exist in the master.
- COGS comes from the latest COGS record up to the filter date; a product with no COGS record ever shows zero in Subtotal.
- Global Product Inventory shows the same balances summed across departments.
- Only movements already on the stock card count; inventory documents not yet approved or posted are not on the stock card.
Menu Location
- Products & Inventory / Inventory Reports / Product Inventory
/report/repinventorybal