Skip to Content

Value against Stock/Value on 01/01/0000 in MB5B

Hi MM experts

I am a BI consultant and needed some help in understanding an inventory concept. I wanted to understand where does the value against the line Stock/Value on 01/01/0000 in MB5B come from and what does it mean ? Is it the initial stock value ? For example in the screenshot below the value 6,832.90 USD

is populated bu the qty for the same is 0. The problem is that this value messes up my calculation in the inventory cube in BI. The standard non-cumulative key figure 0VASTCKVAL in the inventory cube 0IC_C03 gets calculated based on an inflow and outflow, in the screenshot below those are the entries against Total/Val. of Receipts & Total/Value of Issues respectively which turns out to be a figure close to -6,000, whereas the stock is 0 as can be seen in the image below. When I add the 6,832.90 USD value to the Total/Val. of Receipts (inflow) my calculation becomes correct and I get a zero. But I do not understand what this value (6,832.90 USD) signifies.

Would appreciate any clarifications or advice.

Thanks

Sameer

mb5b.JPG (239.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Jul 07, 2016 at 03:11 AM

    Hi,

    It seems an inconsistency. Please let us know the selection options you have chosen. Also check whether the material type has been changed or the quantity update for the material type has been changed in between.

    In addition, refer the note: 1772782 - MB5B: Detailed information about opening and closing stock

    which explains the system design and the logic for MB5B. Refer the same and revert back.

    Regards,

    AKPT

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 07, 2016 at 06:53 AM

    hi

    as per my knowledge FI team adjust the stock and amount manually in the process matching the stock with physical and sap stock.

    Regards

    Sudhakar

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 09, 2016 at 08:52 AM

    Search for any rows with quantity equal to 0 and value not equal to zero? Like the following.

    Such things are possible in Test Systems if someone changes the FI config (Plant assignment to cocode) after documents are posted.

    Regards,

    Niranjan


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 09, 2016 at 03:58 PM

    Hi Sameer,

    Please check my analysis as below.

    1) Opening balance is 6,832.90 USD with 0 Quantity.

    2) The goods issue value is higher than the receipt value.

    Difference amount between GI and GR is 6,832.90 USD.

    3) Closing balance is 0 USD with 0 Quantity.

    Opening balance = 6,832.90 USD ➕

    Goods receipts = 77, 964. 35 USD

    -----------------------------------------------------------

    84, 797. 25 USD ➖

    Good Issues = 84, 797. 25 USD

    ---------------------------------------------------------

    = 0 USD

    ---------------------------------------------------------

    From the above analysis, I am concluding the MB5B report calculation is correct and there is no inconsistency. Hope this clarifies your doubt.


    BR, Rosh.


    5.PNG (92.9 kB)
    6.PNG (26.1 kB)
    7.PNG (70.8 kB)
    8.PNG (26.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 22, 2016 at 07:34 PM

    This was an inconsistency in the SAP/ECC system, I have raised a message to SAP support.

    Thanks everyone for having a look

    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.