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

View lots & qtys within Bins

(5) Share

Report

Posted on by Brett F

450

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,236 Most Valuable Professional on at

Like (4)

Report

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

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 31,481 Super User 2025 Season 2 on at

Like (5)

Report

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 95,729 Super User 2025 Season 2 on at

Like (4)

Report

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,294 Moderator on at

Like (2)

Report

Worthwhile checking this link out

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

Was this reply helpful? Yes No
Sumit Singh 10,273 on at

Like (5)

Report

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 6,340 on at

Like (1)

Report

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,639 Super User 2025 Season 2 on at

Like (1)

Report

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