Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Qty on hand is different from Bin

Posted on by 322
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
    Jun Wang Profile Picture
    Jun Wang 4,835 Super User 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
    MarisolC 322 on at
    Qty on hand is different from Bin
     
    CU04061328-0 sure...
     
     
     
  • CU04061328-0 Profile Picture
    CU04061328-0 4 on at
    Qty on hand is different from Bin
    Can I ask a question related to this?
  • MarisolC Profile Picture
    MarisolC 322 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
    Jun Wang 4,835 Super User 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
    MarisolC 322 on at
    Qty on hand is different from Bin
    There are no transactions pending...
  • gdrenteria Profile Picture
    gdrenteria 3,706 Super User 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
    YUN ZHU 62,133 Super User 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

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,741 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans