Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Inventory in Stock but not in a BIN

Posted on by 5

We have an issue with our inventory.  We have (3) stocking locations that have their corresponding BINS.  We made it required that all items must have a bin, but in one of our locations if you don't choose a bin the items will go into that stocking location but no bin.  We show there is an item in stock but you can't get it out or transfer it because you need a bin.  How do we get these items into a bin or even use the item?

  • benovic Profile Picture
    benovic 350 on at
    RE: Inventory in Stock but not in a BIN

    you can try to create the bin content entry manually in the UI. sometimes this works. 

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,640 on at
    RE: Inventory in Stock but not in a BIN

    Natalie,

    I would recommend you to contact a partner and let them look at your entries and suggest a solution. It is a little difficult to propose a solution without looking at your database.

    I highly recommend doing all your changes/testing first on the Test DB.

  • Natalie C Profile Picture
    Natalie C 5 on at
    RE: Inventory in Stock but not in a BIN

    I appreciate all the help, but our inventory is so large that this seems too risky.  I am sure one of the developers did some hokey stuff and messed up our one location.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory in Stock but not in a BIN

    The system check you have no bin inventory to let you disable the "Bin mandatory" option, and it check if you have no location inventory to enable it.

    I'm not sure why you were able to enable Bin Mandatory while you have inventory on the location without bin

    BTW you should be able to correct this following :

    First remove all bins inventory related to your location (note item/qty somewere) then you will be able to disable "Bin mandatory". Then you will be able to  remove location inventory (note items/qty somewere). Then you will be able to enable back "Bin mandatory" then you will be able to refill the bin inventory.

    An alternative would be to set the Bin mandatory value to false in SQL time to remove the location inventory and set it back to true after that.

  • Natalie C Profile Picture
    Natalie C 5 on at
    RE: Inventory in Stock but not in a BIN

    It won't let me change this option because we do have some items in bins.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory in Stock but not in a BIN

    I think the option you're talking about is the "Bin Mandatory" on the location card.

    These option may have be checked after some movment been made without bin before.

    In this case I think uncheck this option, made the tranfers/adjustment then checked it back could be a solution. If anything goes wrong during this please double check you have no more opened item ledger entries on the location

  • Natalie C Profile Picture
    Natalie C 5 on at
    RE: Inventory in Stock but not in a BIN

    I tried the Calculate Whse. Adjustment and that didn't seem to do anything.  A little back story about me and my company, we got very little training and have been learning things as we go and usually by youtube and now this forum.  So I could have totally done the Calculate Whse. Adjustment wrong but when I do it, nothing happens.

    So I have an item in our MAN location, it shows we have it on the item card.  When you go to bin contents there isn't anything there for our MAN location.  If you click on the the number on the item card you can see the SN for this item but if you want to reclass it or use it on an order you can't because it isn't there to use because it is not in a bin.  Is there any way to just add it to a bin?

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,640 on at
    RE: Inventory in Stock but not in a BIN

    Go to the Item Journal and perform calculate whse. adjustment , check this link for more information, the functionality is same even though the blog refers to the old NAV version.

    navisionary.com/.../

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans