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

Moving average price and returns to vendor

Hello gurus,

I’ve got a question concerning material valuation and returns to vendor.

E.g. we have got 200 pieces of a material with a moving average price of 2 $ each.

Now, what happens if I return 100 of those to my vendor who pays 2.10$ each for them?

In my view, there are several possibilities:

- Nothing happens, the moving average price is not changed at all, value of the goods is 200$ afterwards.

- New value of the goods is 400$ - (100 * 2.10$) = 190 $. This would mean that the moving average price is 1.90 $.

- Last delivered price was e.g. 2.20$, more than 100 pieces were delivered, so the new value of the goods is 400$ - (100 * 2.20$) = 180$, new moving average price is 1.80$.

- …

So my question is: What is standard in SAP?

Thanks

Jens

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 08:56 PM

    This is what my thought is

    When you return the material to vendor then system take the same valuation as your MAP

    and when you buy new goods then it will count based on the

    e.g. existing stock is 100 and value is 1000 means valuation is 10 a peice

    in you but another 100 at 1200 then valuation is 2200/200 = 11

    When a material is subject to moving average price control, the system calculates values for goods movements in the following way:

    check this link

    http://help.sap.com/erp2005_ehp_02/helpdata/en/8f/d1de34e4cb2300e10000009b38f83b/frameset.htm

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 07:33 PM

    Hello Charlie!

    First of all thank you for your reply. Unfortunately your reply did not give an answer to my question.

    I know how MAP works in general. My question was what happens if I return goods to my vendor.

    The document you mentioned contains some information on Goods Receipt Reversal. But I cannot use Goods Receipt Reversal when the delivery has been made e.g. half a year ago way after the Goods Receipt has been posted and the bill paid, can I?

    Thanks again

    Jens

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      You can create a return PO in ME21N. You just need to check the "Returns item" checkbox.

      Enter the price you want (for example your MAP).

      Try this and let me know if works.

      Regards.

      Carlos Durazo

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 10:41 PM

    Please check your flow at each level.Standard SAP will deduct from MAP only.

    Did you make GI ?. There are so many reason behind it .

    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.