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

moving average price

Hello Gurus,

Can any one let me know how system calculates moving average price? is there any situation where system calcultes moving avg price though the standard price is enabled? I will be very happy if any one provides me mathematical formula for calculating moving avg price.

thank you

Srinivas

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2009 at 06:07 AM

    Hi Srinivas,

    Moving Average Price (MAP) is not calculated through Standard price; in material master we can maintain price control as standard price (S) or moving average price (V).

    MAP is calculated as shown below;

    Material purchased on 01jan09 - Rs. 100 @ 50 pic

    In material master it updates as 100 in MPV, 50 in total stock and 5000 in total value.

    When same material is purchased on 10Jan09 u2013 Rs. 80 @ 50 pic, now system updates as follows.

    100*50 = 5000

    80*50 = 4000

    Total value = 9000

    Total quantity = 100

    MAP = Total Value / Total quantity

    MAP updated in material master is 90

    Regards,

    Giridhar

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Giridhar,

      Thank you very much for your answer. my doubt is, will system consider moving average price in any situation or condition though the standard price control 'S' is enabled in material master.

      and another doubt when there is second lot of material with lower price, system will recalculate moving average price (i.e 90), will this have any impact on anything like inventory revaluation? are there any movement types which are linked with this? please let me know..

      Thank you,

      Srinivas

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.