Stock on MB5B

[Former Member]

Hi,

I´m having a problem with material stock. I get two different values on MB5B and MBEWH table for the same material, plant and date.

Material: TP05891070

Company code: 531

Plant: 7101

Selection Date: 01.01.2008 to 31.01.2008

On MB5B, I get:

Stock/Value on 01.01.2008 14,203.100KG 374,010.90 PEN

Total/Val. of Receipts 5,541.900KG 94,518.53 PEN

Total/Value of Issues 19,745.000KG 468,549.25 PEN

Stock/Value on 31.01.2008 0.000KG 19.82- PEN

On MBEWH table, I get:

TP05891070 2007 12 14,203.100 KG 374,010.90PEN

TP05891070 2008 01 0.000KG 0.00PEN

Why is there a difference on Final Stock for 01.2008?

From which table or report does MB5B get -19.82?

I was looking all tables MB5B use, but I haven´t found that value.

I hope u can help me. Thanks!

Jocelyne

Edited by: Jocelyne Garibaldi on Sep 18, 2008 11:01 PM

[Former Member · Accepted solution]

MB5B calculates backwards from today all the material documents and arrives at the stock quantities. The stock values are the values associated with each material document, either debit or credit. Apart from the material documents the price change documents (which get generated when MR21 is done) also will be taken into account for arriving at stock value.

I think probably price change (MR21) might have been done on back date after 31.01.08.

Regards,

GSL.