Report of Stockroom Valuation
This report values the stockroom: it shows the stock of each inventory item, its average price and what it is worth, with a total per inventory item type and a grand total.
How to get here: menu Items → Reports → Stockroom Valuation.
Access to this report depends on the employee's access level.
Filters
The Report of stockroom valuation window opens. It is the same as the one in Report of Current Stock, with the same filters:
| Block | Options |
|---|---|
| Status | All, Available or Unavailable. Available comes selected. |
| Inventory | All, With Inventory or Without Inventory. With Inventory comes selected. |
| Vendor | A vendor from the list or -- All vendors --, which is what comes chosen. |
- Status filters by the Inventory item available checkbox of the inventory item.
- Inventory filters by the Show in inventories checkbox of the inventory item.
- Vendor leaves only the inventory items that have that vendor assigned.
Running the report
- Choose the filters.
- Click Report.
- If the branch has more than one subcentre, the Select the Subcentre window appears. Choose one and click Ok.
If no inventory item meets the filters, the message “There are no inventory items with the selected filter.” appears.
The report
The inventory items are grouped by inventory item type.
| Column | What it shows |
|---|---|
| DESCRIPTION | The name of the inventory item. |
| STOCKROOM STOCK | The stock of the chosen subcentre, in stockroom units. |
| USAGE STOCK | The same stock in recipe units: the stockroom stock multiplied by the equivalence of the inventory item. |
| AVERAGE PRICE | The average price of the inventory item per stockroom unit. |
| STOCK VALUE | The stockroom stock multiplied by the average price. |
Each inventory item type ends with a TOTAL : line. At the end of the report, STOCKROOM VALUATION adds up the value of all the types.
Buttons
- Report: runs the report with the chosen filters.
- Cancel: closes the window.