Incorrect Opening stock

[Former Member]

Hi friends,

I have a material which shows opening stock when I look at MB5B for a date in the past.

I have looked at the same material in table MBEWH, and saw that the first period with a value is (in our company) period 12 2005, but in MB5B I can run this material for any date in the past, I've tried dates like 01.01.0010 and then I still get an opening and closing stock/value, which is the same amount for any date in the past, before the first actual posting.

Looking at MB51 I saw that the first actually material document for this material was posted in period 05 2007.

Any advice would be greatly appreciate in resolving this matter.

Regards

Christo Vermeulen

[JL23]

can you give more facts?

what do you enter in MB5B selection screen (all fields)

What date is shown for your opening stock?

[Former Member]

Here are the selections that I make in MB5B:

Database Selections

Material Number - 310284

Company Code -

Plant - MW08

Storage Location -

Batch -

Valuation Type -

Movement Type -

Special Stock Indicator -

Selection Date - 01.01.2000 (but any date before 01.02.2007) gives the same result once executed

Stock Type

Storage Loc./Batch Stock -

Valuated Stock - selected

Special Stock -

List Scope

Everything is ticked on

EXECUTE REPORT

Valuation Area MW08

Material 310284

Description Barley:Raw Bulk

Stock/Value on 01.01.2000 212,315 KG

Total/Val. Of Receipts 0 KG

Total/Value of Issues 0 KG

Stock/Value on 01.01.2000 212,315 KG

[JL23]

put the cursor on the line "Stock/Value on 01.01.2000 212,315 KG"

then click the detail button, SAP shall bring up the movement that corresponds to the quantity shown

in case you are working with active ingredient material you may want to check

Note 1265674 - MB5B Opening stock qty incorr.for active ingredient material

[Former Member]

Hi Jurgen,

Thanx for replying so fast.

There is no detail button. After I've executed there is opening and closing stock but at the bottom of the report it says "List contains no data"

I've had a look at note 1265674 but it is not relevant for my situation. For one thing I've checked MB51for movements 141 & 142 as the note suggested, but found nothing.

Regards

Christo Vermeulen

[JL23]

what SAP release do you run?

In ECC6 is certainly a button for the document item, it looks like a puzzle piece and is located between the sorting buttons and the blue info button.

[Former Member]

I am on ECC6 and found the button, but there are not items. I've placed the cursor on just about everything now while trying to click the details (document item) button, but nothing.

[JL23]

then I recommend to open an incident at SAP.