Warehouse value shows the most recently calculated monetary value of the selected warehouse and its breakdown by product. The view helps you check what makes up the total value and how up to date the calculation is. It is neither a real-time stock balance view nor a stocktake.
Opening the value view
You need the warehouse feature to be enabled and permission to view the warehouse in question. Limited permissions to view warehouse transactions may also grant access to the values of permitted warehouses. If a warehouse is missing from the list, ask an administrator to check your permissions.
- In the browser's main menu, open Manage warehouses → Warehouses.
- Select the Warehouses tab and the warehouse you want from the list on the left.
- In the selected warehouse's Basic info section, open Warehouse value.
The window title shows the calculation method: FIFO or Moving average cost, abbreviated as MAC. The method comes from the service's shared settings; it is not selected in this view. Inventory usage principle, shown in Basic info, is a separate setting: it determines which batches products are consumed from.
The value date and the Updated at time appear at the top of the window. They indicate when the latest saved calculation took place. Warehouse transactions made after that time may not yet be included in the figures.
Understanding the product table
- Product identifies the product. Data for the same product is combined across the warehouse's different slots and purchase batches.
- Value is the total monetary value of the product's remaining quantity in this warehouse. It is not the price of a single unit, the selling price or the product cost recorded for a task.
- Pieces is the product quantity included in the calculation, not the number of purchase batches or a monetary amount.
- Purchase batches appears in FIFO calculations and shows the number of separate purchase batches included for the product. The same batch in several warehouse slots counts as one batch.
- Average cost appears in MAC calculations. It is the saved value for the product divided by its quantity, rounded to two decimal places. The average cost for a zero quantity is zero.
What makes up a product's value?
FIFO: the remaining quantity on each batch row is multiplied by its purchase price, and the results are added up by product. If Current value per product has been set for a row, it replaces the purchase price. A value explicitly set to zero is also a valid unit value. A missing purchase price is treated as zero. Purchase batches marked as depleted are excluded from the calculation.
MAC: the calculation includes positive batch balances in the selected warehouse from batches created and received by the time of calculation. Standard quantities are valued using the product's shared weighted average purchase price, calculated across all of the company's warehouses. A current value set for a batch row and effective at the time of calculation replaces the MAC price for that row's quantity.
MAC is updated when a purchase is made or a stocktake increases the balance: (previous total company quantity × previous MAC + value of the addition) ÷ (previous total quantity + quantity added). In a stocktake, only the added quantity is valued at the purchase price of that batch. The total company quantity also includes products transferred to a reservation target. Sales, usage and stocktake reductions do not themselves change the MAC price, but they reduce the quantity used in the calculation for the next addition. Internal transfers do not change the total company quantity.
This means that a purchase or a stocktake increase in another warehouse can also change this warehouse's MAC value. For more background and the separate pricing rules for product costs, see Warehouse value and product cost.
Average cost is not always the same as the shared MAC. If there are six units of a product at a MAC price of €10 and four units at a current value of €8, the product's value is 6 × 10 + 4 × 8 = €92. The table's Average cost is 92 ÷ 10 = €9.20, even though the shared MAC is €10.
Product values and the warehouse's total value are saved separately as monetary amounts with two decimal places. The sum of the visible, individually rounded product rows may therefore differ slightly from the rounded total value of the full calculation.
Filtering and exporting to Excel
Filter products using the search field below the Product column heading. The fields below the numeric column headings let you filter by numbers. Click a column heading to sort the rows.
The totals at the bottom of the Value and Pieces columns apply to the entire warehouse, including products on other pages of the table. Filtering the product table does not recalculate these totals for the filtered rows. Do not interpret them as totals for the search results.
Wait for the table to finish loading, then select Export view to Excel at the top of the window. Check the products, columns and filters in the Excel file before using it further. Also retain the calculation time if you use the file for a later comparison.
Updating the value and checking the result
Values are calculated automatically in an evening calculation that starts at 23:00 in the service's time zone. If you need a new calculation earlier, select Update value at the top of the value view. This starts a background calculation for the selected warehouse. If an update for the same warehouse is already queued or running, another update will not be started in parallel.
A notification about the background job does not yet mean that the calculation is complete, and the figures in the open window do not update automatically. Allow the calculation to finish, select Close at the bottom of the window, and open Warehouse value again. Check that the calculation date and Updated at time have changed. Then compare the product's quantity and value and the warehouse's total value with the expected figures. An unchanged monetary amount alone does not mean that the calculation failed to complete.
A new calculation saves a new total warehouse value and replaces the current product breakdown. A zero value is saved even for an empty warehouse; the product table may be empty and the total quantity field may remain blank. If a dash appears instead of the calculation time, do not interpret it as a confirmed zero value.
Update value does not change product balances, purchase prices or the batches' current unit values. If the quantity is incorrect, investigate the transactions and perform a stocktake if necessary. If the price used as the basis for the value is incorrect, check the purchase batches and purchase prices before making corrections.
History and mobile apps
History at the top of the value view opens the saved daily values and explanations of their changes. The current product breakdown is not retained as a daily history, so you cannot use this table to open product rows for a previous day. See Viewing warehouse value history.
Pulling to refresh the warehouse's product list on Android or iOS reloads the product data. It does not start the browser's Update value calculation. Check the monetary warehouse value and its calculation time in the browser as described above.