Skip to Content
Menu
This question has been flagged
2 Replies
9179 Views

If you have a large warehouse with multiple locations for products, how can you do a physical inventory?

The product definition allows you to define a physical location in which the product is stored, but what if the products are stored in multiple areas of a warehouse?

Avatar
Discard
Best Answer

Firstly, the standard OpenERP stocktake logic is a bit simple and has some limitations if you have serialised products.

Putting that to one side, you are faced with two choices.

  1. Standard OpenERP does not have the concept of stock by bin location which is normal for large warehouses. If you want this then there is a v6 community module which is pretty good. My client that I was investigating this for decided stock by bin was too complex, so I haven't looked at in the last couple of years. If you install this module you will need to test the standare stock-take logic, and you will probably have to fix.

  2. You go standard - this means that despite products being in multiple locations in your warehouse you treat them as one location (say stock) for on hand and count purposes. A quick and dirty half-way house would be to record the actual locations against the product (so product_id, location_id, bin_name) and print this onto your documentation.

Avatar
Discard
Best Answer

Firstly, I'm new to OpenERP, and even ERP. I imagine if you have the same product stored in multiple locations within the warehouse, then there might be something wrong with the warehouse procedure itself. Otherwise, then I imagine you could create a module "warehouse locations", then remove the fields for product location, then add field to link to multiple locations (many2one, one2many) to the product.

Avatar
Discard
Author

If the objects are extremely large, like pallets of drywall or lumber, there is no way you can store it in a small location. And adding a o2m m2o relationship does not let you specify the number of products in a location.

Related Posts Replies Views Activity
1
Aug 16
10214
1
Mar 15
3896
1
Mar 15
5378
0
Mar 15
4550
1
Jul 25
433