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

Any way to display item availability quanitity by location, bin, & lot no.?

(1) Share

Report

Posted on by RH

396

Hello all,

For a company that relies on lot no./expiration date for most raw materials coming in and reselling out we rely heavily on lot number/item tracking lines.

It seems all separated and not very clear where to find their respective bins/lot numbers.

Where can I combine this info? so I can quickly search for a location each morning to display all available quantity of items, their bins#, and lot# altogether on one page?

It can even be one item but I need all that info on one page.

Thanks!

I have the same question (0)

All responses (6)

Answers (0)

Vishal Goswami 14 on at

Like (0)

Report

hi

I use Dynamics Business central for pharma company that also have lots of Lot and bins info. The information you looking for can be found in item card but out of the box system won't have all the information you are looking for so i had the same issue so with customisation we added some data in lot no by Item card

and now its looks like this.

Lot No. Expiry Date Location Code Bin Code Qty. (Base) Type Country Code

3AA6575 31/05/2026 ABCXYZ 2,496.

So may be your implementation partner can help you with some customisation and that will resolve your issue

Thanks

Vishal

Was this reply helpful? Yes No
Suggested answer

M0HAN SINGH 366 on at

Like (1)

Report

Hi, if you are using warehouse then can check out the warehouse entries whether your requirement is full filling or not. and can use analyze mode as per your requirement. Other wise customization will be require to achieve this.

Was this reply helpful? Yes No
Suggested answer

Ziyad Y. Najami 10 on at

Like (1)

Report
Hello

I hope this Query helps you

query 59100 "Item Ledger Entry Ziyad" { APIGroup = 'ZiyadNJ'; APIPublisher = 'ZiyadNJ'; APIVersion = 'v1.0'; EntityName = 'ItemByLot'; EntitySetName = 'ItemByLot'; QueryType = API; elements { dataitem(ItemLedgerEntry; "Item Ledger Entry") { DataItemTableFilter = "Lot No." = filter(<> ''), Open = filter(= true); filter(Item_NoF; "Item No.") { } filter(Variant_CodeF; "Variant Code") { } filter(Location_CodeF; "Location Code") { } column(Item_No_; "Item No.") { } column(Location_Code; "Location Code") { } column(Lot_No; "Lot No.") { } column(Remaining_Quantity_Sum; "Remaining Quantity") { ColumnFilter = Remaining_Quantity_Sum = filter(<> 0); Method = Sum; } } } }

This Query for Lot and the same can be applied for Serial and Bin.

It is of Type API (because I have been working on an integration) so please take that into consideration and modify it.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (0)

Report

apart from customization, you could go to warehouse entries page, filter the item by location, it shows lot no. serial no. expiration date.

The issue is you have to summarize it.

Was this reply helpful? Yes No
Vishal Goswami 14 on at

Like (0)

Report

Warehouse Entries only show movement of inventory but it will be very complicated to find out available stock per lot per bin, when we have various lots are in coming and thigs get more complicated if other factor like country is involve.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,387 Super User 2025 Season 2 on at

Like (1)

Report

This is a good use case for a reporting tool such as Power BI or Jet Reports. A report could be built in either of those 2 that would display what you're looking for.

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