Skip to main content

Notifications

Announcements

No record found.

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

Total On Hand vs Bin Contents - Qty Variance

Posted on by 128

Hello, MS Family. 

The first screen shot below is from the Item Availability by Event and the second screen shot is from Bin Contents, which is filtered by location and Item. 

The total quantity in Bin Contents is 2,707 and that is 1,920 less than what is listed in the Item Availability by Event.

I do not understand why there would be a different between the two, any help in understanding this variance would be greatly appreciated. 

pastedimage1654008599766v1.png

pastedimage1654008606786v2.png

  • Suggested answer
    Gabe Longoria Profile Picture
    Gabe Longoria 128 on at
    RE: Total On Hand vs Bin Contents - Qty Variance

    Hello, Josh.

    I discovered that the warehouse movement (in this instance it was a production put-away from one location to another) did not create the respective bin record in the bin contents page, which is something I have not seen before.

    When you mentioned the two versions of the bin contents page, I then thought to access Bin Contents via the Item Card. In there, I manually added the Bin that the Item was moved to and after doing that, it populated with the quantity that was missing from the Bin Contents page.

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Total On Hand vs Bin Contents - Qty Variance

    There are two versions of the bin contents page. One is via the item card, document lines, journals or bins from the location card. I find the other bin contents page helpful in this instance - search for it. It will show you how much of that item is still in process too. I expect that is the variance. Qty. on pick or to be put-away for example.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans