Moving average price and returns to vendor

[Former Member]

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

[former_member575786]

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 .

[Former Member]

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

[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

[Former Member]

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