# How to Find and Fix Negative Quantity on Hand in SYSPRO > Source: https://netray.co/erp-help/syspro-negative-inventory-quantity-on-hand-fix > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer Negative on hand in SYSPRO means more stock was issued, shipped or consumed than was ever received into that warehouse. It is almost always a timing or receiving problem, not corrupt data. Find the movements that drove the balance below zero, fix the receiving or unit-of-measure root cause, and then correct the quantity with a proper inventory adjustment so costs stay consistent. ## Kind how-to ## System small-erp ## Erp SYSPRO ## Module Inventory Control / Warehouse Quantities ## Query SYSPRO negative inventory quantity on hand how to fix ## Alternate Queries - SYSPRO negative stock on hand - SYSPRO negative quantity on hand warehouse - SYSPRO allow negative stock setup option - why is SYSPRO stock negative after job issue ## Applies To SYSPRO 7 and SYSPRO 8 on SQL Server; behaviour depends on the negative stock setting in your inventory setup options and on lot, serial and bin tracking ## Steps ### Steps to diagnose and correct negative stock **Items:** - List the affected stock codes and warehouses with a read-only query on the InvWarehouse table where QtyOnHand is below zero. - For each one, open Inventory Query and review the movements, or query InvMovements, ordered by date, to see which transaction took the balance below zero. - Classify the cause: goods received after the issue (timing), receipt posted to the wrong warehouse, wrong unit of measure or stocking conversion, job material issued but never purchased, or a cancelled receipt. - Fix the root cause first. Move a mis-posted receipt with a warehouse transfer, correct the stocking unit of measure, or post the missing goods receipt with its true date and cost. - If the physical stock is really present and the book quantity is wrong, post an adjustment in the Inventory Quantity Adjustments program with a reason code, valued at a sensible cost. - Check lot, serial and bin balances too; a stock code can show positive in total and still have a negative lot or bin. - Review the inventory setup option that permits negative stock and decide whether it should stay enabled, given what you found. - Rerun the query and keep it as a scheduled exception report. ## Sections ### Why it happens in practice **Body:** SYSPRO can be configured to allow stock to go negative so that the shop floor is never blocked by a late goods receipt. The trade-off is that negative balances hide receiving lag. The usual patterns are job material issued from a bin before purchasing received the delivery, backflushed components with a bill of materials that does not match what operators really consume, and sales shipped against stock that was physically present but not yet booked in. A second cluster is unit-of-measure errors. If a part is stocked in each but purchased in boxes of twelve, a missing or wrong conversion on receipt leaves the book quantity far too low, and the first few issues push it negative. ### Finding the transaction that crossed zero **Body:** Run the exception list first, then drill into each item. The goal is the single movement where the running balance first crossed zero, because that is where the process failed. Fixing symptoms across fifty items without grouping by cause just recreates the problem next week. Table and column names below match common SYSPRO SQL Server schemas, but check them against your version in the data dictionary reference before relying on them. Run queries read-only and outside peak hours on large company databases. **Code:** - SELECT StockCode, Warehouse, QtyOnHand FROM InvWarehouse WHERE QtyOnHand < 0 ORDER BY QtyOnHand; ### Correcting it without damaging costs **Body:** An adjustment that brings a negative balance to zero without a matching receipt can leave cost of sales understated or the inventory control account out of line with the sub-ledger. Where possible post the missing receipt, so the movement carries a real cost, rather than a free adjustment in. Where the physical count disagrees with the book, a stock take is cleaner than a series of ad hoc adjustments because it timestamps the correction and gives an audit trail. Agree the cost basis with finance before posting large corrections, and reconcile the inventory ledger control account afterwards. ### Keeping it from coming back **Body:** Decide per warehouse whether negative stock should be allowed. Production floor and scrap warehouses often tolerate it; finished goods and consignment warehouses should not. Whatever the policy, run the exception query daily and assign an owner, so a negative balance is a task for the day it appears. ## Pitfalls - Zeroing out negatives with adjustments before finding the cause, which hides a receiving or unit-of-measure problem. - Checking only total stock and missing negative lots, serials or bins. - Adjusting at zero cost, which skews average or standard cost and the inventory ledger. - Fixing a mis-posted receipt in the wrong period after the period has been closed. - Turning off negative stock company-wide and halting the shop floor without fixing receiving lag first. ## Ai Angle An assistant grounded in SYSPRO can run the negative-stock query on a schedule, trace each item back through its movements to the transaction that crossed zero, and group the findings by likely cause such as late receipt, wrong warehouse or unit-of-measure mismatch. It presents the query and the movements it used, and proposes the adjustment or transfer for a person to approve rather than posting anything itself. ## Faq ### Is negative stock a sign of database corruption? **Answer:** Almost never. It is nearly always a business process cause: issues before receipts, receipts in the wrong warehouse, or unit-of-measure conversion errors. Treat it as an exception report to be worked, and look at corruption only if movements do not add up to the stored quantity. ### Can I stop SYSPRO from allowing negative stock? **Answer:** Yes, there is an inventory setup option that controls it, and it can be combined with warehouse-level controls depending on release. Switching it off makes transactions fail instead of going negative, so fix receiving timing first or operators will be blocked at the point of issue. ### Why does a stock code show positive total but negative in one warehouse? **Answer:** SYSPRO stores quantities per warehouse, so a surplus in one location can mask a deficit in another. A missing inter-warehouse transfer is the classic cause. Check the transfer movements and in-transit quantities before adjusting either side. ### Will an adjustment fix the general ledger as well? **Answer:** It posts through the inventory integration and affects the inventory control and adjustment accounts according to your GL integration setup. Always reconcile the inventory sub-ledger to the control account after material corrections, and involve finance for large values. ## Search terms SYSPRO negative stock, SYSPRO negative inventory, SYSPRO quantity on hand negative, SYSPRO InvWarehouse, SYSPRO inventory adjustment, SYSPRO stock take, SYSPRO InvMovements, SYSPRO allow negative stock --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json