Difference between MBEW and MARD stock
I have an issue with quantity difference between Material master accounting view total stock and MMBE/ MB52 stock for a some materials.
Have you ever experienced this problem ?
Please advise what could be the root cause for the same ?
Shailesh Meshram replied
what must have in the begining that ur GR must have been done with the non valuated stock
Check in the table MARDH and MBEWH to find the period where it started to become different.
MARDH has all stock, MBEWH has only valuated stock.
It all happened in the begining when the stk is uploaded with zero price and when the first GRN happens then the price of that material gets updated in the material master,
the stk must have been uploaded twice due to that reason some stk are valuated and some stk are non valuated ,that u can see in MB5B T-code ,for valuated stk the table is MMBE and the valuated + Non valuated stk gets updated in MARD so by the difference of stk in MARD and MBEW u will get the Non valuated stk.
How ever in MM03 -> Accounting View -> Total Stock is the Total Valuated Stock.
In MMBE, Total Stock comprises of Valuated and Non Valuated Stock.
Also, if there are Sales Order Stock with Individual Valuation, these Stocks will not be shown in Accounting View -> Total Valuated Stock, however this will be in MMBE.
Please refer the threads posted by me
1)How to Convert Non Valuated stk into Valuated
2) inventory difference problem in MM03 and MMBE
3) Qty Differene problem in MMBE & MM03
where as to solve your problem is to only make a program in which it will update the MARDH stock and MBEWH stock so that in future the problem does not arise.
Coz our sales person was finding the stock in MMBE but he was not able to do the delivery.
Coz there were no valuated stock.
To solve this I have made a program in which both the stocks will remain the same.I didnt got any solution thats the reason we have to take thsi step
Hope this finds useful .If it does I will expect the Points from you