Inventory falls in Negative

[Former Member]

Hi all

A client is doing a stock take and gets the error: Quantity falls into negative inventory [Message 131 - 149]

I check the InStock quantity for the items for that warehouse and none are negative.

Under Document Settings the Block Negative Inventory is ticked and its by Comany.

Any other reason that could cause this issue.

The customer is on SAP8.81 PL08

Thank you

Jerusha

[former_member186712 · Accepted solution]

Hi,

They are not know in negative but in 31/8/2013 the next documents will be in negative.

Example.

In 1/9/2003 you made an Invoice with 3 quantities. If you count only 2 in 31/8/2013 this Invoice would be in negative, so B1 doesn't allow you to insert 2. You need 3 quantities in 31/8/2013

Hope it helps,

Augusto

[Former Member]

Hi you all,

we have the same problem like Jerusha and thanks to the queries ... but what have you done with the results? How have you solved the problems? Any booking? which bookings?

Regards

Holger

[Former Member]

Hi Holger.

Before i gave a reply to my customer they had resolved the issue on their side, and not sure what was done.

I did log this issue before and was given a query to find out the items giving the issue

please follow this thread: https://scn.sap.com/thread/1621543

Hope it assists

[Former Member]

Try this thread as well: http://scn.sap.com/thread/1162607

[former_member186712]

Hi Jerusha,

Try this query and change the '01' for your Warehouse code 

select

t0.itemcode, t0.itemname, T2.Counted 'Qtd Counted', SUM(T1.InQty - T1.OutQty) 'Quantities moved after the Stock taking', T2.Counted + SUM(T1.InQty - T1.OutQty) as 'item with problems < 0', T2.WasCounted from OITM t0 left outer join OINM T1 on T1.ItemCode = T0.ItemCode and T1.Warehouse = '01' and T1.DocDate >= '20130901' left outer join OITW t2 on t2.ItemCode = t0.ItemCode and t2.WhsCode = T1.Warehouse

Where T2.WasCounted = 'Y' Group by t0.itemcode, t0.itemname, T2.Counted, T2.WasCounted order by

'item with problems < 0'

Hope it helps

Regards,

Augusto

[Former Member]

Hi Jerusha,

You may try a query:

SELECT ItemCode, SUM(Inqty-OutQty) Changed

FROM OINM

WHERE DocDate > '20130831'

GROUP By ItemCode

Having SUM(Inqty-OutQty) !=0

Then you will find all those negative item qty.

Thanks,

Gordon