Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Warehouse management m...
Small and medium business | Business Central, N...
Answered

Warehouse management module - Bins

(0) ShareShare
ReportReport
Posted on by Eva 189

Hey! 

I have a question about the warehouse module and bins. 

A quick backstory: I have a customer who wants to start using bins without Direct put-away and pics. We will start using bins at existing locations. We have concluded that the best way to do this is to remove all the inventory from the location (without bins), then activate bin mandatory in the location card, and then adjust the inventory back into the location with the bins. The customer also uses a hand scanner. 

In addition to this, the customer wants NAV to propose a warehouse location (bin) where there is an available balance. They do not want to have to go into each order and decide which bin an item should be picked from, they want it to be based on stock control. It should also be a floating warehouse, they do not want to define by default that an item should always be in a certain warehouse location. Does anyone know if this is possible in standard or if it requires development? 

When receiving an item in the warehouse the warehouse worker must specify in which bin they have placed the item. However, it is also preferable if there is a function that suggests that "there are already two of this item in this bin, use the same bin". Is that a function within standard or does it require development?


Best regards, 
Eva

  • Eva Profile Picture
    Eva 189 on at
    RE: Warehouse management module - Bins

    Hi  !

    Thanks, it helped

    Best regards, 
    Eva

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Warehouse management module - Bins

    Eva,

    Sorry for delayed reply but took some extended time off. Run the Warehouse Bin List and set flag "show contents" in request page.

    Hope this helps.

    Thanks,

    Steve

  • Eva Profile Picture
    Eva 189 on at
    RE: Warehouse management module - Bins

    Hi  

    Thanks! Could you please show where to find this report, I've been looking for it without any results?

    Also, do you know why NAV marks a bin content with both default and fixed? I tried to change the settings in the location (Default bin selection), but it does not work. I want it to only put a check mark on 'Default'. 

    Again, I really appriciate your answers, helps a lot! 


    Best regards, 
    Eva

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Warehouse management module - Bins

    Eva,

    Sounds perfect but add running the Bin Content Report so you can see all the Items in a Bin. You can run the report or view on the screen.

    Thank you,

    Steve

  • Eva Profile Picture
    Eva 189 on at
    RE: Warehouse management module - Bins

    Hi

    Thanks for the reply. I did the following:

    1. I searched for Physical Inventory Journals, I calculated the inventory and filtered on the location.

    2. I exported the result to excel so I would keep track on the original values of the inventory in my location.

    3. I changed the Quantity (physical inventory) to 0 on all rows and then I posted it.

    4. I went back to the location and activated Bin Mandatory.

    5. I added some bins to the location.

    6. In this step I wanted to adjust the inventory, so I searched for item journal. I filled in a row with positive adjustment, and just as you said this was done so I would have an Item Journal with the fields when exporting to excel.

    7. I then created a config package for table 83 and exported it to excel. When all rows were filled I saved the file and imported it to the system.

    8. The last step I did was posting the item journal and checked the quantities with a function called Items by location.

    Does this sound correct to you?

    Best regards,

    Eva

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Warehouse management module - Bins

    Eva,

    If I had a Location and turned on Bin Mandatory I would have open the Item Ledger Entries table and filtered on Open. This will show me all the Items that have a QOH. Then I would create an Item Journal and add 1 line with a Negative Adj.  I would then Open in Excel so I have the Item Journal with the fields. I then create all the Negative rows for the Items Open in the ILE. Then I will create a Positive Adj. for the same Items and this time add a Bin Code. This also allows me to confirm the Unit Cost is the same.

    Do you follow the steps? I can provide pics if you need them.

    Thanks,

    Steve

  • Eva Profile Picture
    Eva 189 on at
    RE: Warehouse management module - Bins

    Hi  

    I have a question that came up while working on activating bins in the system since I encountered some issues while doing so. We managed to remove all the inventory from the location (without bins), then we activated 'bin mandatory' in the location card. We did this successfully by using config.packages. However, when we wanted to adjust the inventory back into the location with the bins (by importing our excel file) the quantities were messed up and we couldn't figure out what the problem was.

    Would you please explain how you would do this in the system? How would you remove all the inventory from the location that has no bin and then adjust the inventory back into the location with the bins? I would really appreciate your input here.

    Best regards,

    Eva

  • Verified answer
    Eva Profile Picture
    Eva 189 on at
    RE: Warehouse management module - Bins

    Hi again !

    Okey, now the difference is very clear to me. Thanks for the screenshots :)

    Best regards,

    Eva

  • Eva Profile Picture
    Eva 189 on at
    RE: Warehouse management module - Bins

    Hi Claudio Martell!

    I totally agree with you. Using Directed Put away and Pick would be a much more preferable option.

    Thank you very much!

    Best regards,

    Eva

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Warehouse management module - Bins

    Eva,

    Yes, if Floating you will need to do a lookup to see which Bin has the Item to fulfill the Line.

    Thanks,

    Steve

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