Clear negative stock in storage type 921 and 922

[Former Member]

Hi All,

We have negative stock for some materials n 921 and 922 storage types., We want clear the negative stock.

All TRs related to 921 are deleted and PCN are manually changed to processed status.

No stock available for the material in IM and also no positive stock in WM, so we are not able to reverse the transfer posting material document.

Please guide me on how to clear the negative stock.

Thanks,

Muru

[Former Member]

Hi,

You can perform the physical inventory at WM level and clear the material from 921 and 922 storage types and equalize it with the MM stock. It will create an accounting document i believe.

Thanks

Vineeth

[mihailo_sundic]

That's not true, if he does this the inconsistency will still exist.
It will only create accounting document to nullify the stock in 921/922
but it will also affect IM so you will still have the difference.

As Jurgen said the only way is to create the total system stock balance in WM to match
the physical stock balance in WM and then execute LX23.
This time it will generate accounting document and remove the inconsistency.

E.g. if you have 0 in IM and -20 in WM, you need to post 20 to WM to get to 0 if your
physical stock balance is 0.

You can use LT10 to nullify the negative quant in 921/922 with the newly transferred positive

quant in WM if they are in different storage types after transfer.
When you have the exact WM stock, simply execute LX23 and the IM quantity will be
set the same as WM quantity and you're done.

[MANIS]

Hi,

In this i can see only direct table (LQUA) update or else any proposed solution will create further inconsistency in your warehouse

Wondering how come all the TR got deleted and PCN got updated without having the impact assessment on the entry which are there in 921 & 922. If you can share the real reason for TR deletion and PCN update then it might be we can understand the business process and look for alternative solution

Cheers

Manish

[Former Member]

This transaction has happened in 2010 and 2011, they transfer the stock from wM manged store to non-wm managed store and stock has consumed in non-wm managed store, but in WM level it was not cleared, we have got this request now to clear the stock .

Can I go ahead and do this below.

. 1.bring stock in MM through physical inventory or 501

   2. Strock transfer in wm using LT01/Lt10 movement 999- transfer stock from other storage type to 921

3. Now negtive stock will be nullified and stock remains in MM level

4. Physical inventory in MM level to remove stock which still in MM

Please suggest.

[JL23]

as long your warehouse is assigned to the plant/storage location any movement in MM will automatically create a quant the interim storage bins along with transfer requests or posting change notices.

you point 4 will usually not work, as SAP is rasing an error to tell you that you need to perform a physical inventory in WM

Assuming  it would be possible, then it removes  again the stock your WM.

What you can do is to add so much stock in MM, that you finally have the expected stock level in WM. And after that you do a LX23 to adjust MM to become equal to WM stock level.

These movements will create accounting documents, which will hopefully equalize each other and end in a balance of zero.

[Former Member]

Hi Jurgen,

as u siad physical inventory in to MM thorwing error as WM link exist.

I also tried by taking some stock in to MM and try to clear in WM/MM,but again it is creating inconsistency.

Is there any other way to do instad of deleting at table LQUA.

For future, if i remove the negative stock allowed check to 921/922, what will happen?

Thanks,

Muru

[JL23]

Had you really done what I said? I actually doubt. you had an inconsistency, adding stock in MM will not not make the inconsistency go away, this will be done by LX23 only. LX23 is the transaction designated to clear inconsistencies. It adjusts the MM inventory to equal the WM inventory.

[Former Member]

Hi Jurgen,

Yes i did the following steps,

1. Go to T.code LX23 and enter the plant and slocation

Selected the check boc clear difference , then execute , but did not see anything and i dot the

I got material no : 123

Mm stock ; 0

WM stock; -100

Do i need to bring some stock at MM level?

Steps i followed above is correct or should i do some more steps.

Thanks,

Muru

[JL23]

I said this before you have to add as much MM stock as you need to make WM match with your physical stock.

If you phyiscal stock is zero, then you have to add 100 to get zero in WM.

After this you do LX23 which makes then MM zero too.

[Former Member]

HI Jurgen,,

I have uploaded MM stock in two ways and tested.

1. using 501 ---Created stock in IM and also created TR

2. Using 561 --- Created stock in IM level and no TR created

So i used 561 for testing, then

Now negative stock removed from WM and shows only MM stock in LX23..

then

1. Go to LX23

2. Then enter plant and storage location

selected "Clear difference"

, then execute..

3. Batch Input session created, then batch input session executed..

No all MM stock removed and atumotic document posted.

Is this right method and is there any negative effect..?

Thanks for your support..

Regards,

Muru

[JL23]

The way is right, if your stock situation is correct now, then you already have the evidence that it worked well.