Skip to Content
author's profile photo Former Member
Former Member

Moving average price can not be updated after goods movement

Hi,

I am trying to configure moving average price for each materials at my system. I tried many many customizing steps to update the materials price after goods movements made.

I don't want to explain all steps that i have made for customizing because i was lost and confused

Please guide me with comprehensible and clear steps from the beginning.

Note: there is an attachment related with creation material. This image will be helpful to understand where am i wrong.

Thanks and best regards.

Untitled.png (51.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2013 at 02:50 PM

    Thanks for replies;

    My test is like this:

    1. create new material with price control V and the price 10 $

    2. take 10 Pieces of this material with 501 movement type (goods receipt)

    3. change the price and new price is 15 $ (MR21)

    4. take 10 Pieces of this material with 501 movement type to the same storage (goods receipt). Now i have 20 pieces of this material

    5. sent 1 Piece with 201 movement type (goods issue)

    6. i want to see average material price should be 12,5 $ but average material price is 15 $ when i looked at MM03

    I think now i explain the issue clearly.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Just cross check following to get clear about concept which cause your concern

      You created new material with price control V and the price 10 $ and receipt 10 Pieces of material with 501 movement type (goods receipt)

      Cross check accounting document with stock of material with material value

      You changed the price of material with new price is 15 $ in t.code:MR21 .

      Just check accounting document for material with t.code: MR51 and find stock of material with material value

      Again you have taken 10 Pieces of material with 501 movement type to the same storage (goods receipt).

      Now Cross check accounting document with stock of material with material value.

      You send one Piece of material with 201 movement type (goods issue) and now Cross check accounting document with stock of material with value where system calculating perfectly with average material price is 15 $ @ t.code:MM03

      NOTE:

      When you change material price in t.code:MR21, the accounting triggers with G/L account of Gain/loss from revaluation (with UMB key) against your Inventory account

      Regards,

      Biju K

  • Posted on Sep 12, 2013 at 01:00 PM

    you should explain what you actually think is wrong.

    you've 7 in stock, and a value of 35, and moving average of 5 and a standard price of 4, so everything looks

    fine.

    what do you want to tell us with the yellow circled future price?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2013 at 01:02 PM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2013 at 01:35 PM

    Hi Kesten!

    There is no need any special customization to update MAP. If you have selected price control V and its value in material master and as long as your procuring for stock material it will update by default in the material master.

    let us know what is your exact requirement.

    Regards,

    Praveen.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2013 at 12:54 PM

    Thanks for your help.

    Issue was resolved.

    The solution is creating an area called "Externally Entered Posting Amount in Local Currency" at migo (501 movement type) screen. By this way i can enter the new total price of the materials to the area. after the movement the average price is recalculated automatically.

    Best regards and thanks again.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2013 at 11:50 AM

    This message was moderated.

    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.