Re: [sap-log-mm] Accounting differs - no other transaction took place

Posted by Sap Land Tuesday, 21 June 2011 02:54

Posted by USER_2152776
on Jun 21 at 5:55 AM

Following is MB5B output:

Material 067001424040N

Stock on 01.01.0000 0 EA
Total Receipts 30 EA
Total Issues 3- EA
Stock on 31.12.9999 27 EA

SLoc MvT S Mat. Doc. Item Pstng Date Quantity BUn

HARD 105 5800011675 1 25.05.2011 30 EA
HARD 351 6800322295 1 02.06.2011 1- EA
HARD 351 6800333734 1 07.06.2011 2- EA

*Following is MB51 output*

Material Material Description Plnt Name 1
SLoc MvT S Mat. Doc. Item Pstng Date Quantity in UnE EUn Amount in LC

067001424040N FLP COMP.FLOU.LAMP-TWIN,40W,4 FT,230V
HARD 351 6800333734 1 07.06.2011 2- EA 304,091.24-
HARD 351 6800322295 1 02.06.2011 1- EA 152,045.62-
HARD 105 5800011675 1 25.05.2011 30 EA 4,561,368.64
103 5800009397 1 28.04.2011 30 EA
0.00

*but when I see the material in mm03
*

Valuation Class 4350
VC: Sales order stk Proj. stk val. class
Price Control V Price Unit 1
Moving price 157,656.97 Standard price 0.00
Total Stock 27 Total Value 4,256,738.23

Future price 0.00 Valid from
Previous price 0.00 Last price change

*In Previous period/year* *in mm03*

Previous period 05 2011
Valuation class 4350
Price control V
Price unit PP 1
MovAvgPrice PP 152,045.62
Standard price 0.00
Total stock PP 30
Total value PP 4,561,368.64

Previous year 12 2010
Valuation class 4350
Price control V
Price unit PY 1
MovAvgPrice PY 0.00
Standard price 0.00
Total stock PY 0
Total value PY 0.00

The Mov. Avg. Price showing in mm03 (now) seems to be incorrect. Isn't it?
T calculated the moving average as follows
The initial price is 4,561,368.64 & therefor the average is 4,561,368.64/30
= 152,045.62
After issuing 3 items the total is 4105231.78 and the average is
4105231.78/27 =152,045.62

But the value showing in mm03 is differ.

---------------Original Message---------------
From: shiva1985paapu
Sent: Sunday, June 19, 2011 11:43 PM
Subject: Accounting differs - no other transaction took place

What is your MAV and Purchasing Price of the material?

__.____._