Quantity falls below minimum quantity

[Former Member]

Hi All

A client is doing stock take, and when posting the stock he gets an error : quanity falls below minimum quantity message 131-14.

as he is posting a few hundred items, how can we check which items are giving that error.

thank you

[Former Member]

This looks like it solved it. Thanks

[Former Member]

Hi,

I have used this query to solve the mystery:

SELECT T1.WhsName, T0.ItemCode, sum(T0.InQty - T0.OutQty) as 'On Hand Changed'

FROM DBO.OINM T0

INNER JOIN DBO.OWHS T1 ON T0.Warehouse = T1.WhsCode

WHERE T0.DocDate >= '[%0\]' and T1.WhsName like '[%1\]%' and T0.ItemCode like '[%2\]%'

GROUP BY T1.WhsName, T0.ItemCode Having sum(T0.InQty - T0.OutQty) != 0

Thanks,

Gordon