Skip to main content

Stock Recalculation – GUI

What Is Stock Recalculation Used For and Where Can I Run It?

Written by Petr Pech

The stock recalculation checks the prices on stock cards and, where necessary, recalculates them to the correct values. When it runs, it goes through all stock movements. It also re-establishes the FIFO links between goods receipts and goods issues according to the stock date.

You can find it in the Tools -> Stock Recalculation, module. However, Flexi runs it automatically for the operations that require it (such as a change to the receipt price).
​
We can demonstrate how it works using one specific stock card. Note that when you run the stock recalculation manually, it always processes all stock cards.

On the stock card, 3 units have been received at a price per unit of 4.15 CZK (the opening balance was 2 units at the same price). This price also matches the average price. Subsequently, 2 units were issued, also at 4.15 CZK.

In practice, you may need to retroactively change the price of a previous receipt (for example, when a supplier has only delivered the goods, the goods are received into Flexi at 0 CZK, and you update the price later when the invoice arrives).

In our case, we will change the price per unit of the receipt of 3 units to 10 CZK.

When you save the change on the goods receipt, the stock recalculation starts automatically. It uses the changed receipt price to update the average price and applies it to all subsequent issues. In this case, the stock recalculation runs only for the specific stock card.

By default, the stock recalculation is therefore run automatically whenever it is needed. However, there may be situations in which, for some reason, the recalculation does not run and the prices on the stock card are incorrect. For these situations, you can run it manually.

When the recalculation does not start on its own

Under normal circumstances, the recalculation runs automatically whenever it is needed. If it does not run, it is almost always because the process was interrupted by one of the following:

  • an interrupted or incomplete database transaction (typically due to the volume of data being processed),

  • an internet connection outage,

  • a loss of connection between the client and the server.

If none of these non-standard situations occurs, the recalculation runs on its own. A typical sign that it has not run is that the stock quantity in units of measure is correct, while the value in currency is not. The article on incorrect balance value on a stock card describes this in more detail.

⚠️ The recalculation time depends on the volume of data and can take a very long time for large warehouses. Run the manual recalculation when no users are working in Flexi, typically over a weekend or at night. You cannot work with the warehouse while it is running. Since version 2026.6.0, the recalculation is significantly faster.

What the recalculation does not fix

The recalculation works with issue prices. It therefore does not fix everything that is wrong in a warehouse:

  • Prices on goods receipts are not changed by the recalculation. The receipt price is entered by the user, and the recalculation merely uses it as a starting point. This also applies to manually created negative receipts, which behave like an issue but whose price was set by the user. The recalculation therefore neither removes nor corrects them. An incorrect receipt price must be corrected directly on the goods receipt or on the document from which it originated.

  • Goods issues with a manually entered price. If the price on a goods issue was set via the REST API using the flag cenaRucne, the recalculation does not overwrite it.

  • Consequences of changing the inventory valuation method. A change of method always applies as of a certain date, so the recalculation uses one method up to that date and the other from that date onward. The difference on the card is therefore not caused by an error in the recalculation, but by the fact that two methods are mixed on a single card, and it inevitably has to remain. A typical sign is zero units and a non-zero remaining value in currency.

  • Unsettled issue requests are not removed by the recalculation. Only the Update Issue Requests function is intended for those.

  • A difference in the actual quantity in stock is resolved by a stocktaking, not by the recalculation.

ℹ️ The exception is a goods receipt that completes a transfer. A transfer begins with an issue from the source warehouse, and the price of the receipt is derived from the price of that goods issue. If the recalculation changes the price of the goods issue, the change is also reflected in the price of the linked goods receipt. This is the only type of goods receipt whose price the recalculation can adjust.

Before you run the recalculation, always make sure you know the cause of the difference. Running it across the board "just in case" usually does not solve the problem and only blocks the warehouse for a long time. The article on diagnosing incorrect stock prices describes how to identify the cause.

Recalculation and accounting periods

Stock cards are maintained separately for each accounting period. The stock recalculation therefore always works only in the period you are currently switched to.

If you correct prices in a previous year, the correction is not carried over to the following year automatically. You need to run the initialization of the following accounting period again with the Perform stock transfer option selected. This carries the corrected closing balances over to the opening balances of the new year. If the problem spans multiple years, you must repeat this procedure for each period separately: recalculation, initialization, recalculation, and so on, up to the current year.

🚨 Intervening in closed periods has accounting implications

The recalculation may change not only the value on the stock card in a given period, but also the balance on the inventory account. If financial statements or tax returns have already been filed for the affected years, they will no longer match the data in the system after the intervention, and you would need to file corrected statements for each affected year.

Before making any changes to a closed period, always consult your accountant about the impact first.

Related articles

Back to the overview page.

Did this answer your question?