# SyteLine Inventory Adjustment: Insufficient Quantity on Hand > Source: https://netray.co/erp-help/syteline-inventory-adjustment-insufficient-quantity-error > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer SyteLine validates an issue or adjustment against quantity at the exact item, warehouse, location and lot, not the item total. The error usually means stock sits in a different location or lot, a prior transaction is unposted, or the warehouse and location quantities have drifted apart. Check the quantities at each level, fix the real cause, then post the adjustment. ## Kind error ## System syteline ## Erp Infor SyteLine (CloudSuite Industrial) ## Module Inventory / Miscellaneous Issues and Adjustments ## Query SyteLine miscellaneous issue insufficient quantity on hand error ## Alternate Queries - SyteLine inventory adjustment will cause negative quantity - SyteLine quantity on hand does not match location total - SyteLine cannot issue more than on hand at location - SyteLine item warehouse quantity out of sync with item location ## Applies To Infor SyteLine 8.x and CloudSuite Industrial, Inventory module (Miscellaneous Issues, Miscellaneous Receipts, quantity adjustment forms) ## Steps ### How to resolve the quantity error **Items:** - Note the exact item, warehouse, location and lot on the failing transaction. - Open the Item Locations or on-hand inquiry for that item and compare quantity at that location to what you tried to issue. - Check whether the stock is in a different location, a different lot, or in a non-nettable or quarantine location. - Look for unposted or pending inventory transactions for the item, such as unposted job material issues or receipts waiting in a batch. - If the physical stock is really there but the system shows less, correct it with a documented receipt or cycle count adjustment, not by forcing the issue. - If the system shows more than reality, adjust down with a reason code and approval so the cost impact is traceable. - If warehouse total and location totals disagree, run the SQL reconciliation below and involve support before editing data. - Retry the original transaction and confirm the on-hand and the transaction history both reflect it. ## Sections ### Where SyteLine checks quantity **Body:** Inventory in SyteLine is held at several levels: item-warehouse quantity in itemwhse_mst, item-location quantity in itemloc_mst, and lot-location quantity in lot_loc_mst when the item is lot tracked. A transaction posts through all of them and writes a row to matltran_mst. The validation that raises an insufficient quantity message is checking the most specific level your transaction names, so a large item total does not help if the chosen location is empty. That is why the same item can be issued from one location and rejected from another. It is also why users report the message as wrong when the item inquiry shows plenty of stock: the inquiry is summing levels the transaction does not use. ### Typical causes **Body:** The most common cause is wrong location or lot entered on the form, often from a barcode scan that defaulted to the previous record. Second is stock that was received but sits in a receiving or inspection location that is not issuable. Third is a transaction that has not been posted yet, so the quantity has not arrived at the shelf from the system's point of view. Less common but serious is drift between levels, where the warehouse total is not the sum of its locations. It can follow a failed posting, a direct SQL update, or a custom event that wrote to quantity fields. Do not fix it by editing quantities yourself without a backup and a support case, because cost layers and transaction history will stop agreeing. **Code:** -- Find items where warehouse quantity differs from the sum of locations SELECT w.item, w.whse, w.qty_on_hand AS whse_qty, SUM(l.qty_on_hand) AS loc_qty FROM itemwhse_mst w JOIN itemloc_mst l ON l.item = w.item AND l.whse = w.whse AND l.site_ref = w.site_ref GROUP BY w.item, w.whse, w.qty_on_hand HAVING w.qty_on_hand <> SUM(l.qty_on_hand); ### Correct it without breaking cost or audit **Body:** Always adjust through a SyteLine transaction so a matltran_mst row is written with a reason code. A quantity fixed by SQL leaves no trail, and the next cost rollup or physical count will surface a variance nobody can explain. Check the negative inventory setting in Inventory Parameters and any item-level controls for your release. Some sites deliberately allow negative on-hand to keep the floor moving and clean up later. That is a policy choice, and turning it on to silence this error just moves the problem into the count. ## Pitfalls - Forcing an issue by temporarily allowing negative inventory and forgetting to turn it back off. - Adjusting the quantity at the warehouse level while locations still show the old figure. - Ignoring lot or serial assignment on a tracked item; the lot quantity may be zero even when the location has stock. - Editing itemloc_mst or itemwhse_mst directly in SQL, which skips cost layers and transaction history. - Posting a correction without a reason code, so the next audit cannot tell a count error from a theft or scrap event. ## Ai Angle SyteRay can read item, warehouse, location and lot quantities with matltran_mst history and explain in one answer why a given issue was rejected, for example that the stock is in a receiving location or that a posting is pending. It can flag items where warehouse and location totals disagree. Any correcting transaction is proposed for human approval, never posted on its own. ## Faq ### Why does the item show stock but the issue fails? **Answer:** The item inquiry usually shows a total across warehouses and locations. The issue is validated against the specific warehouse, location and lot on the transaction. If that exact combination holds less than you are issuing, the transaction fails even though the item total is large. ### Should I just allow negative inventory? **Answer:** Only if that is a deliberate policy for your site. It hides receiving delays and unposted transactions, and moves the error to cycle counts and cost variances. Fix the cause first, and use negative allowance as a controlled exception rather than a default. ### Can I fix the quantity directly in SQL? **Answer:** Avoid it. SyteLine writes quantity, cost and transaction history together. A direct update changes one without the others, creating discrepancies that appear later in valuation and ledger reports. Use an adjustment or count transaction, and involve Infor support if totals are truly corrupt. ### How do I stop it from recurring? **Answer:** Train scanners and users to confirm location and lot before posting, post receiving and job transactions promptly, and run regular cycle counts. A scheduled reconciliation query for warehouse versus location totals catches drift early, before it blocks a shipment. ## Search terms syteline insufficient quantity on hand, syteline miscellaneous issue error, syteline inventory adjustment, itemloc_mst qty_on_hand, syteline negative inventory, syteline matltran_mst, syteline warehouse location quantity mismatch, cloudsuite industrial inventory error --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json