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

Different Quantities between item and warehouse ledger entries

(2) Share

Report

Posted on by Max De Vos

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

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at

Like (1)

Report

I hope this thread can help you

https://forum.mibuso.com/discussion/28958/different-between-item-inventory-qty-and-bin-content-qty

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps as well: https://forum.mibuso.com/discussion/25552/quantity-on-warehouse-entry-and-item-ledger-entry-not-same

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Alexander Drogin 262 on at

Like (0)

Report

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.

Advance warehouse

Was this reply helpful? Yes No