Quantity falls in negative inventory + Which Item

[former_member650363]

Hello All,

We are using DTW to upload our physical stocks, and when I try to do Stock Posting, the following error message appears: Quantity falls into negative inventory.  [Message 131-149].

How can we track which Item is causing this error? Do we have any shortcut to find out or we have to track issue and receipt of each item an find out.

Thanks,

Vineela.

[former_member186095 · Accepted solution]

Hi,

you can use query to check possible the cause of the issue.

JimM

[former_member650363 · Accepted solution]

Hi,

Can you please post the query. Right now I am using the following query to get the issues and receipts:

SELECT  T0.[ItemCode], SUM(T0.[InQty]) AS RECEIPT, SUM(T0.[OutQty]) AS ISSUE, MAX(T0.WAREHOUSE) AS WAREHOUSE FROM OINM T0 WHERE T0.[DocDate] >= [%0] AND  T0.[DocDate] <= [%1] AND  T0.[Warehouse] = [%2]

GROUP BY T0.ITEMCODE

Thanks,

Vineela.

[former_member650363 · Accepted solution]

Hi,

Got the query at http://scn.sap.com/thread/1162607.

Thanks,

Vineela.

[former_member186095]

Hi,

you can try these following solutions :

1st solution

a) Tick the checkbox 'Manage Inventory by Warehouse' in Inventory - Item Master Data - Inventory Data tab.

b) Change the option in Administration - System Initialization -  Document Settings. The 'Block Negative Inventory By' is still ticked but the option is Company instead of Warehouse.

2nd solution

Add account code into negative inventory adjustment field either in item group, item master data --> inventory tab or warehouse. Depends on your set G/L account by value.

Rgds,

[former_member650363]

Hi,

These options will help me post the data, but instead I want to filter those items which are creating an issue. So that the users who posted should give an explanation like how did they issue goods even though there is no physical stock but book stock is available that means  they are doing wrong issue or the physical stock given is wrong.

Hope I am clear.

Thanks,

Vineela.