You’re offline. This is a read only version of the page.
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,
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
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
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
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
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
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
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
Eva,
Yes, if Floating you will need to do a lookup to see which Bin has the Item to fulfill the Line.
Thanks,
Steve
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,232
Super User 2024 Season 2
#2
Martin Dráb
230,064
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (