Understand stock row locking | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/ecommerce-pos-understand-stock-row-locking Publisher: Pixie Technologies LLC Inventory, availability and immutable movements Understand stock row locking Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. This guide explains that that stock updates lock the balance inside a database transaction. Audience: Inventory controllers and authorised managers; Permission: Enterprise POS: Manage inventory; Module v1.0.0 · code-inspected; Where to goEnterprise POS → Inventory What this guide helps you do Know that stock updates lock the balance inside a database transaction. This section covers the live stock list, availability calculation, manual adjustments and append-only movement evidence. Follow these steps - Go to Enterprise POS → Inventory and open the workflow that matches “Understand stock row locking”. Confirm the page or record context before making a change. - Select a location and optionally search inventory. - Check on-hand, reserved and reorder indicators. - Select a tracked product. - Enter a non-zero delta, an approved reason code and a mandatory note. - Post the adjustment. - Check the balance and new immutable movement row. Fields and options - Guide focus: Know that stock updates lock the balance inside a database transaction. - On hand - Reserved - In transit - Quarantined - Damaged - Reorder level - Available quantity - Adjustment delta - Reason code - Mandatory note - Source type and source identifier Rules and limits - Available equals on_hand minus reserved minus quarantined minus damaged. - In_transit is stored but is not included in the available formula. - Manual UI adjustments change on_hand only. - Tracked active products and tenant locations are required. - Negative stock is blocked unless the product allows backorder. - Movements are appended rather than edited. Check it worked - The specific outcome described by this guide is visible and remains tenant-scoped. - Stock balance and movement agree after a committed transaction. - Sales, returns, purchases and adjustments leave correlated evidence. - Public availability uses the configured default location. Safety checks and troubleshooting - Use reason-specific, meaningful notes. - Do not edit or delete movement history. - Investigate reserved/quarantined/damaged values through supported workflows; the supplied inventory screen does not directly edit them. Stay within the supported module flow Use the supplied UI, host module lifecycle and documented endpoints. Do not bypass tenant filters, permissions, CSRF, idempotency, rate limits, audit evidence or transaction checks. A stored table or field does not imply that version 1.0.0 exposes a management screen for it. Related guides eCommerce & POS Module overview (https://pixiecrm.com/help-centre/ecommerce-pos-module-overview)Understand immutable inventory history (https://pixiecrm.com/help-centre/ecommerce-pos-understand-immutable-inventory-history)Understand initial stock rows (https://pixiecrm.com/help-centre/ecommerce-pos-understand-initial-stock-rows)Understand backorder behaviour (https://pixiecrm.com/help-centre/ecommerce-pos-understand-backorder-behaviour)Understand stock handling for non-tracked products (https://pixiecrm.com/help-centre/ecommerce-pos-understand-stock-handling-for-non-tracked-products)Understand POS money calculations (https://pixiecrm.com/help-centre/ecommerce-pos-understand-pos-money-calculations)Create a supplier (https://pixiecrm.com/help-centre/ecommerce-pos-create-a-supplier)Browse the connected Inventory, availability and immutable movements topic (https://pixiecrm.com/help-centre/topic/ecommerce-pos-inventory)Browse all eCommerce & POS Module guides (https://pixiecrm.com/help-centre/category/ecommerce-pos)Open the related Help Centre category (https://pixiecrm.com/help-centre/category/inventory-warehousing-management-system)