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

Item Inventory

(4) Share

Report

Posted on by Brad613

164

Hello,

I'm trying to find a way to check inventory. My items have part numbers, lots, and expiration dates. Is there a way to view a bins contents with item quantities, lots and expiration dates? The Items list only give the location not the bin. Bin contents doesn't give the lots or expiration dates. It seems quite difficult to just get basic info in one spot. All I need is Bin location, quantity, the lot and expiration date so I can verify the physical inventory against the system.

Any help, ideas or suggestions are welcome.

Thank you for your time.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Martin Dráb 239,285 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

Which D365 product are you using? The D365 brand covers quite a few things, such as Finance and Operations, Business Central or Customer Engagement.

Isn't it D365 Supply Chain Management in this case?

Was this reply helpful? Yes No
Brad613 164 on at

Like (1)

Report
Copy link

Link copied!

I can't even reply to replies.

Dynamics 365 Business Central

Was this reply helpful? Yes No
Brad613 164 on at

Like (1)

Report
Copy link

Link copied!

@Martin Dráb

I'm using Dynamics 365 Business Central

Was this reply helpful? Yes No
Martin Dráb 239,285 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

OK, thank you for the clarification. The question belongs to Small and medium business | Business Central, NAV, RMS forum, therefore let me move it there.

Was this reply helpful? Yes No
Suggested answer

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

Like (3)

Report
Copy link

Link copied!

You can use the following:

1. In the bin content page you can personalize the page to add the Lot Numbers by Bin Factbox, this will show you the lot numbers in each bin. Note that it won't have the expiration dates.

2. You can use the Warehouse Entries page and get all the information you need, you can export this page to excel or use analysis mode

3. Try some of the new power bi inventory reports

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,857 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

For reporting at the Location -> Bin -> Item tracking details level, it is not in the standard. So the best approach is to customize a report or submit this idea to Microsoft.

Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas

PS: Dynamics 365 Business Central: How to quickly check inventory quantity for locations at Item-Variant level (Variant inventory per location)

https://yzhums.com/54104/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

Hello,

You can customize the change and you can add the Bin Code and Other Required Details in Item Ledger Entries or Warehouse Entries. So All the Related details can be displayed from 1 place.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,287 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

You can customize report:

Please check this: https://community.dynamics.com/forums/thread/details/?threadid=d0a18d1e-c955-ef11-a317-000d3a8f0501

https://learn.microsoft.com/en-us/dynamics365/business-central/reports/report-5809

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,278 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can check the Item Availability Page where you have different option to see the inventory levels,

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

The Item Availability Page is based on the item ledger entries so it doesn't have bin information

Was this reply helpful? Yes No