How do I view warehouse valuation history?

Warehouse valuation history shows the daily values stored for a warehouse and helps explain why its value has changed. The stored warehouse value and the change explained by events are separate pieces of information: incomplete history may prevent them from being reconciled.

Opening the history and selecting a date range

You need the warehouse feature to be enabled and permission to view the warehouse in question. In the browser, open Warehouses, select a warehouse and open Warehouse value → History.

Valuation date range defaults to one month. You can also select three or six months, or a custom date range. A single search can cover up to six months. Days are delimited according to the service's time zone.

What does a daily value mean?

The last warehouse value stored for each day is shown. If the value has been calculated several times during a day, earlier calculations from the same day do not appear as separate rows. The most recent days appear first.

Values are generated by an automatic evening calculation that starts at 23:00 in the service's time zone. Update value starts a new calculation in the background; allow it to finish before viewing the results. A change to the current unit value can also generate a new warehouse value. Opening the history itself does not change stock balances, prices or stored values.

Value is the total monetary value of the products in the warehouse at the time of calculation. It is not a quantity, a selling price or a product cost recorded for a task. A value of zero is stored even for an empty warehouse. A day without a stored value is omitted from the history: a missing row does not mean zero or that no events occurred.

Value change and the event period

Value change shows the net change derived from events and calculation explanations. Hover over the number to see Warehouse value change, the difference between two stored values, and the Explained by events total separately.

The comparison value is the previous stored daily value, including one outside the search period if necessary. View details opens the events after the previous comparison value was stored, up to the time the last value for the selected day was stored. The period may therefore span several days if no values were stored in between. Events after the selected day's last calculation belong to the next stored value.

If there is no earlier value at all, Value change appears as a dash. The details can still show events from the start of that day up to its last calculation, but the difference between stored values cannot be calculated.

The details show the event, product, time, reference, Affected quantity and Event value. Event value means the effect on the monetary value of stock in this particular warehouse. Purchases and returns generally increase it; sales, use on a task or service request, and transfers out of the warehouse decrease it. For a warehouse transfer, the effect is negative for the source warehouse and positive for the receiving warehouse. In an inventory count, the quantity means the change from the previous stock balance, rather than the entire final balance counted.

FIFO and moving average cost

The view title shows the warehouse's calculation method: FIFO or Moving average cost, also known as MAC. The selection comes from the service's shared settings. It is not a history filter, and it can no longer be changed once the warehouses have held products in stock. Setting the current stock balance to zero does not allow the method to be changed.

FIFO: the value is based on the quantities remaining in purchase batches and their unit prices. If Current value per product has been set for a product in a batch, it is used instead of the purchase price. The valuation method is separate from the FIFO or LIFO product usage principle, which determines which batches are consumed.

MAC: the quantities remaining in the warehouse are valued using the product's company-wide average cost, weighted by quantity. Products in a batch valued using a manual current value use their own unit value and are not revalued when MAC changes. The MAC warehouse value includes positive remaining batch balances.

MAC is calculated when a purchase is made or an inventory count increases stock: (previous company quantity × previous MAC + value of the addition) ÷ (previous company quantity + added quantity). An inventory increase is valued at the purchase price of the batch in question. The company quantity also includes products transferred to a reservation site. Sales, use and inventory decreases do not themselves change MAC, but they reduce the quantity used in the calculation for the next addition. Internal transfers do not change the company's total quantity.

For this reason, a purchase or inventory increase in another warehouse can also change the value of the warehouse you are viewing, even if no goods move here. Why the warehouse value changed then shows the effect on the previous local stock balance: quantity × (new MAC − previous MAC). The event value of a local purchase or inventory count already includes the corresponding revaluation.

Example: the company has 10 units of a product with a MAC of €5 in warehouse A. Another 10 units are purchased for warehouse B at €7 each. The new MAC is (10 × 5 + 10 × 7) ÷ 20 = €6. The quantity in A remains at 10 units, but its value increases from €50 to €60. When the comparison values are from before and after the purchase and there are no other changes, the explained change in A's history is +€10. With FIFO calculation, the purchase in B does not change the value of batches already in A.

Price corrections and manual current values

A purchase price correction can change earlier warehouse values and calculated event values. With FIFO, the effect depends on the quantity that remained in the corrected batch. With MAC, a correction can change the product's shared average cost and therefore the values of other warehouses as well. A purchase recorded retroactively can also correct earlier warehouse values.

A purchase price correction appears as an explanatory event with the text Included in warehouse values. It is not added again as a separate amount to the net change. The figures in the history can therefore change later; they do not always remain as they were at the original calculation time.

The original impact of a manual change to the current unit value is retained. If a later purchase price correction changes the historical unit value that preceded the manual change, the explanation shows the original impact, Historical correction and Impact on corrected history. The correction is included in the total explained change; the original change event is not replaced with a new one.

Warnings and incomplete history

A red warning icon indicates when an event value, a previous MAC impact or a historical correction to a manual impact cannot be calculated. In this case, the displayed total covers only the impacts that can be calculated. The details use the label Known net value change. A missing value does not mean zero.

A separate warning indicates when the explained total that can be calculated differs from the difference between the stored values. Check the event calculations and price corrections before interpreting the difference as a stock balance or recording error. Old MAC daily values are not comprehensively corrected for periods where the average cost history required for the correction is missing. As a result, the current explanation and an old stored value may remain different.

The total explained change includes local events, any MAC revaluation originating elsewhere, and historical corrections to manual impacts. Simply adding up the local event rows is therefore not always enough. Viewing permissions may also limit the purchase batch details visible in the explanation. Displayed figures are rounded to two decimal places, so a calculation using the visible unit prices may differ from the total calculated using more precise values.