↑↓ selectEnter openEsc close

    1. Elbuz

    How to check warehouse stock and find out where a product went

    4 min readUpdated

    Elbuz shows stock per warehouse and in total; the movement log records every quantity change: date, document, quantity before and after.

    When you need this:

    • Finding where a product is — the “Products in warehouse - All” matrix shows quantity per warehouse.
    • Stock looks wrong — the “Warehouse stock movements” log shows which document changed it.
    • Fixing one number — the “Warehouses” row in the product card, also logged.
    • A product may run out soon — the “Stock forecast, days” column shows how many days it lasts.
    • Time to reorder — draft supplier orders every morning.

    Where to start: the “Warehouses” directory → the cube icon in the warehouse row.

    What stock views and the log can do

    • Products in warehouse — quantity, purchase and sale prices, margin and forecast for one warehouse.
    • Matrix across all warehouses — one row per product, one column per warehouse.
    • Movement log — every quantity change with its document and the quantity before and after.
    • Manual edit — a one-off stock change in the product card without a document.
    • Automatic reorder — draft supplier orders every morning for whatever will run short at the current sales rate.

    How to view stock in one warehouse and in all of them

    The cube icon in the warehouse row opens “Products in warehouse - ‹name›”: one row for each product in that warehouse.

    Columns for a single warehouse
    ColumnWhat it shows
    QuantityCurrent stock.
    Quantity before, Quantity changeThe state after the last operation, not the history. For the history, use the movement log.
    Stock forecast, days; Number of sales per day (average)Work only when the “Stock forecast” setting is on — and it lives in the “Catalog update” section, not in “Warehouse accounting”. The 30-day average consumption is stored as a whole number, so with slow sales it rounds down to zero, and the forecast with it.
    Purchase price, Sale priceThe purchase price is written when a receipt is posted; the sale price is this product's price in this warehouse.
    Margin, %A calculation, not a stored field: you can't filter or sort by it.
    Total at warehouse pricesSale price × quantity.
    Window «Products in warehouse» for the Central warehouse with stock, prices, margin and total columns
    1Quantity
    2Purchase price
    3Sale price
    4Margin, %
    5Total at warehouse prices
    1. Quantity — how many units of the product are in this warehouse.
    2. Purchase price — the cost price of one unit.
    3. Sale price — the selling price of one unit.
    4. Margin, % — the margin between the purchase and sale price.
    5. Total at warehouse prices — the stock value of the row.

    The cube button in the toolbar opens the matrix — the “Products in warehouse - All” window (the button tooltip says “Products in all warehouses”). It has one row per product and one column for each active warehouse, with the quantity in each cell, so you can see exactly where the item is.

    Window «Products in warehouse - All»: a matrix with one quantity column per warehouse
    1First warehouse column
    2Second warehouse column
    3Product name
    1. The first warehouse column shows the quantity of each product in that warehouse.
    2. The second warehouse column shows the same for the next warehouse.
    3. Product name — the row key; to the right, each warehouse has its own column.

    The matrix shows only products with stock above zero in at least one warehouse. A product that has run out everywhere, or has gone negative, won't appear in it at all. To see zeros and negatives, open a single warehouse with the icon in its row.

    Both tables are read-only: you can't edit stock here, and there's no export to a file.

    How to find which document changed the stock

    The truck icon in the warehouse row opens the log — the place to go when stock doesn't match what you expect. Each row is one quantity change: the date, product name, document type and number, quantity before and after, and the size of the change.

    Window «Warehouse stock movements» for the Central warehouse: documents, quantities and posting status
    1Document Type
    2Quantity
    3Quantity before / after
    4Posting (signature) status
    5View document icon
    1. Document Type — which kind of document made the movement (stock count, transfer, sales invoice).
    2. Quantity — the signed change: minus for outgoing, plus for incoming.
    3. Quantity before and Quantity after — the stock level around the movement.
    4. Posting (signature) status — a tick means the document is posted.
    5. The icon in the first column opens the document (not clicked).

    The pencil at the start of a row opens the document itself. The “Posting (signature) status” column is a checkbox: checked means the row was written by posting, unchecked means by unposting. If the product was later deleted from the catalog, the log keeps its name from the document line.

    Besides documents, the log records manual quantity changes made in the product card: such a row has no document type or number, and its “Posting (signature) status” checkbox is cleared. Changes from price lists and catalog updates don't go into the log — manual edits are covered in the next section.

    How to fix stock in the product card

    The product card has a “Warehouses” links row: a list of all warehouses, each with a “Keep product” checkbox, price, availability and quantity. Double-click a cell to edit it. This is the only way to change stock without creating a document.

    A quantity change here is written to the “Warehouse stock movements” log as a row without a document, showing the quantity before and after. Changing the price or availability status without changing the quantity isn't logged.

    Clearing the “Keep product” checkbox deletes the whole warehouse row, along with its quantity, price and availability status. If there was stock in the warehouse, the app asks first: “Clear the “Keep product” checkbox? The warehouse row will be deleted along with its stock (N pcs), price and availability status. This cannot be undone.”

    After you confirm, the log keeps a row with the old quantity, but the product's warehouse entry can only be restored by hand: check the box again and enter the quantity and price.

    Use this route only for a one-off fix to a single cell. Enter opening stock with a stock count: the result is the same, but you get a movement in the log and a document whose posting can be reversed.

    Scenarios

    Stock has gone negative

    What to do. Open the warehouse movement log and go through this product's rows from top to bottom.

    What you get. Almost always you'll find an unposted receipt or an outgoing document posted twice. Fix the number itself with a stock count for this product.

    A customer asks if an item is in stock, and you have several warehouses

    What to do. In the “Warehouses” toolbar, click the cube button “Products in all warehouses”.

    What you get. The matrix shows the product quantity in each active warehouse. If the product isn't in the matrix, it has no stock above zero anywhere.

    What to do when something goes wrong

    Common problems
    What you seeWhyWhat to do
    A negative number in the “Quantity” column More was written off than received: a receipt isn't posted or an outgoing document was posted twice Look for the cause in the movement log from top to bottom, and fix the number itself with a stock count for this product
    The product isn't in the “Products in warehouse - All” window The matrix shows only stock above zero Open the warehouse separately with the cube icon in its row (products in warehouse)

    FAQ

    Why did the stock I entered in the product card disappear?

    Most often this warehouse is selected in the price list's “Link products to warehouse” field, and a catalog update overwrote it with the supplier's data. Or “Clear warehouse stock” is turned on (warehouse and catalog update).

    Can I export warehouse stock to a file?

    No. There's no export button in the warehouses directory, in products in warehouse, or in the movement log.

    Why is the total in “Products in warehouse” different from the one in the warehouses directory?

    The warehouses directory calculates the total using the product's catalog price, while “Products in warehouse” uses the warehouse sale price. Compare against one of the two numbers.

    Why is the stock forecast zero?

    The forecast works only when “Stock forecast” is turned on in the “Catalog update” section. Average consumption is stored as a whole number, so with slow sales both it and the forecast round down to zero.

    Do changes from price lists go into the log?

    No. The log is written by posted documents and by manual quantity changes in the product card. Catalog updates from price lists don't create movements.

    Where to find it and who has access

    Menu
    Directories → Base product catalog → Warehouses → icon in the warehouse row
    Other entry points
    the “Warehouses” links row in the product card
    Access right
    the “Warehouses” window; these windows have no access right of their own

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free