Skip to Content
author's profile photo Former Member
Former Member

Inventory falls in Negative

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Sep 05, 2013 at 01:59 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2013 at 03:03 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 06, 2013 at 05:59 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 05:19 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.