Opinion & Commentary

Updated on

The moving average price in SAP MM is very easy to calculate

When I utilised SAP MM to make an order, I had reservations about computing the moving average price. Most of the time, we are unaware of the prior PO price and quantity, or the price computation went incorrect, and therefore we are unable to obtain the accurate MAP for any commodity.
Lokeish Umak
Lokeish Umak

I had doubts about calculating the moving average price in SAP MM whenever I used it to create an order. Most of the time, we are not aware of the previous PO price and quantity, or the calculation of the price went wrong, and hence we fail to get the exact result of MAP for any material. It is very simple and can be calculated in just a minute. It is a simple formula. We just have to keep in mind the price and the quantity of the previous and current PO. That's all. Here we go.

Moving average price SAP MM

Moving average price SAP MM
The moving average price in SAP MM is easy to calculate | Image credit to SAP blogs

The moving average price itself says the price variation after every purchase order is placed. The price of the order can be taken from three different sources. The first one is from the Purchase info record, the second, the vendor price, and the third, the outline agreement. This is also called the source of supply, as we can get to know who can supply the materials.

How do I figure out the price as a purchase officer? You can take an example with the previous PO and the current PO. When I created the first order for the particular vendor, at that time, the price was considered $10 and the order was placed for qty 20, hence the total = 200.

The moving average price for my upcoming order would therefore be

Previous Price + Total GR Price (current)/Previous qty + Total GR Qty (current)

Eg: previous price ($10) current price ($11) and previous & current qty (20) and the current total GR price ($220) It comes to around $10.47

If you have any other thoughts or procedures better than this, please mention them in the comments. I will add to this article as well.

MORE MUST-READ STORIES

Lokeish Umak

Lokeish Umak

Lokeish Umak writes about his favorite topics, such as essay, poems, health, fitness, nutrition, etc. He also invites guests on his podcast show, "Chronicle Conversations."
View all posts by Lokeish Umak

Featured Writers

Culture & Entertainment

Stories that Stir Souls: Illuminating the Path of Storytelling’s Influence

Storytelling: timeless art connecting people through narratives. From prehistoric times to modern tech, it educates, preserves culture, and inspires a better future. Crucial in bridging divides, it reminds us of our shared humanity.
Avatar photo
Yashasvy Singh
Storytelling: timeless art connecting people through narratives. From prehistoric times to modern tech, it educates, preserves culture, and inspires a better future. Crucial in bridging divides, it reminds us of our shared humanity.
Opinion & Commentary

How I Lost and Found My Voice

"Initially, I changed my Malawian accent to fit in. But I learned my voice mattered, and my roots made me unique. Through struggles, I found my true self by embracing my Malawian identity. My journey is chronicled in my books, 'What Kind of Girl?' and 'Some Kind of Girl.'"
caroline Kautsire
Caroline Kautsire
how i lost and found my voice
Opinion & Commentary

Nurturing Values In Children Through Storytelling

How storytelling shapes young minds, instilling empathy and resilience. Explore the power of narratives in nurturing values in children.
Devanshi Joshi
Devanshi Joshi
Culture & Entertainment

From Poetic Pause to Professional Power: The Journey of Emotional Resilience

Moving With Meaning offers guidance in emotional resilience, from introspective reflection to assertive leadership. Through coaching and the 3C Approach, we empower professionals to navigate challenges with grace and determination. Whether early, mid, or late career, we support you in finding purpose and direction in every step of your journey.
author, life coach, and the driving force behind Moving With Meaning LLC
Krystal Clark
Moving With Meaning offers guidance in emotional resilience, from introspective reflection to assertive leadership. Through coaching and the 3C Approach, we empower professionals to navigate challenges with grace and determination. Whether early, mid, or late career, we support you in finding purpose and direction in every step of your journey.

Read more

Culture & Entertainment, Environment & Sustainability, Lifestyle & Personal Development, Opinion & Commentary

The Unsung Heroes: The Role of Volunteers in Modern Society

More in Interviews

The author Gabor Holch: Worldwide business leaders who try to comprehend China’s unavoidable impact on their livelihoods often ignore the most important voices: those of expatriate managers with years of experience in the country. Based on interviews with China-based corporate executives over five years, Dragon Suit brings to life the country’s swarming cities, recent economic tsunami, unstoppable middle class.

Finding a catchy book title is a headache, says Gabor Holch

Interview with Gabor Holch, author of "Dragon Suit": Explores expat executives' journey in China's business world, revealing both success and failure stories, reflecting on China's economic evolution and global impact.
first aid kit is an essential part when you choose bike / MTB for riding.

Stefan Eberharter: I always bring my first aid kit with me

Meet Stefan Eberharter, a MTB pro rider who got an excellent skills and training of downhill and other important bike riding skills that will ...
Do you love riding a motorcycle? If so, this article is for you, and if you are a Harley Devidson fan, you must read this interview with Maldita before purchasing one or if you already own one.

Maldita: “I try to travel and discover different cultures”

Do you love riding a motorcycle? If so, this article is for you, and if you are a Harley Davidson fan, you must read this interview with Maldita before purchasing one or if you already own one.

Leave a Comment