Valuated stock becomes negative

[Former Member]

Hi All,

We have below issue for the physical Inventory document post.

While posting physical Inventory document using transaction code MI10 (Post document, count and difference) for the material: 16673 in plant 3841, getting an error message as u201CValuated stock becomes negativeu201D.

As per our analysis in material master an accounting view the stock of the quantity is 7 EA and in MMBE (Material stock overview) itu2019s showing as 37 quantities in unrestricted stock, while removing stock 30 quantity from unrestricted stock system through an error message as u201CValuated stock becomes negativeu201D.

Please advise how to remove the extra stock 30 quantities from the Inventory its causing inconsistency problem for the 30 quantity in inventory.

Regards

Dilipkumar

[kailas_ugale]

Hi,

check following points

1) check your material quantity and value for particulate period in MB5B

2) Check your material document posting date of material in MB51

3) check posting date of you physical inventory document and material GRN or If you quality management then 321 document posting date for your material

4) If your are doing physical inventory in previous period not in current period ,then check stock in both period

Regards

Kailas ugale

[ajitkumar]

do you also procure the same material against account assignment? if so please check whether there were instances when a quantity update has happened ( which shouldn't when account assignment ) in storage location without value update.

[murugan_mgl]

What is current stock & previous stock,Check in MM03

[Former Member]

Hi,

There is no previous stock exist for this material.

Regards

dilipkumar

[murugan_mgl]

Can u check the stock in MM03 by selecting storage location stock & in MB5B by selecting special stcok indicator

[JL23]

you have a inconsistency between total stock and valuated stock.

So you cannot just proceed without analyzing why you have this inconsistency.

I know one reason how it can happen:

when you create a new plant, then it is often forgotten to define value update per material type.

if you activate this after you had posted inventory, then SAP does not automatically valuate the existing inventory, it just starts to post value for any new movement after this change. your initial inventory just stays inconsistent non-valuated in the tables.

If that was the root cause for your case as well, then reply and we will see if can find a solution.

[Former Member]

Hi,

This is not a new plant and new material since they are using this material and plant from 2006.

Regards

Dilipkumar

[JL23]

you have to find the reason for the unvaluated stock portion. maybe by analyzing the movements.

Maybe you were never below a stock level of 30, and did not face this problem even it was caused by the problem I described earlier, but originated already in 2006.

Otherwise you need to see if there is just one movement with 30 quantity, which is just unique and maybe not well known by you.

Use MB51 to find such movements.

you may even need to use SE16 at table MSEG, as MSEG stores information about "Total valuated stock before the posting"

so it should be relativly easy to find the document causing this.

[Former Member]

Hi

I checked material movement in MB51 transaction and compared table in table MSEG,both entry are matching and I did not find any such 30 quantity incocnsistency updated in table level.

Do we have any option to upadte table entry to make correct stock,any way we need to cosnume that stock.

Regards

dilipkumar

[Former Member]

Hi Dilip,

if you want to remove some quantity using physical Inventory posting on the past date (backdate), you can't refer to MMBE, because MMBE shows the current stock that may not yet exist in the past, or already gone from future consumption

try check closing inventory using MB5B, entry "selection date" to check closing stock (it'll show opening stock also) on that period. check which date or month/week (interval) that make difference for 30 qty

Regards

[Former Member]

Dear Mr. Dilip,

You can check there is any reservation pending due to this error showing . May be....

Regards,

Anil Kumar

[Former Member]

Hi,

First check in your material master, maybe the tick for negative stock is ticked or are you guys intergrating with warehouse Management because if that is the case interim storage type contains negative stock.

Maybe you will have to untick negative stock in your material master.

Thanks

Silas

[Former Member]

Hi Anil,

I checked There is no such Reservation exist for this material, even MMBE stock not showing any stock against reservation for the same material.

Please let me know if you have any other solution for the same.

Regards

[Former Member]

Hi,

Can you confirm in material master for which view the negative stock check box activated.

Regards

dilipkumar

[Former Member]

Hi,

Check in plant data/ Storage tab 2 in your material master see if this box has a tick.

Thanks

Silas