How to Fix Inventory Reconciliation Issues Between MM and FI in SAP (MB5L)

Nobody wants to see unexplained variances between MM and FI balances in SAP. You run MB5L expecting clean numbers, and there's a gap that throws off inventory valuation — not just a technical headache, but an audit risk, a month-end close blocker, and a controller's worst nightmare. The good news: these mismatches are common, predictable, and absolutely fixable. Whether you're a financial controller, SAP FI/CO consultant, or internal auditor, this guide walks you through exactly why MB5L variances happen and how to resolve them.

What Is MB5L and Why Does It Matter?

MB5L in SAP is the go-to transaction for reconciling inventory between two layers:

MM layer — Material values pulled from the MBEW table
FI layer — G/L balances fetched via BSEG, based on inventory accounts configured in T030 (via OBYC)

If these numbers don't match, your material values (MM) and financial accounting (FI) are out of sync — throwing a wrench in accurate reporting. So how do values even get out of sync in the first place? Let's break it down.

Top 5 Root Causes of MB5L Variances (And How to Fix Each One)

Cause 1

Valuation Class Was Changed (But History Wasn't)

The problem: You updated the material's valuation class. That changes the G/L account assignment but historical values don't magically migrate in FI.

What to do

Run MB5B to trace historical valuation classes.
Check OBYC for consistent account mapping.
If needed, book a journal voucher (JV) with a clear audit trail to align balances.

💡 Pro tip: Always document valuation changes and review them with your finance team before month-end.

Cause 2

MR11 Was Run After MMPV (Month-End Close)

The problem: MR11 adjusts GR/IR, but if you run it after MMPV, it won't reflect in stock balances properly.

What to do

Always execute MR11 before MMPV.
Use MB5S to monitor open GR/IR items.
Lock in a consistent closing checklist to avoid sequencing errors.

💡 Real-world tip: Automate reminders for key users before MMPV runs.

Cause 3

Manual Journal Entries to Inventory G/Ls

The problem: Someone posted a manual JV (e.g., via FB50) directly to an inventory account. That updates FI but bypasses MM.

What to do

Set inventory accounts to "Post Automatically Only" in FS00.
Run FBL3N regularly to audit unexpected postings.
Educate finance teams on proper posting flows.

💡 Quick win: Add a hard control in FS00 to block manual postings — it's simple and effective.

Cause 4

MR21 Was Used Without Posting to FI

The problem: MR21 updates the standard price in MBEW but doesn't post to FI (no BSEG update).

What to do

Follow MR21 with MR22 to record a balancing accounting entry.
Require a controlled approval process for material price changes.
Make sure both MR21 and MR22 are part of your price update SOP.

💡 Analogy: It's like changing the price tag in the warehouse but not updating your financial books — of course there's going to be a mismatch.

Cause 5

Incorrect G/L Account in MIRO (Manual Overrides)

The problem: A user manually changed the G/L account during invoice verification (MIRO), causing the FI side to go off-track.

What to do

Tighten account determination in OBYC.
Use MIRO layout controls to restrict manual overrides.
Implement exit EXIT_SAPLMRMP_010 to enforce G/L rules.

💡 Example: A user once posted $1M to a freight clearing account instead of inventory. The month-end variance wasn't just large — it was painful to unwind.

Best Practices to Keep MM and FI in Sync

Consistency beats cleanup. Here's how to prevent future MB5L headaches:

Run MB5L, MB5B, MB5S, MR11, FAGLL03, and FBL3N in your month-end playbook.
Use SAP Notes that enhance MB5L accuracy and structure.
Adopt Material Ledger in S/4HANA for real-time valuation tracking.
Use CKM3 to trace inventory value flows end to end.
Set up automated variance alerts via SAP workflow or BI tools.

Metrics That Tell You You're Winning

Here's how you know your reconciliation game is strong:

🎯 Zero variances in MB5L at period close

🚫 No manual journal entries to inventory accounts

📋 Fully documented, auditable price changes

⚡ Faster close cycles and clean audit trails

Wrapping It Up: MB5L Doesn't Have to Be a Black Box

You don't need to be a forensic accountant to fix MB5L issues. You just need the right tools, a bit of process discipline, and visibility into how MM and FI really interact.

Get your reconciliation steps right, and your SAP inventory will not only align — it'll become an asset, not a liability, during audits.

Bonus Tip

📝

Document each root cause you resolve in a knowledge base. That way, your future self or your teammates won't have to reinvent the wheel next period.