cancel
Showing results for 
Search instead for 
Did you mean: 

MM and FI value difference / MB5L

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

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.

Answers (4)

Answers (4)

Prasoon
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

BijayKumarBarik
Active Contributor
0 Kudos

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

former_member183424
Active Contributor
0 Kudos

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.