↑↓ selectEnter openEsc close

    1. Elbuz

    How to manage stock, transfers and stock counts in Elbuz

    12 min readUpdated

    Stock management in Elbuz counts each product's stock in each warehouse from posted documents and logs every change: who made it, when and with which document.

    When you need this:

    • Products sit in several places — each has its own stock, purchase and sale prices.
    • Stock doesn't match the shelf — a stock count fixes it and logs the difference.
    • Several customers want one product — posted orders reserve it, and free stock is visible in advance.
    • Your website should show your stock — quantity and price go from the warehouse to the catalog.

    Where to start: choose your working scheme, then add a warehouse and mark it “Main”.

    What stock management can do

    Start with your working scheme

    The working scheme decides whether Elbuz tracks your stock. You choose it in the “How do you work?” wizard: it opens by itself in the documents window until a scheme is chosen.

    Where: documents window → burger menu → “Working scheme”.

    “How do you work?” dialog with the Dropshipping and Supplier / wholesale schemes ticked
    1Dropshipping
    2Own warehouse
    3Supplier / wholesale
    4Tick several schemes
    5How to run a stocktake
    1. The supplier ships from their warehouse, so your own stock is not tracked.
    2. Turns on warehouse accounting: reserves, free stock and shortages.
    3. Warehouse accounting plus shipping and payment in parts.
    4. Tick several schemes if you work in a mixed way: the features add up.
    5. How a stocktake changes the balance: set to counted, or through surplus and write-off acts.
    The three schemes and what each turns on
    SchemeWhen it's yoursWhat it turns on
    Dropshippingthe supplier ships products from their own warehousenothing: your own stock isn't tracked
    Own warehouseproducts are with you, an order goes out as one parcelstock quantity tracking
    Supplier / wholesaleyou ship to dropshippers or sell wholesalestock tracking, partial shipments and partial payments

    If you work in a mix, tick several schemes, and the features you need turn on together. For example, a supplier ships some products and you ship others from your own warehouse: tick “Dropshipping” and “Own warehouse”.

    Stock quantity tracking adds reservation for posted orders, free stock and low-stock warnings, and with it a customer return puts products back in the warehouse. Without it, warehouses, receipts, write-offs and transfers work as usual. For dropshipping, keep tracking off: otherwise the system will show shortages of products you aren't supposed to have.

    You can change the scheme any time with the same menu item. The same switches also exist one by one in system settings:

    • “Stock quantity tracking” — the “Warehouse accounting” section;
    • “Partial shipments” and “Partial payments” — the “Documents and accounting” section.

    Further down in the wizard you choose how a stock count changes stock. What the scheme turns on in orders is covered in the customer order article.

    What a warehouse is and what it isn't

    A warehouse in Elbuz is the place where your products physically are. Each “warehouse + product” pair has its own stock quantity, its own purchase and sale prices and its own movement history. You can have several warehouses; one of them is marked “Main” — it takes the reservation of orders where no warehouse was chosen explicitly.

    Two related things have similar names. belongs to the “Shops” directory: it's about which products to show in a storefront, not how many are in stock.

    Availability in a supplier's price list (“+”, «багато» (“many”), «3 и более» (“3 or more”)) has nothing to do with your warehouse — see the article on product availability in a supplier price list.

    How to add a warehouse

    Open Directories → Base product catalog → Warehouses and click the plus button in the toolbar (tooltip “Add”). The row appears right away and is saved immediately as “New warehouse #N”; Elbuz opens the name cell for editing. The whole grid is edited by double-clicking; there is no “Save” button: a change goes to the server as soon as you leave the cell.

    The rest of the toolbar is the trash can, the cube (“Products in all warehouses”) and the menu with “Refresh” and “Clear filter”. Each row starts with navigation icons: the cube opens this warehouse's products, the truck opens its movement log, the blocks (with batch tracking) open batches.

    The Warehouses window with the toolbar and the list of warehouses
    1Products in warehouse
    2Warehouse stock movements
    3Main warehouse flag
    4Total products
    5Products in all warehouses
    1. The cube icon in a row opens the products stored in that warehouse.
    2. The truck icon in a row opens the stock movement log of that warehouse.
    3. The Main column marks the default warehouse.
    4. The Total products column shows how many products are in stock in each warehouse.
    5. The cube button in the toolbar opens products across all warehouses.
    Warehouse directory columns
    ColumnWhat it does
    ActiveAn inactive warehouse disappears from selection lists and from the stock matrix; its data stays in place.
    MainThe warehouse that takes an order's reservation if no warehouse is chosen in the order.
    Warehouse nameThe name the warehouse appears under in selection lists and documents.
    Total at catalog prices, Total productsValue (quantity × catalog product price) and total quantity — over rows with stock above zero.
    Export to file, websiteWorks only when exporting via Elbuz Tunnel, and only when warehouse transfer is enabled in the template.
    VirtualJust a flag: it's saved and sent to the website along with the warehouse list, but no Elbuz feature takes it into account. Stock in such a warehouse is counted, summed and exported the same way as in a regular one.
    Other columnsDescription, coordinates, address, sort order in lists, and .

    The “Total at catalog prices” column here uses the catalog product price, while “Total at warehouse prices” in the “Products in warehouse” window uses the warehouse sale price. The two numbers almost never match: pick one and compare against it.

    The “Warehouse selection” window is the same warehouse directory in selection mode: highlight a row and click “Select”, and the warehouse is filled into the field you opened the window from. Its columns and rules are the same.

    Deleting a warehouse

    The trash can in the toolbar asks “Delete entry?”, shows the warehouse ID and name and warns: “All stock of this warehouse will be deleted along with it, together with purchase and sale prices. This cannot be undone.” If the warehouse has positive stock, it is followed by “The warehouse stock will be deleted with it: N units.”

    N is the total units of product in the warehouse, rounded up; rows with zero or negative stock aren't included in this number, but they're deleted too. If no row is selected, you'll see “Select a row!”.

    Deleting a warehouse deletes all its stock — the “warehouse + product” rows with quantities and prices. There is no trash or recovery for them. If you no longer need a warehouse, clear its “Active” checkbox: it leaves the selection lists, and the data survives.

    Elbuz never deletes a warehouse marked “Main”: you'll get “The default warehouse cannot be deleted - make another one default first.”, and the row stays in place. To remove it, first clear its “Main” checkbox.

    Which documents change stock

    Stock is a number in a “warehouse + product” pair. Only posting a document of one of the nine types below can change it. Everything else (drafts, statuses, comments) doesn't affect it. Each such change leaves a row in the movement log.

    There are three exceptions to this rule, and all three can quietly distort the picture: a manual edit in the product card, a warehouse linked to a price list, and the “Clear warehouse stock” switch (warehouse → catalog and website).

    The path from a document to a new number in the warehouse
    Purchase invoice, StockpostingSales invoice, Salesreceipt, Return to supplier,Write-offStock transferStock count“Unpost” — the movementis rolled back, a reverse rowappears in the logCreated a warehouse document andadded productsDraft: stock hasn't changed“Post”What document type is itDestination warehouse stock goesupSource warehouse stock goes downAt the same time: down at thesource, up at the destinationStock becomes equal to the countedquantityA row in the “Warehouse stockmovements” logNew number in the “Products inwarehouse” windowThe line price becomes theproduct's purchase price
    • Action or result
    • Decision: the path depends on the answer
    Documents that move stock
    Document typeWarehouse field to fillWhat posting does
    Purchase invoiceDestination warehouseadds quantity
    Stock postingDestination warehouseadds quantity
    Sales invoiceSource warehousesubtracts quantity
    Sales receiptSource warehousesubtracts quantity
    Return to supplierSource warehousesubtracts quantity
    Write-offSource warehousesubtracts quantity
    Stock transferBothsubtracts from one, adds to the other
    Stock countDestination warehousesets stock to the counted quantity
    Return from customerDestination warehouse, only with stock tracking onadds quantity; if the field is empty, stock doesn't change

    The warehouse fields appear in the card depending on the document type and sit in the “Additional” section. They're drop-down lists of active warehouses; an empty warehouse field stops posting. The exception is a customer return: without a warehouse it posts but doesn't change stock.

    • Lines for the same product add up. The same product on two lines changes stock once, by the total.
    • A set moves stock through its components. The set itself has no stock (sets in warehouse documents).
    • Unposting reverses the movement. The log doesn't delete the old row; it adds a new, reverse one — history isn't rewritten.

    How a warehouse reserves products for orders

    Reservation is the quantity held by posted customer orders. Nothing physically leaves the warehouse, but free stock goes down: it equals stock on hand minus reserved. Reservation is stored in the same place as stock — in the “warehouse + product” pair.

    Three conditions are required for any reservation at all: stock tracking is on, there's at least one active warehouse, and the order is posted. The order reserves stock in the warehouse from its “Reservation warehouse” field. From there, reservation is an order topic: which twelve statuses release it and why “Paid” isn't among them is covered in reservation and free stock.

    A customer order never changes warehouse stock, no matter how many times you post it. Products are written off by a sales invoice created from the order.

    Your first warehouse: checklist

    From an empty directory to correct stock

    Scenarios

    Move what's on your shelves into Elbuz, then receive deliveries with documents

    What to do. In the “Warehouses” directory, add a warehouse and check “Main”. In the documents window, “Inventory” workspace: “Add” → “Stock count”; set “Destination warehouse” to this warehouse and enter the quantities you counted on the shelves. Post it. Record every later delivery as a “Purchase invoice” with the same destination warehouse and purchase prices, and post it too.

    What you get. The stock count sets stock equal to what you counted and logs the difference as a movement. A product not yet in the warehouse gets a row, and its whole quantity is recorded as a surplus. Posting a purchase invoice adds quantity and writes the line price both to the warehouse purchase price and to the product's “Cost price”. The invoice fills the warehouse sale price only where it's empty.

    What won't happen. The quantity in the product card and on the website won't change by itself — the “Sum stock across warehouses” switch carries it over. There's no order reservation until “Stock quantity tracking” is on.

    You no longer need a warehouse but want to keep its history

    What to do. In the “Warehouses” directory, clear the warehouse's “Active” checkbox instead of deleting it.

    What you get. The warehouse disappears from selection lists and from the stock matrix, while its stock, prices and movement log stay in place.

    What won't happen. If you delete the warehouse with the trash can, all its stock and prices go with it — there's no recovery for them (deleting a warehouse).

    What to do when something goes wrong

    Common problems
    What you seeWhyWhat to do
    “The default warehouse cannot be deleted…” The warehouse is marked “Main” — such a warehouse can't be deleted Clear its “Main” checkbox, or clear “Active” instead of deleting (deleting a warehouse)
    “Deletion failed” The server didn't accept the deletion — for example, your role has no permission to delete Refresh the grid from the menu and try again; if that doesn't help, check the role's permissions
    “Select a row!” You clicked delete without selecting a row Click a row and try again

    FAQ

    Do I need a warehouse if I do dropshipping?

    No. In the “Working scheme” wizard, tick only “Dropshipping”: stock tracking stays off, and product availability comes from supplier price lists. If you keep some products yourself, also tick “Own warehouse” (working scheme).

    How do I enter opening stock?

    With a stock count: “Add” → “Stock count”, destination warehouse, products, and in the quantity column — what you actually counted. Don't type stock by hand in the product card: a catalog update from price lists can overwrite it (stock count).

    How do I edit a warehouse — change its name or address, or make it the main one?

    In the “Warehouses” directory, double-click a cell: name, description, address, coordinates, the “Active”, “Main” and “Export to file, website” checkboxes. The change is saved as soon as you leave the cell. Product quantities can't be edited here — documents change them (warehouse directory).

    The default warehouse can't be deleted. What do I do?

    Mark another warehouse “Main” and clear the checkbox on this one — then the trash can will delete it. All its stock and prices go with the warehouse, with no recovery. If you just don't need the warehouse, clear “Active” (deleting a warehouse).

    How is a warehouse different from a shop?

    A warehouse answers “how much of a product do you have” and is changed by documents. A shop answers “which products to show in this storefront”. These are separate directories, and quantity in a shop isn't linked to a warehouse.

    Can a warehouse hold fractional quantities, such as 2.5 kg?

    No. Quantity is a whole number both in documents and in the warehouse: 2.5 kg on an invoice becomes 3. You can't track goods sold by weight or length in a warehouse.

    Where it is and who has access

    Menu
    Directories → Base product catalog → Warehouses
    Other ways in
    documents window menu → “Dictionaries” → “Warehouses”; the “Warehouses” row in the product card
    Warehouse documents
    Directories → Documents → Inventory; there is a desktop shortcut
    Settings
    Account → System settings → “Warehouse accounting” section
    Access right
    the “Warehouses” window; posting documents — the “Sign button” permission
    Prepare
    products in the base catalog

    Warehouses live in a directory, while product movements live in documents. These are two separate windows, and you'll switch between them. The “Warehouses” window has no desktop shortcut — open it from the menu or from the documents window menu.

    Left menu with the “Base product catalog” group expanded, showing the “Warehouses” item
    1Warehouses
    1. Warehouses — the directory of the warehouses themselves, in the “Base product catalog” group.

    The “Warehouses” window has a single access right — for the window itself. There are no separate rights for the buttons inside: anyone who can open the window can create a warehouse, rename it and delete it together with all its stock. “Products in warehouse”, “Product batches in warehouse” and “Warehouse stock movements” open from the directory and have no right of their own.

    Product movement itself is restricted from the other side — in the documents window. The “Inventory” workspace has its own access right, while the “Add button”, “Delete button”, “Edit button” and “Sign button” permissions apply to the whole documents window: if you deny “Sign button”, you deny posting both orders and financial documents.

    “Sign button” is exactly the permission to move stock: without it, an employee can create an invoice but can't post it. For details, see group permissions.

    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