View lots & qtys within Bins

(1) Share

Report

Posted on by Brett F

432

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 90,113 Super User 2025 Season 2 on at

Like (1)

Report

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

https://thatnavguy.com/checking-lot-numbers-in-bin-content/

https://www.youtube.com/watch?v=oYY90fKLWoU

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 28,392 Super User 2025 Season 2 on at

Like (2)

Report

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

MarceloBorges 116 on at

Like (3)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 22,526 Most Valuable Professional on at

Like (0)

Report

View lots & qtys within Bins

Hi

Here there are some reports, like this Warehouse bin list.

Inventory and warehouse reports and analytics - Business Central | Microsoft Learn

Best

GR

Was this reply helpful? Yes No