How does Apicbase determine which value goes in and out of stock?

Apicbase does a lot of behind-the-scenes actions to manage your inventory. This article gives you a bit more insight into which values are used for your stock movements.

Subtracting stock

  • When items are taken out of stock, we work in FIFO. The items that came into your stock first, are taken out of stock first.
  • Stock can be subtracted by
    • Sales
    • Waste
    • Transfer (out)
    • Creating stockable recipes: ingredients are taken out of stock
    • Uncontrolled loss (subtracted stock through count): Less stock was counted than there was in stock according to Apicbase.
In the following example, we follow the stock of our stock item/package Chardonnay 75cl. The opening stock is 0:

Action Quantity Value Remaining Stock
Order 6 6x25€= 150€ 6 (Value= 150€)
Sell 3 3x25€= 75€ 3 (Value= 75€)
Waste 2 2x25€= 50€ 1 (Value= 25€)
Order 6 6x24€= 144€ 7 (Value= 169€)
Sell 4 1x25€ + 3x24€= 97€ 3 (Value= 72€)

So in the last row, you see that we had one bottle left from the first order that cost us 25€ and the other 3 we took from the new order, where we paid 24€ per bottle.

Adding stock

  • Stock can be added in three ways
    • Ordering: the value is added according to the price you register when receiving the orders.
    • Transfer (in): the value is added according to the price that was registered during the intake in the sending outlet.
    • Uncontrolled gain (added stock through count): In this case, we use the price of the last ordered package. We can’t know for sure what is the value of the extra packages so the best approximation we have is to consider the last ordered package.
    • Creating stockable recipes: The stockable recipes are added to your stock. The value of the stockable recipe is added according to the depleted ingredients used on its preparation plus the personnel cost.