Skip to Content
Menu
This question has been flagged
3 Replies
1871 Views

Hello,


I've been struggling with this for some time and after many hours of trial and error and trying every conceivable search online, I admit failure.  Hopefully someone here might have some ideas.


I'm using Odoo 16.0 CE.


We have company that buys bulk bags of second-hand items - clothes, shoes, etc.  When we receive the bag we usually know the category of items inside (adult clothing, children shoes, toys, cookware, etc) but sometimes it is a mix of multiple categories.  We store the bags in a warehouse and open them over time. We need to track the number of bags in our warehouse, which is easy in Odoo.  The problem comes when we pull a new bag and need to convert it from a "Bulk bag of adult clothing" into whatever inventory items we find inside, for example: 17 pants, 23 shirts, 8 skirts, and 20 pairs of socks, etc.


Initially I thought that the manufacturing module would make this easy - simply consume 1 bulk bag and produce 17 pants, 23 shirts, ...  Well, I've tried to make that work in many different ways, both as manufactured products and as kits, but nothing works.  I tried "unbuilding" bulk bags and this almost worked, however it ultimately failed because Odoo forcibly decomposes the item precisely according to the types and numbers of products specified in the BoM.  Obviously making a new BoM for every combination is a bad approach. 


Has anyone had any success doing anything similar?  If so, can you point me in the right direction?


Thanks!

Avatar
Discard
Best Answer

Hi Theron:

I think enabling the by-products feature in Manufacturing and "manufacturing" the main items like pants, shirts, etc. by consuming the "bag" and producing the main item + the other items as by-products should take care of what you need. Make sure you set "Flexible Consumption" to "Allowed" on each of these BOMs.

Here's a sample scenario which takes 1 unit of "Clothing" and converts it to 10 pants, 7 shirts and 3 sweaters.

a. Enable "By-Products" in Manufacturing > Configuration > Settings like so.

b. Define BOMs for each of the items that you normally receive in the bags. For example, here's how you can define the BOM for Pants.

c. "Manufacture" the Pants (+ Shirts and Sweaters as by-products) by consuming the "Bags". The quantities in the MO can be anything other than 0 since you have allowed "Flexible Consumption".

UPDATE: You can also directly create such MOs without defining a BOM. Just make sure the quantity of the main product to produce (Pants in the example above) is set first before updating the "Components" and "By-Products", because updating the quantity to produce resets/recomputes all the others.

Avatar
Discard
Author Best Answer

(Can't reply to responses for insufficient karma. Seems my prior account got deleted for inactivity so I'm starting over from zero.)

Thank you Paresh and Chris for the insightful answers. Both appear workable.

Paresh, thank you for the detailed response. This approach worked perfectly!  I took it a step further and added an intermediate step of "Bulk Bag of Clothers" => produces => 50 "Unsorted clothing", then in a separate step 1 "Unsorted Clothing" => produces => 1 "Pair of slacks".  This makes it super easy to unbuild back to "Unsorted clothing" if a piece gets categorized incorrectly, etc.

Thanks again!

Avatar
Discard
Best Answer

A simple but not very "controlled" solution is to do a receipt from a dummy supplier for the contents of the bag and an issue to a dummy customer to consume the bag. 

These will be from / to virtual locations, which is how Odoo creates / removes stock.

You could also upload both transfers (receipt and issue) and give them matching transaction numbers for better traceability.

Avatar
Discard
Related Posts Replies Views Activity
3
Jun 25
2849
2
Feb 25
1537
0
Nov 24
1303
1
Oct 24
1508
3
Aug 25
6844