Skip to Content

Huge Increase in Moving Price

Hi All,

I apologise for this question, I have searched and found a lot of information but I am struggling to understand/apply it to my scenario and come up with an explanation.

Below is a copy of MB51 results for material.

The moving price has exploded since moving stock from consignment at a lower price. I don't understand why moving the stock out of consignment at this price has caused the moving price to increase by almost 4 times when the variance of the 2 prices was far less.

Can anyone explain what has happened here please?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

  • Hi Ben,
    Thank you for visiting SAP Community to get answers to your questions and please don't apologise for asking a question here. I am here to help you to get the most out of it.

    First of all, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't done so already), as it provides tips for preparing questions that draw responses from our members.
    For example you:
    - can outline what steps you took to find answers (and why they weren't helpful)
    - can share screenshots of what you've seen/done (I think you forgot to attach the copy that you mentioned)
    - can use a descriptive subject line

    Please also make sure you're using all appropriate tags, so the right experts can find your question. Overall, the more details you provide, the more likely it is that members will be able to assist you. Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question - but if that happens, you can leave more details in a comment).

    Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

    Best,
    Lena (SAP Community Moderator)

Related questions

5 Answers

  • Posted on Aug 21 at 03:09 PM

    I am not seeing any screen shot of the moving average price neither the related document from where you saw the huge difference. When you say consignment - is it vendor consignment or customer consignment ? Please provide as much information as possible for better clarity. Also, did you check the change log for that material master which will show if at all someone changed manually ?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 21 at 03:58 PM

    Hello,

    Reason behind change the moving average

    1) Need to check purchase order rate

    2) Need to check MIRO accounting effects specially GRIR account because at the time of booking MIRO may be user entered amount and this amount goes in to material cost.

    3) It is typo mistake happened some time like you have to enter rate per TON but by mistake entering rate per KGS - It is typo mistake but gives you a huge change.

    After checking above all steps if you not seen any solutions then please first share required screenshots with detail information.

    - Rajkumar Mane

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 25 at 09:43 AM

    Hi All,

    Apologies my screenshot didn't seem to upload properly.

    Please see below MB51 results for the material.

    Thanks,

    Ben


    mb51.jpg (91.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 25 at 10:54 AM

    Do you have access to report of note 2198317 - Analysis report for moving average price changes: MBMAPCHANGES, else did you consider transaction MR51 and/or KBA 1506200 - Determine how Moving Average Price changed.

    (Code 411 is Transfer of special stock to own stock, 412 should be a reversal movement, also there are many physical inventory movements on this material?)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 25 at 11:55 AM

    I unfortunately don't have access to the above report.

    We ended up with -63 in consignment stock. It looks like the 412 movement was completed to 0 the consignment stock.

    The above results of MB51 is the entire history of this material.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.