Skip to Content
author's profile photo Former Member
Former Member

Total Stock vs Plant Stock

I have the following problem with the stock:

The total stock (MBEW-LBKUM) shown in the material master data (Accounting 1 tab) is not equal to the Plant Stock (MARD-LABST) shown in the Plant Stock tab (there is only unrestricted stock).

In my opinion they should be the same because:

- The valuation area is a plant (transaction OX14)

- I´m not using valuation categories (which determines the valuation type). Thus in table MBEW the field valuation type is blank, the same as the valuation category.

Any ideas on why the stock is different?

Thanks in advance!

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2009 at 01:31 PM

    I think that stock displayed in the accounting view, is only the valuated stock.

    And per as my knowledge, there are two types of restricted stock :

    1- Valuated ristrected stock (exapmle receipt stock with mvt type 107. So stock will be blocked but valuated)

    2 - Non valuated restricted stock (example receipt stock with mvt 103. So stock will be blocked but not valuated)

    I think that in the second case, you will not see the stock in the accounitng view.

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2009 at 01:47 PM

    Hi casal

    in the table MARD stock shown is at storage location level

    and in the table MBEW stock shown is at valuation level i.e. plant so it is showing different please check it

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2009 at 01:58 PM

    Really I don't know, but I think that with Tcode MB52 you can display the stock in its value in front of it

    So if you have no valuated stock you will get 0 in the Column value

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2009 at 04:53 PM

    Hi Agustin,

    MARD-LABST field refers to only unrestricted stock, so to get to plant stock, you would first have to add up the stocks in INSME & the other stock fields of the storage location, then you need to add up the stocks in the other storage locations of the plant as well. You will then be able to tie the quantities between MBEW & MARD.

    Hope it is clear now.

    If helpful award points

    Regards,

    Vivek

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      MARD

      LABST: 780.262,000-

      VMLAB: 40,000

      the rest of the fields (INSME, EINME, SPEME, RETME, etc) are blank...

      There is stock for only 1 storage location for the plant i'm using (and remember the valuation area is the plant and there are no valuation categories). So there is no stock in the other storage locations related to the plant...

      MBEW

      LBKUM: 12,000

      PS: there is also no stock in transit (i checked through MB5T)

      any other suggestions? thanks! 😊

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2009 at 05:54 AM

    Dear Agustin

    Actualy i was also facing the same problem in my previous project.Also I have gone thru some of the threads in SDN few ppl were facing the same problem

    just check the entries in Table

    MARD and MBEW for the material for which u are getting the difference.

    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

    Regds

    Shail

    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.