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

View lots & qtys within Bins

(5) Share

Report

Posted on by Brett F

454

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 (8)

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (4)

Report
Copy link

Link copied!

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
Suggested answer

MarceloBorges 122 on at

Like (6)

Report
Copy link

Link copied!

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

Valentin Castravet 32,157 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

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

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

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

NAV_with_Narang 2,320 Moderator on at

Like (2)

Report
Copy link

Link copied!

Worthwhile checking this link out

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

Was this reply helpful? Yes No
Sumit Singh 11,757 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Hi,

This post dates back to August 2024, so it’s likely that the original poster has already found a solution or the issue has been resolved. To keep the feed relevant and avoid unnecessary comments from other experts, please refrain from adding new replies. Thank you for your understanding.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,808 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Use these built-in options to view lots by bin:

Power BI report: Bin Contents by Item Tracking – shows lots and quantities per bin.

Report 7319 – Warehouse Bin List: printable list of bins and quantities.

Or check Item Tracking Entries / Warehouse Entries for quick filtering.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

The best way to view lots and their quantities per bin in Business Central is to use Warehouse Entries or Item Tracking Lines with filters for Lot No. and Bin Code, as these pages provide detailed tracking information.

For a consolidated view, you can create a custom report or query using tables like Item Ledger Entry, Warehouse Entry, and Tracking Specification, or build a Power BI dashboard for visual analysis.

Was this reply helpful? Yes No