Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Bin does not show as E...
Small and medium business | Business Central, N...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by Fares 48
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
  • Fares Profile Picture
    Fares 48 on at
    Bin does not show as Empty (boolean field) even though there is nothing in Bin Contents for it
    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
  • Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    Bin does not show as Empty (boolean field) even though there is nothing in Bin Contents for it
    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
     
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    Bin does not show as Empty (boolean field) even though there is nothing in Bin Contents for it
    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);
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans