Problem with Moving Average Price

[Former Member]

Hi,

We have this problem that when we post material documents as shown

MvT Movement Type Text Item Postg Date Quantity in UnE EUn

161 GR returns 1 18.02.2009 -0.667 PAC

952 Stock write on 1 18.02.2009 4 EA

671 TR to stck in trans. 2 16.02.2009 -2.333 PAC

161 GR returns 1 14.01.2009 -2.333 PAC

101 GR stock in transit 13 01.12.2008 6 EA

641 TF to stck in trans. 2 24.11.2008 1 PAC

251 GI for sales 182 13.11.2008 -1 EA

251 GI for sales 10 13.11.2008 -1 EA

251 GI for sales 25 06.11.2008 -1 EA

101 GR stock in transit 41 29.10.2008 6 EA

641 TF to stck in trans. 2 23.10.2008 1 PAC

251 GI for sales 20 14.10.2008 -1 EA

101 GR stock in transit 35 15.09.2008 6 EA

641 TF to stck in trans. 4 08.09.2008 1 PAC

Aftter posting the movement type 952, which is a stock write on.. the moving average price shoots upto a very high junk value. I am not able to understand the reason for this.

We then manually chage it using MR21. The problem is that we have to keep a track that this does not happen as it leaded to very high inventory value and figures become mind bogling at times.

Incase any one of you has faced a problem with moving avg price giving absurd values plz let me knw.

thanks

Kanica

[Former Member · Accepted solution]

Hi Kanika Kohli,

I agree with Mr.Selva. Kindly find more information on this,

i. For standard movement types, this means that the given process is not supported using the 951 or 952 combination.

ii. For customer-defined movement types (beginning with 9, X, Y, or Z), this may mean that they have not been fully defined. Delete the movement type and re-create it by copying a standard movement type.

and try to posting with any other movement type which will increase or decrease the value of the goods. In my client, they defined 952 movement as RE for POS sales.

I hope this helps.

Thanks & Regards

Navahsek

[Former Member · Accepted solution]

Hi,

The analysis of Accounting documents created got me to the source of the problem. Thanks for the help.

I would like to know if there is any transaction/report that i can use to display the changes to Sales Price / Purchase price per article for a Organisation level.

Thanks

Kanica

[Former Member · Accepted solution]

Hi Kanica,

You can Run the following Program in SE38 "RV16ACHD" to find the List of Changes for a Period Range.

You can also search in Tcode CKMPCSEARCH for Price Change Documents.

Regards,

Selvakumar. M

[Former Member · Accepted solution]

Hi Selva,

Thanks a lot for sharing the info.

Now i have found a solution to my prob and wouls like to share as it may be quite generic.

What happened was that we were purchasing in Unit "EA" and doing returns in unit "PAC" with 1 PAC = 6 EA. Now as it was decimal rounding taking place, there was a point where the stock was 0.002 rather being 0. Now when the stock value was divided by 0.002 a very large value was maintained for MAP.

SAP handeles -ve and Zero stock for MAP, but not if stock is between 0 and 1.

Cheers

Kanica

[Former Member]

Hi Kanica,

Movement Type 952 is not a SAP Standard Movement Type and hence we cannot comment on it.

Try to Understand the Process by looking at the accounting Documents Generated for transaction and act accordingly.

Regards,

Selvakumar. M