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?
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.
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.
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.
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 10/24/13, 6:28 PM|
|Seen: 2650 times|
|Last updated: 3/16/15, 8:10 AM|