on 08-05-2011 4:28 AM
hi,
we need to move stock out temporily from system so that we can update the split valuation (i.e. category and type) for a particular material in concern.
The funny thing is this material when view in MMBE, it is zero stock quantity, however, when view in plant stock view in material master, or MB5L, or table MBEWH, there shown 1 stock quantity on previous period (i.e. 07, 2011).
Thus, I went to perform MIGO of movement 551, R/3 complains "Deficit of SL Unrestricted-use 1 PC : 401990 1100 8000", even when I enter the posting date / document date value as 07.31.2011
I am totally stuck here because how to move this 1pc out from previous period from the system?
any advise coz we need to update the split valuation for this material master.
Thanks.
tuff
Thus, I went to perform MIGO of movement 551, R/3 complains "Deficit of SL Unrestricted-use 1 PC : 401990 1100 8000", even when I enter the posting date / document date value as 07.31.2011
this error message does not talk about previous period!
to issue stock in previous period you have to have enough stock in the current period.
if the stock in current period is higher than previous period, then you issue first previous period stock followed by issuing the remaining stock in the current period.
if you have less stock in current period than in previous period, then you have to ADD stock in current period and subsequently issue the previous period stock.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jürgen L.
Thanks on your reply but I think you have not read my second forum comment which explain my situation. Let me repeat here.
Currently in MMBE, this material so Zero quantity, however, there is one 1pcs appear in previous period. This 1 pc appear in MBEWH. When I go to MM03 in plant stock view, the upper section (i.e. current period) indicates Zero quantity, however, the lower section (i.e. previous period) indicates 1 pcs in UU stock type.
Furthermore, if going to MB51 and type in this material under the plant, the next thing come out with list of material document posting and the final stock balance quantity is Zero.
Therefore,...Your previous statement:
if you have less stock in current period than in previous period, then you have to ADD stock in current period and subsequently issue the previous period stock.
Quetion:1 - Does it mean, I have to perform a 561 posting of 1 pc into current period, and later perform a 551 of 1pc from previous period?
2 - Will this be a problem on the stock value?
3 - if no. 1 is yes, should I use 552 to add in the 1 pc to current period instead of using 561 because I have to maintain the split valution into this material?
Thanks. ..Tuff
Hi Jurgen,
it works. Thanks.
Hope you don't mind if you enquire two more questions below:
1) But my I know what is the reason that can cause this kind of thing to happen at the first place (i.e. current period does not show stock quantity, but previous period showing 1pc in plant stock view in MM03)?
2) Further, final question, i have successfuly extend my split valuation type and category.
How do I make the stock situation to become its origin condition (i.e. current period does not show stock quantity, but previous period showing 1pc in plant stock view in MM03)? because after follow your step, there is now NO stock quantity in both current and previous period (which allow me to maintain the split valuation), and now I want to change it back to the original situation, possible?
The following is what I did to try to change to original situation, but it seems cannot fall back to original stock situation
4900653061 - 552 (post for current period)
4900653062 - 551 (post for previous period)
no stock in both period, and I extend split valuation in material master
- I performed a reversal of 4900653062 of previous period. By doing this step, the current period and previous period in plant stock view in MM03 has 1 pcs each (this is not what i want)..
Please help if possible.
Thanks
Tuff
1st remark:
reversal of material documents does not make much sense as the old material document has a different information than you need. e.g. the old material document was with the valuation type, the movement that you want create needs a valuation type.
2.remark.
if you have to cancel movements, then always in reverse order to its creation sequence.
(example: material document created in sequence 1 - 2 - 3, cancel in sequence 3 - 2 - 1 )
looks like you only missed the 552 movement in current period to make the stock 0 again.
to Q1:
Assume you have received stock in May.
when May is your current period, then you have stock in current period and no stock in previous period (which is April)
assume you have not issued this stock entirely, and you have rolled the period to June.
when June is your current period, then you have stock in current period (June) and stock in previous period (May´) because it was not zero when the period was rolled.
Assume you had no movement in June and rolled the period to July
when July is your current period, then you have stock in current period (July) and stock in previous period (June)
if you issue your stock completly in July, then your current period (still July) becomes zero, but the previous period still shows stock.
Hi Jurgen,
about your statement:
if you have to cancel movements, then always in reverse order to its creation sequence.
(example: material document created in sequence 1 - 2 - 3, cancel in sequence 3 - 2 - 1 )
Your are right that I missed the 552 movement in current period to make the stock 0 again.
However, there is a problem, when I try to reverse this 552 document (i.e. which is current period), i am facing the following error message "Enter a valuation type in field 'Batch', Message no. M7086" in both MBST and MIGO. In MBST I cannot find a field of valuation type for me to put in the value, an din MIGO the valuation type field is grey out.
Do you know how to resolve this?
Appreciate.
Tuff
Hi Jurgen,
I am a bit loss now, the following are my current stage.
1) 4900653061 - 552 (post for current period)
2) 4900653062 - 551 (post for previous period)
3) No stock in both period, and I have successfully extended split valuation in material master for this material.
What is my next step...? Can you guy me step by step?
because I am loss on your statement:
ou have to create new material documents, just with the reversal movement type.
do not use MBST, just do MIGO>Goods issue> others and enter the movement type you need.
Thanks a million.
Tuff
Hi,
just to give further extra information about this issue.
in the mateirla master for this material, under the accounting view 1, the inventory value is Zero; and in the plant stock view in the material master, the upper section (i.e. current period) indicates Zero quantity, however, the lower section (i.e. previous period) indicates 1 pcs in UU stock type.
Furthermore, if going to MB51 and type in this material under the plant, the next thing come out with list of material document posting and the final stock balance quantity is Zero.
Please help.
Thanks.
tuff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tuffy,
You have a look into MB51 & MB5Baginst the material movement and find the exact date that has kept the stock 1 quantity...
for ex., in previous posting period, the stock quantity 1 is on 15th July '11. then you must do the initial the stock entry with that date, and then you have to do the posting 551 with the respective posting date.
please note that we can't change document date in system... We can change only posting date...
regards,
sathes
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.