Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / View lots & qtys withi...
Small and medium business | Business Central, N...
Unanswered

View lots & qtys within Bins

(1) ShareShare
ReportReport
Posted on by Brett F 344
Hello,
What is the best way to view lots and their quantities per bin? Ideally it would be a report
Categories:
Dynamics 365 Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 84,562 Super User 2025 Season 1 on at
    View lots & qtys within Bins
    This is what I think is a bad thing about BC, there is no Bins -> Lot list.
    Hope the following helps as well.
    D365 Business Central : Checking Lot Numbers in Bin Content
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 28,279 Super User 2025 Season 1 on at
    View lots & qtys within Bins
    You can use the Bin Contents Page and look at the Lot Numbers by Bin Factbox. The Bin Contents page shows your item quantity by bin, and the Lot Numbers by Bin Factbox shows the lots per bin. You can also expose this factbox as a page/query to consume it in excel/power bi. 
     
     
     
     
  • Suggested answer
    MarceloBorges Profile Picture
    MarceloBorges 116 on at
    View lots & qtys within Bins
    I would suggest you go to the Warehouse Entries page and enter the Data Analysis Mode.
     
    Then you can setup a Pivot view grouped by Bins and Lot Nos.
     
    And if you want to save this to Excel, you can just Right click anywhere on the table and Export to Excel:
     
    It would look something like this:
     
    Notice how you can still expand and collapse groups in Excel.
     
    This would be my preferred way of accomplishing this.
     
    Good luck!
  • Suggested answer
    Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 19,937 Most Valuable Professional on at
    View lots & qtys within Bins
    Hi
    Here there are some reports, like this Warehouse bin list.
    Best
    GR

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

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans