Question 1:
We have multiple warehouses, and each warehouse divided in Racks, Shelves and Bins. Is the correct way for location setup to define a tree like this:

...etc?

For a small warehouse, 20 racks, 5 shelves each, 6 bins.... that is 600 locations to create. That can't be serious, can it?

Question 2
Next, if I want to count my inventory, I need to generate lists ordered by rack, shelve and bin which include product name and quantity. These are the lists I use to hand to the counting people when they go into the warehouse for counting. Is there a way to generate those lists? You don't want to use lists sorted on product ID, do you?

jlinkels

Yes - they are serious, but you can import a CSV file to create the location records, so preparing in a spreadsheet is much easier.

Stocktake functionality is very limited - you will probably need to develop something to make it work the way you want.

Hi Kevin,

It seems that you are answering all my posts -- thanks for that.

I am relatively new with OpenERP, took the functional training tough.

What keeps amazing me is that OpenERP is offering a lot of options and sometimes goes a long way in the features that are implemented, but on the other hand very basic operations are impossible. Until now I have not been able to set up the administration for the company I currently work for in a satisfactory way. That is, the way our current administration software is set up. And I can assure you, it is nothing fancy, very basic, and according to standard Dutch rules.

jlinkels

I tend to agree - some of the add-on modules are worth looking at for extra functionality/fixes for gaps, but you may end up with having to build some parts yourself. Also suggest you check out the bugs when you find an issue as it may be a known problem.

I do, I do, I do....

jlinkels