Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Different Quantities between item and warehouse ledger entries

(2) ShareShare
ReportReport
Posted on by 18
Hi, 
 
We have an issue where the inventory on the item card says 160 but if we take a look at the bin-content it's all at zero. 
 
I've done an anaylsis and noticed that the sum of all warehouse  ledger entry quantities is zero but the sum of all item legdger entries is 160.
When I run the "calculate warehouse adjustment..." no lines appear. 
 
I'm at a loss of how to trouble shoot further what the cause and the correct solution for this is. 
 
Does the difference mean that there was a warehouse entry without a corresponding item entry? Or a mismatch in quanties? 
 
Any feedback is much appreciated. Thank you in advance
  • Suggested answer
    Alexander Drogin Profile Picture
    Alexander Drogin 256 on at
    Different Quantities between item and warehouse ledger entries
    Most likely this means a warehouse entry posted without an item ledger entry and an additional incorrect posting on the adjustment bin. Warehouse entry without a corresponding item ledger entry is a normal situation. This is why we need the "Calculate warehouse adjustment" job - it is intended to reconcile the warehouse with the inventory.
     
    "Calculate warehouse adjustment" calculates the quantity in the location's adjustment bin, and if this quantity is 0, then the warehouse stock is considered to be reconciled with the inventory. But there are loopholes that allow to post an entry from the warehouse journal directly to the adjustment bin, thus disrupting the warehouse adjustment.
     
    Take a look at this discussion: this is the same situation, and essentially this is what you need to do to fix the discrepancy.
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,147 Super User 2025 Season 1 on at
    Different Quantities between item and warehouse ledger entries
    Did you not enter the Bin when posting the details? If so, this will only generate Item Ledger Entries, not warehouse entries.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 7,919 Super User 2025 Season 1 on at
    Different Quantities between item and warehouse ledger entries
  • VaHiX Profile Picture
    VaHiX 4,350 Super User 2025 Season 1 on at
    Different Quantities between item and warehouse ledger entries

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans