Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Qty on hand is different from Bin

(1) ShareShare
ReportReport
Posted on by 103
I have this item: CM009 in location STC03, system says that I have 1,400 on hand:
 
 
When I check this quantities in Lots i see that I have 400 kg in lot ML240147C
 
I can't make any movement with this lot because in Bin Content it says I have zero but, in Qty On Hand I have 400.
 
If I select this lote in any transaction I got this message:
 
 
My Location has a simple setup, with no advanced funcionality, we only have 1 bin and this field is selected as mandatory:
 
 
 
Is there any way I can fix this, because in fact now, I only have 100 kg left from that lot, but I have been making adjustments in order to sell this product but qty on han still showing.
 
TIA.
 
Marisol
 
 
  • Suggested answer
    MarisolC Profile Picture
    103 on at
    Qty on hand is different from Bin
    My partner developed an extension in order to force to put bin as no requiered in order to make a transfer to another location and then reclasify my movement where it finaly belonged.
     
    No one can tell why this happened.
     
    First fail I had to deal with in BC.
  • Suggested answer
    Jun Wang Profile Picture
    7,761 Super User 2025 Season 1 on at
    Qty on hand is different from Bin
    from below screen the total qty is correct. 400 here means there is another request, possibly a sales order requesting from lot 47c
    the other log 918 has 1000, so the total is 1400, which agrees with the total qty on hand from item card.
     
    but you are not able to sell the 47c lot cause BC sees it as reserved, that is why the bin content shows 0.
     
    here is more info for your reference.
     
     
    Jun Wang
     
  • MarisolC Profile Picture
    103 on at
    Qty on hand is different from Bin
     
    CU04061328-0 sure...
     
     
     
  • CU04061328-0 Profile Picture
    4 on at
    Qty on hand is different from Bin
    Can I ask a question related to this?
  • MarisolC Profile Picture
    103 on at
    Qty on hand is different from Bin
    Jung Wan
     
    If I check Bin content, I got 1,400
     
     
     
    If I check Lot No. List, I got 400 for my troubled Lot:
     
    If I check Item tracing, I got 400 for lot ML240147C:
     
     
    If I check Warehouse Entries it says my lot has 0 Quantity (OMG)
     
     
     
    When I try to use it in my sales order Bin contents show zero Quantity,
     
    and I got this message:
     
    I really don't know what happened and most important, how can i fix it...
  • Suggested answer
    Jun Wang Profile Picture
    7,761 Super User 2025 Season 1 on at
    Qty on hand is different from Bin
    go to your bin content filter that lot tracked item and then see what shows on qty available to take field. The example shows 100 on hand qty but only 98 available to take. BC will automatically allocate lot tracked items to sales orders. 
     
    Jun Wang 
     
     
     
    BC further breaks down the lot tracked item into. So if BC says the item is not available it must has been allocated to other documents.
     
     
     
     
  • MarisolC Profile Picture
    103 on at
    Qty on hand is different from Bin
    There are no transactions pending...
  • Gerardo Rentería García Profile Picture
    19,829 Most Valuable Professional on at
    Qty on hand is different from Bin
    Hi
    Complementing what our colleague tells us, I give you a couple of links that I hope can help you.
    BR
    GR
  • Suggested answer
    YUN ZHU Profile Picture
    84,456 Super User 2025 Season 1 on at
    Qty on hand is different from Bin
    Is this Lot.No occupied by an unposted Transfer Order or Sales Order, etc.?
    You can check the detailed records of this Lot No. in Item Ledger Entries/Warehouse Entries.
     
    Hopefully other experts can give you better advice.
    Thanks.
    ZHU

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Featured topics

Product updates

Dynamics 365 release plans