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.
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.
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
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
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.
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