Skip to Content
0
Former Member
Mar 06, 2009 at 01:18 AM

Problem with Moving Average Price

123 Views

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