Skip to main content

Notifications

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

Inventory in Stock but not in a BIN

(0) ShareShare
ReportReport
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,745 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,745 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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans