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

Let’s be real, nobody wants to see unexplained variances between your MM and FI balances in SAP. You run MB5L expecting clean numbers, and bam, there’s a gap that throws off your inventory valuation. It’s not just a technical headache. It’s an audit risk, a month-end close blocker, and a controller’s worst nightmare. But here’s 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 with confidence and control.

What Is MB5L and Why Does It Matter?

MB5L in SAP is the go-to transaction for reconciling inventory between: 
  • 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, it means your material values (MM) and your financial accounting (FI) are out of sync and that throws a wrench in accurate reporting. Now, you might be wondering: *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)

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.

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.

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.

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 on a product in the warehouse but not updating your financial books, of course there’s going to be a mismatch.

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: We once saw a user post $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.

See also
Material Master Multiple Choice Questions Answers

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP MM Books
SAP Material Management Certification, Interview and Configuration Reference Books

SAP Material Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.