Skip to Content

MB5B Valuated Stock and Storage Location / Batch Stock

Please explain me why there are difference in the quantity of material valuated and storage location:

I have a HALB Material when I run MB5B on Plant X I get let say 10000 LB qty ( selecting Storage Loc./ Batch Stock )

but when I execute the same but selecting Valuated Stock i get let say 30000 LB qty.

I was thinking its possible if the result is vice versa as it may include stock that is returned or any other reason.

When I run the mmbe of that stock i still see 10000 LB qty that matches to Mb5b ( selection Storage Loc/ Batch Stock)

Please share your views what is the reason for this kind of scenario to occur.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Jul 11, 2016 at 08:53 PM

    Hi Anand,


    The answer is the report MB5B does not consider certain movement type when you run with valuated stock. For example: 311 movement will not be considered when you run this report with valuated stock, but the same will be considered when you run with storage location / batch stock. Simplest way to find the difference looks into the movement types which taken by the report to arrive stock quantity.


    Hope you will get some clarity on this.

    BR, Rosh.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 12, 2016 at 07:01 PM

    Hi,

    MB5B in "valuated stock" option reads data from MBEW table as a base and then reads the corresponding valuated material documents and accounting documents (BSIM table) for the date range. This will consider the movement only if there is an accounting document.

    But if its executed in "Storage Location Stock" option, it considers the stock tables (like MARD) as base data and then reads the corresponding material documents (MSEG) for the date range. It considers all material documents irrespective of whether there is an accounting entry or not.

    Regards,

    AKPT

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2016 at 04:18 AM

    Hi,

    Material valuation depends on your valuation area selection where plant play major role but not the storage location!

    Can cross check which report of MB5B is same as material report with t.codes MB52 and S_P00_07000139.

    Also compare material report with tables

    1. MBEW and MBEWH

    2. MARD and MARDH

    Regards,

    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 12, 2016 at 07:04 PM

    It would be nice if someone can tell me what movement types valuated stock considers and what not..?

    Add a comment
    10|10000 characters needed characters exceeded

    • does this 103 movement answer your initial question?

      It could eventually if the situation where the other way around, if you had less valuated stock.

      but even here it would not explain the difference to the storage location as 103 does not post to a storage location.

      So just collect all movement types that you have in the execution at storage location and compare it with the collection of movement types that you have in the valuated stock execution.

      This gets you closer.

      you can also download it to Excel and directly compare which material documents are not listed at all in one both runs.

  • Posted on Jul 13, 2016 at 01:20 PM

    Thanks for your reply.. there are certain movements that MB5B do not consider when it runs in selection Valuated Stock ( e.g. 103, returns from customer( i guess its 651)) . it considers material in movement like stock transport in the same plant with transport etc..

    These are possible reasons why there is a difference in Mb5b as valuated stock or storage location/ batch stock.

    It also plays differently what kind of material is it, quantity valuated or value valuated. But what differently I still don't know yet.

    Thanks Rosh & AKPT.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.