Moving average price issue

[Former Member]

Hi All,

When I creating a Return STO for Qty 25 Each , The Condition type (P101-Val.Price Supply.Pln) is picking up the correct MAP value which is 2.43 SGD/ EA. So the total condition value is 60.75 SGD, But subsequently when i creating a Delivery order and doing good issue with Movement type 671 + the field Amount in LC value is 8,498.25 SGD. When i check the PO History amount in LC is 8498.25 SGD becoz of which the system posted wrong value to AUM -ve stk & MAP rounding difference account.

My question is how come this Amount is LC value is so High.

Appreciate your quick response..

Point's will be rewarded.

Regards

saurabh

[eduardo_hinojosa · Accepted solution]

Hi,

Check the values with tcode MB51 for this article and plant (POS). You must find the error, surely an good movement with an strange value.

Regards

Eduardo

[Former Member · Accepted solution]

Hi Dear,

Thanks for your quick response ..

I've checked the stock on posting date via Tcode: MB5B and found out that the opening stock qty on 26.09.2010 was 125 EA value is 303.75 SGD (So MAP Value= 2.43 SGD) in the store and on the same day user have issued some stock via Movement type 671 '- ve' qty 25 EA to DC for which the valuation is same 303.75 SGD (MAP VALUE 12.15). So the closing balance of 100 EA is showing Zero value now in store. see the example below:

Ref.Doc.No TotalStock Total Val. MvAvgPrice ValA Entry Date Quantityissued Amount

4900065685 150 364.5 2.43 307 03.09.2010 -25 -60.75

4900111841 125 303.75 2.43 307 26.09.2010 -25 -303.75

4900156957 100 0 0 307 11.10.2010 -25 0

4900156958 75 0 0 307 11.10.2010 -25 0

4900207942 50 0 0 307 24.10.2010 -50 0

Same 25 EA recieved in DC With movement type 671 '+ve' : See the example below.

Ref.Doc.No TotalStock Total Val. MvAvgPrice ValA Entry Date Quantityreceived Amount 4900111841 3 1,019.79 339.93 62 26.09.2010 25 8498.25 4900112024 28 9,518.04 339.93 62 26.09.2010 14 4,759.02

Please help to investigate the issue.

Thanks & Regards

Saurabh dubey

Edited by: saurabhdubey1181 on Dec 24, 2010 9:59 AM

[eduardo_hinojosa · Accepted solution]

Hi

In my opinion you have the problem in doc 4900111841 ¿why do you have this strange value? ¿What kind of mov is it?

Regards

Eduardo