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

MM and FI value difference / MB5L

Hi,

We are having differences between MM valuation and G/L account valuation (inventory a/c). I ran report MB5L to get these differences.

My concern is how to find these differences or how to identity the transactions, materials etc. causing the differences.

I referred previous threads on this topic, but couldn't find the clear answer to how to find transactions/ materials causing differences.

I ran report MB5L with options - company code/ select balance, current period/ display individual material line.

Thanks,

Pat.

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 Jun 20, 2014 at 07:10 PM

    Root cause was found. 😊

    Its MR11 - GR/IR account maintenance. There was an enhancement during MR11 posting - not to post to inventory account, but to post to some other adjustment account. Because of this, whenever business used to clear GR/IR account, it used to change the MM valuation, but it was not hitting the inventory account causing the differences.

    How did we find the issue - we fetched all the entries from table BSEG for transaction KTOSL = BSX and G/L account HKONT # inventory account and analyzed the records.

    We have now removed that enhancement.

    Thanks for the help.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2014 at 04:18 AM

    Hi.

    Do refer the below KBA, which explains how the difference occurs in MB5L report with what reason and solution for the same.

    KBA: 1846376 - MM/FI difference occurs in transaction MB5L and report RM07MMFI for current year

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 12, 2014 at 04:21 AM

    Hi,

    Please refer the note: 968812 - MM/FI Difference for material stocks and the KBA: 1846376 - MM/FI difference occurs in transaction MB5L and report RM07MMFI for current year which explains the standard design. You may check the notes and verify the points mentioned in the note.

    Regards,

    AKPT

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 12, 2014 at 02:28 AM

    How you know that there are some difference in MM and FI valuation ? Who told you ?

    MB5L will give the stock amount of a G/L account.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 12, 2014 at 04:04 AM

    Hi,

    How you are sure-you are having differences between MM valuation and G/L account valuation (inventory a/c)?

    Cross check your MB5L report with report details by entering G/L account(inventory a/c) in FBL3N

    Also cross check by referring tables MBEW and MBEWH in t.code: SE11.

    Any difference just track all materials movement details in transaction code: S_P00_07000139

    Regards,

    Biju K

    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.