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

Bin does not show as Empty (boolean field) even though there is nothing in Bin Contents for it

(1) Share

Report

Posted on by Fares

167

Hello,

I'm curious about why this happens.

I have a bunch of bins for which this is happening. Here is an example :

However when going into the Contents of the one selected, there are no lines :

Could anyone shed some light on this ?

Thank you,

Fares

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Mohana Yadav 61,186 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Empty field is calculated based on the Warehouse Entry table and NOT Bin Content table.

local procedure UpdateBinEmpty(NewWarehouseEntry: Record "Warehouse Entry") var WarehouseEntry: Record "Warehouse Entry"; IsHandled: Boolean; begin OnBeforeUpdateBinEmpty(NewWarehouseEntry, Bin, IsHandled); if IsHandled then exit; if NewWarehouseEntry.Quantity > 0 then ModifyBinEmpty(false) else begin WarehouseEntry.SetCurrentKey("Bin Code", "Location Code"); WarehouseEntry.SetRange("Bin Code", NewWarehouseEntry."Bin Code"); WarehouseEntry.SetRange("Location Code", NewWarehouseEntry."Location Code"); WarehouseEntry.CalcSums("Qty. (Base)"); ModifyBinEmpty(WarehouseEntry."Qty. (Base)" = 0);

Was this reply helpful? Yes No
Jun Wang 8,208 Moderator on at

Like (1)

Report
Copy link

Link copied!

there are primarily two reasons to this. first, users need to assign an item to a bin as fixed or default, or both if you like. in the below screen w010002 shows as empty and there is no qty of item there.

the other bin w020001 doesn't have empty set to yes, so user may assume it has content. But actually, it doesn't.

it may seem strange, but if you check the warehouse entries

there is no entry for that bin so I think that should be the reason. If transactions have been done to the bin for that item, BC will set Empty to Yes if that item is emptied from the bin. you could test this out.

hope this helps.

if you have further questions, you could either drop it here or shoot me a message on linkedin

Was this reply helpful? Yes No
Fares 167 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Sorry for the delay, I had forgotten that I posted here until the issue surface again.

I just checked the value of the Empty boolean against Warehouse Entries and was unable to correlate.

For example, R16 is not shown as Empty while R17 is :

Both have no actual content :

And both have no Warehouse Entries :

Thank you again for the help,

Fares

Was this reply helpful? Yes No