The value in currency on the stock card does not match the quantity in units of measure. Typically, this shows up as a zero balance in units of measure with a non-zero value in CZK, or as an average price that gets applied incorrectly on an issue note. This article summarizes the three most common causes and how to fix them.

Before starting the fix, identify which cause applies based on the symptoms you're seeing:

From time to time, we encounter cases where users manually create receipt notes with a negative quantity. Manually creating such a receipt note is likely to cause an incorrect stock inventory value.

Unlike a receipt note with a positive quantity, a receipt note with a negative quantity effectively issues the item from stock. If the correct price according to the inventory valuation method is not used in such a case, the result will be an incorrect value on the stock card.

Users typically try this approach when goods were received incorrectly. By creating a receipt note with a negative quantity at the same price, they attempt to correct the situation by issuing the goods at the same price. However, this may not be the correct approach - if there is also earlier stock on the stock card, the price is likely incorrect.

In all cases where you need to remove stock as a correction, do so using an issue note. However, the best tool for correcting stock is always an inventory count.

Such a receipt note only makes sense when it is created from a credit note. In that case, ABRA Flexi automatically selects the correct price at which the goods should be issued from stock.

If you issue goods from stock in the standard way (i.e., by creating an issue note), ABRA Flexi automatically assigns the price according to the inventory valuation method. At the same time, the user cannot manually adjust the price. This ensures that the goods were issued at the correct price.

In the screenshot below, we can see an issue note line item whose stock card has 10 units received at 200 CZK/unit and 10 units received at 300 CZK/unit. The average price is therefore 250 CZK. If we were now to issue any number of units via an issue note, we can be sure the price is correct.

So let's issue, for example, 5 units from stock using an issue note.

Creating a receipt note, however, works on a different principle - the user always has the option to set the price of the receipt note line item. This also applies to a receipt note with a negative quantity. In such a case, it's likely that the user won't use the correct price according to the valuation method.

So what would happen if we tried to return the second receipt of 10 units at 300 CZK/unit to stock by creating a receipt note with a negative quantity at 300 CZK/unit?

If this situation occurs, the item will be issued at a price that differs from the price according to the valuation method, causing the stock card value to become inconsistent.

We can observe this when creating another issue note. If we add the item to it, the price of 150 CZK/unit will be filled in automatically. However, this price is incorrect. The average price of the item should be 250 CZK/unit.

The result of this approach will be distorted costs throughout the accounting period.

If this situation has already occurred, the solution is to replace these receipt notes with an issue note, or to enter the correct price in the receipt notes according to the valuation method. However, this isn't always possible. If the problem extends into previous periods, especially those already closed for accounting purposes, this approach cannot be applied. In that case, we recommend creating a receipt note with zero quantity to correct the stock card price in the current year.

This situation is usually observable as a non-zero stock card value combined with a zero balance in units of measure.

Let's demonstrate this again using an example, i.e., for the same stock card that has 10 units received at 200 CZK/unit and 10 units received at 300 CZK/unit, we'll create a negative receipt note for the entire stock.

Since the original stock value corresponded to 5,000 CZK, and we issued stock worth 6,000 CZK via the receipt note, the stock card will end up with a negative stock balance and a zero balance in units of measure.

The fix is the same as in the previous case - replace the incorrect receipt notes with an issue note, or enter the correct price in the receipt notes according to the valuation method. However, this isn't always possible. If the problem extends into previous periods, especially those already closed for accounting purposes, this approach cannot be applied. In that case, we recommend creating a receipt note with zero quantity to correct the stock card price in the current year.

The price on an issue note is never entered manually. It is always calculated by ABRA Flexi according to the configured inventory valuation method, since it represents the actual cost of the issued goods and must match what was paid to acquire them. If a price appears on an issue note that doesn't match the valuation method, the balance in units of measure will still be correct, but the value in CZK will diverge.

The most extreme and noticeable case is an issue note with a zero price. Example: we always receive goods at the same price, e.g., 15,000 CZK, and usually issue them at the same price as well. However, when calculating the stock balance as of a given date, the Stock balance in units field shows 1 unit, while the Stock balance in CZK field shows 45,000 CZK. The quantity was deducted, but the value was not. Any other incorrect amount will manifest the same way, but it tends to be harder to spot.

Open the Goods module - Stock cards - find the relevant card and open it. At the bottom of the stock card, you'll find all receipts and issues of goods in the current accounting period. Compare the prices on the issue notes with what the valuation method should return. An issue note with a zero or otherwise mismatched price is the cause you're looking for.

In the application, the Price per unit field on an issue note is for informational purposes only and cannot be edited. This is an intentional restriction: if the price could be overwritten, the stock value would no longer match the value of stock movements.

However, via the REST API, there is a flag cenaRucne that technically allows manual entry of the price on an issue note and writing the value directly. This is the most common way incorrect prices end up on issue notes, typically during data integration or migration.

At this point, you need to go to the Tools module and run the Stock recalculation function, which will fill in the price on the issue notes according to the valuation method, and the stock value in CZK will be balanced.

If the incorrect price got onto the issue note via the API with the cenaRucne flag active, verify after the recalculation that the value on the card has actually been corrected. At the same time, stop the source of the error - the integration that sets the flag. Without this, the discrepancy will reappear after the next write.

The combination of zero balance in units of measure and a non-zero value in CZK doesn't always originate from a negative receipt note. Another common cause is changing the inventory valuation method on a warehouse where movements have already occurred. Older movements remain valued according to the original method, while newer ones follow the new method, so the total value won't reach zero even after all units have been issued.

I can't delete an incorrectly created receipt note.

The cause is described in our guide.

My stock inventory value doesn't match, but the prices on the receipt notes are correct.

A stock recalculation may help - it checks the prices on receipt notes and applies them to issue notes.

Why did the price on the issue note change by itself?

This isn't necessarily an error. The value legitimately changes after issue requests are settled and after the price on the receipt note is retroactively changed. This situation is described in the article Changing the value on an issue note.

The stock recalculation didn't fix the problem. What now?

The recalculation fills in prices, but it doesn't fix a manually created negative receipt note or the consequences of changing the valuation method. In these cases, follow the relevant section above.