on 01-19-2014 9:10 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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
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
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
User | Count |
---|---|
98 | |
12 | |
10 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.