1. Mailing Lists
  2. Contributors
  3. Re: Manufacturing advice needed - materials of measured units being consumed partially

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: Manufacturing advice needed - materials of measured units being consumed partially

Re: Manufacturing advice needed - materials of measured units being consumed partially

Avatar

Re: Manufacturing advice needed - materials of measured units being consumed partially

by
Data Dance s.r.o., Radovan Skolnik
- 27/01/2022 09:35:38 
Graeme,

this is what I was looking for and sort of confirms my suspicion that without 
special handling Odoo would sum contents of all lots of same kind into one 
(which perfectly makes sense when dealing with units, weights, volumes and 
such that can be added/joined).

Question though if I may: where should that pseudo-code fit in? Is that 
supposed to be extension somewhere in MRP BoM process where appropriate 
materials are being looked for when manufacturing the final product? Dumb 
question maybe but haven't had much experience with MRP yet.

Your algorithm actually reminds me very much of a thing I was doing just not a 
year ago as a favour to a friend who builds pergolas using alluminium joists 
of certain fixed size. From the design you receive required cutting sizes and 
you need to optimize how to cut the source material with the least waste.

But that was written in Excel and Visual Basic :-) However it is basically the 
same as what you have outlined.

Best regards

	Radovan

P.S.: BTW, have you had a chance to have a look at my comment regarding 
variant_seller_ids for product.[template|product]? Is till consider that thing 
broken and not following the desired design...

On štvrtok 27. januára 2022 9:17:06 CET Graeme Gellatly wrote:

> Hi,

> I've solved a similar problem. A bit more complicated, slitting coil into

> multiple widths, weights and lengths. No way to join. That was custom based

> around MRP Unbuild but a lot of the concepts still apply. Unbuild is still

> potentially an option. But in basic terms 1. Use Lot tracking. 2. Use

> orderpoints or similar. Now for the automatic reorder you might want some

> custom code for reordering. In pseudocode. a. counters = [[lot qty], [lot

> qty]] for finished_good in finished_goods.sorted(length desc):   find lot

> raw material that can handle   if found decrement counter.   if not found:

> buy some, break b.  if all lots < <some_length>: order

> c. Rule of thumb orderpoint. I hold 3 rolls. so 3 x max length of finished

> as total rolls means I need to order some more. Or whatever suites. It will

> be easiest that way. On Thu, Jan 27, 2022 at 7:11 PM Radovan Skolnik <

> radovan@skolnik.info [1] > wrote: Hello,

> thank you for all the answers.I guess I have to test this thoroughly. My

> worry is generally this: let's say I have 2 lots/rolls each with 50m raw

> cable remaining. I need to produce 100m final cable. I think the system

> would consider I have enough of raw cable for this. Because that would work

> for certain scenarios. Imagine you need 100kg of something to prdouce

> something else. If you have 2 lots each with 50kg you're good to go - you

> just combine 50kg from each. Similarily if it was pieces. All these can be

> joined / added. I am talking about scenario where partial residual amounts

> cannot be added together to create a larger piece / amount. Hope I am

> making myself clear. Best regards

> Radovan

> 

> On štvrtok 27. januára 2022 0:17:23 CET James Dominy wrote:

> > Hello Radovan,

> > I would track your rolls of cable using Lots, this way when the order

> > calls

> > for 25, 50, or 100 m of cable if the lot does not have the qty needed to

> > produce the ethernet cable it will use the lot that has enough for the

> > finished product. On Wed, Jan 26, 2022 at 3:57 PM Radovan Skolnik <

> > 

> >  radovan@skolnik.info [2] [1] > wrote: Daniel,

> > 

> > thank you for answer. Yes it does make sense. But will it cover scenario

> > where I have let's say 2 rolls with 50m remaining on each and I want to

> > produce 100m final cable? Because in such case a completely new roll

> > should

> > be ordered as I cannot join those 2 50m pieces together... So it comes to

> > a

> > requirement here that you just do not track the total number of meters

> > remaining but you need to track each roll individually. Similar example

> > would be a woodmaker who needs certain sizes of wood for various products

> > (chair, table, ...) and he procures wood in 3m planks. What is your

> > opinion? Best regards

> > Radovan

> > 

> > On streda 26. januára 2022 21:51:47 CET Daniel Reis wrote:

> > > I believe you need to use different Units of Measure (UoM).

> > > In this case, the "Cable" Product is purchased in "Rolls" and used

> > > in "Meters".

> > > The "Roll" UoM should be configured to convert to Meters at a rate

> > > of 1:1000.

> > > This way you track your cable stock in meters available, and you

> > > order to your supplier in rolls.

> > > Dos this make sense?

> > > Thanks

> > > Daniel

> > > 

> > > On 26/01/22 20:37, Radovan Skolnik

> > > wrote:

> > > 

> > > Hello,

> > > sorry for asking stupid questions here but I hope someone can provide

> > > some

> > > wisdom here that I am missing. Let's imagine this scenario: I produce

> > > Ethernet cables of various lengths - i.e. 25m, 50m, 75m, 100m, ... Each

> > > such final cable requires 2 connectors and that particular amount of

> > > "raw"

> > > cable. I can only buy raw cable in rolls of 1000m. So when I buy a new

> > > roll

> > > and produce one final 50m cable, 950m of raw cable remains. When I

> > > produce

> > > another of 100m length, 850m of raw cable remains. When my remaining raw

> > > cable on certain roll is 50m I cannot produce 100m final cable and need

> > > to

> > > order another raw cable roll. So the idea is tracking remaining quantity

> > > of

> > > somethings (products? lots? ...) that is bought at certain size and is

> > > being gradually consumed. There can of course be more of these (i.e. I

> > > have

> > > bought 3 rolls at the same time). Is there a way on how to model this?

> > > Manufacturing is not really my domain and looking through code of

> > > various

> > > modules I didn't find anything that would resemble such thing. Thank you

> > > very much. Best regards

> > > Radovan Skolnik

> > > 

> > > 

> > > _______________________________________________

> > > Mailing-List:  https://odoo-community.org/groups/contributors-15 [3] [2]

> > > [1] Post to: mailto:  contributors@odoo-community.org [4] [3] [2]

> > > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [5] [4] [3]

> > > 

> > > 

> > > 

> > > --

> > > DANIEL

> > > REIS*

> > > MANAGING DIRECTOR

> > > M:*

> > > +351 919 991 307

> > > E:*

> > > dreis@OpenSourceIntegrators.com [4]

> > > A:*

> > > Avenida da República 3000, Estoril Office B, #34

> > > 

> > > 

> > > None [5] None [6] None [7]

> > > 

> > > 

> > > _______________________________________________

> > > Mailing-List:  https://odoo-community.org/groups/contributors-15 [6] [5]

> > > [8] Post to: mailto:  contributors@odoo-community.org [7] [6]

> > > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [8] [7] [9]

> > > 

> > > 

> > > 

> > > [1]  https://odoo-community.org/groups/contributors-15 [9] [8]

> > > [2] mailto:  contributors@odoo-community.org [10] [9]

> > > [3]  https://odoo-community.org/groups?unsubscribe [11] [10]

> > > [4] mailto: dreis@OpenSourceIntegrators.com [11]

> > > [5]  https://www.magentointegrators.com/ [12] [12]

> > > [6]  https://www.hadoopintegrators.com/ [13] [13]

> > > [7]  https://www.usaodoo.com/ [14] [14]

> > > [8]  https://odoo-community.org/groups/contributors-15 [15] [15]

> > > [9]  https://odoo-community.org/groups?unsubscribe [16] [16]

> > 

> > _______________________________________________

> > Mailing-List:  https://odoo-community.org/groups/contributors-15 [17] [17]

> > Post to: mailto:  contributors@odoo-community.org [18] [18]

> > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [19] [19]

> > 

> > --

> > * James Dominy *

> > CEO

> > * Lunel, Inc *

> > Saratoga Springs, UT

> > 719-888-9582

> > 

> >  jamesdominy@lunelerp.com [20] [20]

> > 

> > *  www.lunel.co [21] [21]

> > *

> > 

> > _______________________________________________

> > Mailing-List:  https://odoo-community.org/groups/contributors-15 [22] [22]

> > Post to: mailto: contributors@odoo-community.org [23]

> > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [24] [23]

> > 

> > 

> > 

> > [1] mailto: radovan@skolnik.info [25]

> > [2]  https://odoo-community.org/groups/contributors-15 [26]

> > [3] mailto: contributors@odoo-community.org [27]

> > [4]  https://odoo-community.org/groups?unsubscribe [28]

> > [5]  https://odoo-community.org/groups/contributors-15 [29]

> > [6] mailto: contributors@odoo-community.org [30]

> > [7]  https://odoo-community.org/groups?unsubscribe [31]

> > [8]  https://odoo-community.org/groups/contributors-15 [32]

> > [9] mailto: contributors@odoo-community.org [33]

> > [10]  https://odoo-community.org/groups?unsubscribe [34]

> > [11] mailto: dreis@OpenSourceIntegrators.com [35]

> > [12]  https://www.magentointegrators.com/ [36]

> > [13]  https://www.hadoopintegrators.com/ [37]

> > [14]  https://www.usaodoo.com/ [38]

> > [15]  https://odoo-community.org/groups/contributors-15 [39]

> > [16]  https://odoo-community.org/groups?unsubscribe [40]

> > [17]  https://odoo-community.org/groups/contributors-15 [41]

> > [18] mailto: contributors@odoo-community.org [42]

> > [19]  https://odoo-community.org/groups?unsubscribe [43]

> > [20] mailto: james@lunelerp.com [44]

> > [21]  http://www.lunel.co [45]

> > [22]  https://odoo-community.org/groups/contributors-15 [46]

> > [23]  https://odoo-community.org/groups?unsubscribe [47]

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [48]

> Post to: mailto: contributors@odoo-community.org [49]

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [50]

> 

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [51]

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [52]

> 

> 

> 

> [1] mailto:radovan@skolnik.info

> [2] mailto:radovan@skolnik.info

> [3] https://odoo-community.org/groups/contributors-15

> [4] mailto:contributors@odoo-community.org

> [5] https://odoo-community.org/groups?unsubscribe

> [6] https://odoo-community.org/groups/contributors-15

> [7] mailto:contributors@odoo-community.org

> [8] https://odoo-community.org/groups?unsubscribe

> [9] https://odoo-community.org/groups/contributors-15

> [10] mailto:contributors@odoo-community.org

> [11] https://odoo-community.org/groups?unsubscribe

> [12] https://www.magentointegrators.com/

> [13] https://www.hadoopintegrators.com/

> [14] https://www.usaodoo.com/

> [15] https://odoo-community.org/groups/contributors-15

> [16] https://odoo-community.org/groups?unsubscribe

> [17] https://odoo-community.org/groups/contributors-15

> [18] mailto:contributors@odoo-community.org

> [19] https://odoo-community.org/groups?unsubscribe

> [20] mailto:jamesdominy@lunelerp.com

> [21] http://www.lunel.co

> [22] https://odoo-community.org/groups/contributors-15

> [23] mailto:contributors@odoo-community.org

> [24] https://odoo-community.org/groups?unsubscribe

> [25] mailto:radovan@skolnik.info

> [26] https://odoo-community.org/groups/contributors-15

> [27] mailto:contributors@odoo-community.org

> [28] https://odoo-community.org/groups?unsubscribe

> [29] https://odoo-community.org/groups/contributors-15

> [30] mailto:contributors@odoo-community.org

> [31] https://odoo-community.org/groups?unsubscribe

> [32] https://odoo-community.org/groups/contributors-15

> [33] mailto:contributors@odoo-community.org

> [34] https://odoo-community.org/groups?unsubscribe

> [35] mailto:dreis@OpenSourceIntegrators.com

> [36] https://www.magentointegrators.com/

> [37] https://www.hadoopintegrators.com/

> [38] https://www.usaodoo.com/

> [39] https://odoo-community.org/groups/contributors-15

> [40] https://odoo-community.org/groups?unsubscribe

> [41] https://odoo-community.org/groups/contributors-15

> [42] mailto:contributors@odoo-community.org

> [43] https://odoo-community.org/groups?unsubscribe

> [44] mailto:james@lunelerp.com

> [45] http://www.lunel.co

> [46] https://odoo-community.org/groups/contributors-15

> [47] https://odoo-community.org/groups?unsubscribe

> [48] https://odoo-community.org/groups/contributors-15

> [49] mailto:contributors@odoo-community.org

> [50] https://odoo-community.org/groups?unsubscribe

> [51] https://odoo-community.org/groups/contributors-15

> [52] https://odoo-community.org/groups?unsubscribe

Reference