Skip to Content

Contributors

Manufacturing advice needed - materials of measured units being consumed partially

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



by Radovan Skolnik - 09:36 - 26 Jan 2022

Follow-Ups

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

    Yes. It is a well known problem. The 2D PaperCutting Problem, a lot less complex than the 3D one, aka Travelling Salesperson.

    As for where it goes. I don't know. As I say, I solved differently. Using Unbuild style you start from the raw material so it was never an issue. But to start you can just use a rule of thumb.

    On Thu, Jan 27, 2022 at 9:37 PM Radovan Skolnik <radovan@skolnik.info> wrote:
    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:
    
    

    by Graeme Gellatly - 10:05 - 27 Jan 2022
  • Re: Manufacturing advice needed - materials of measured units being consumed partially
    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
    
    
    
    
    

    by Radovan Skolnik - 09:35 - 27 Jan 2022
  • Re: Manufacturing advice needed - materials of measured units being consumed partially
    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> 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 [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 [2] [1]
    
    
    > > Post to: mailto: contributors@odoo-community.org [3] [2]
    
    
    > > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [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 [5] [8]
    
    
    > > Post to: mailto: contributors@odoo-community.org [6]
    
    
    > > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [7] [9]
    
    
    > > 
    
    
    > > 
    
    
    > > 
    
    
    > > [1]  https://odoo-community.org/groups/contributors-15 [8]
    
    
    > > [2] mailto: contributors@odoo-community.org [9]
    
    
    > > [3]  https://odoo-community.org/groups?unsubscribe [10]
    
    
    > > [4] mailto: dreis@OpenSourceIntegrators.com [11]
    
    
    > > [5]  https://www.magentointegrators.com/ [12]
    
    
    > > [6]  https://www.hadoopintegrators.com/ [13]
    
    
    > > [7]  https://www.usaodoo.com/ [14]
    
    
    > > [8]  https://odoo-community.org/groups/contributors-15 [15]
    
    
    > > [9]  https://odoo-community.org/groups?unsubscribe [16]
    
    
    > 
    
    
    > _______________________________________________
    
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15 [17]
    
    
    > Post to: mailto: contributors@odoo-community.org [18]
    
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe [19]
    
    
    > 
    
    
    > --
    
    
    > * James Dominy *
    
    
    > CEO
    
    
    > * Lunel, Inc *
    
    
    > Saratoga Springs, UT
    
    
    > 719-888-9582
    
    
    > jamesdominy@lunelerp.com [20]
    
    
    > * www.lunel.co [21]
    
    
    > *
    
    
    > 
    
    
    > _______________________________________________
    
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15 [22]
    
    
    > Post to: mailto:contributors@odoo-community.org
    
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe [23]
    
    
    > 
    
    
    > 
    
    
    > 
    
    
    > [1] mailto:radovan@skolnik.info
    
    
    > [2] https://odoo-community.org/groups/contributors-15
    
    
    > [3] mailto:contributors@odoo-community.org
    
    
    > [4] https://odoo-community.org/groups?unsubscribe
    
    
    > [5] https://odoo-community.org/groups/contributors-15
    
    
    > [6] mailto:contributors@odoo-community.org
    
    
    > [7] https://odoo-community.org/groups?unsubscribe
    
    
    > [8] https://odoo-community.org/groups/contributors-15
    
    
    > [9] mailto:contributors@odoo-community.org
    
    
    > [10] https://odoo-community.org/groups?unsubscribe
    
    
    > [11] mailto:dreis@OpenSourceIntegrators.com
    
    
    > [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:james@lunelerp.com
    
    
    > [21] http://www.lunel.co
    
    
    > [22] https://odoo-community.org/groups/contributors-15
    
    
    > [23] https://odoo-community.org/groups?unsubscribe
    
    
    
    
    

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by Graeme Gellatly - 09:15 - 27 Jan 2022
  • Re: Manufacturing advice needed - materials of measured units being consumed partially
    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 [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 [2] [1]
    
    > > Post to: mailto: contributors@odoo-community.org [3] [2]
    
    > > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [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 [5] [8]
    
    > > Post to: mailto: contributors@odoo-community.org [6]
    
    > > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [7] [9]
    
    > > 
    
    > > 
    
    > > 
    
    > > [1]  https://odoo-community.org/groups/contributors-15 [8]
    
    > > [2] mailto: contributors@odoo-community.org [9]
    
    > > [3]  https://odoo-community.org/groups?unsubscribe [10]
    
    > > [4] mailto: dreis@OpenSourceIntegrators.com [11]
    
    > > [5]  https://www.magentointegrators.com/ [12]
    
    > > [6]  https://www.hadoopintegrators.com/ [13]
    
    > > [7]  https://www.usaodoo.com/ [14]
    
    > > [8]  https://odoo-community.org/groups/contributors-15 [15]
    
    > > [9]  https://odoo-community.org/groups?unsubscribe [16]
    
    > 
    
    > _______________________________________________
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15 [17]
    
    > Post to: mailto: contributors@odoo-community.org [18]
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe [19]
    
    > 
    
    > --
    
    > * James Dominy *
    
    > CEO
    
    > * Lunel, Inc *
    
    > Saratoga Springs, UT
    
    > 719-888-9582
    
    > jamesdominy@lunelerp.com [20]
    
    > * www.lunel.co [21]
    
    > *
    
    > 
    
    > _______________________________________________
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15 [22]
    
    > Post to: mailto:contributors@odoo-community.org
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe [23]
    
    > 
    
    > 
    
    > 
    
    > [1] mailto:radovan@skolnik.info
    
    > [2] https://odoo-community.org/groups/contributors-15
    
    > [3] mailto:contributors@odoo-community.org
    
    > [4] https://odoo-community.org/groups?unsubscribe
    
    > [5] https://odoo-community.org/groups/contributors-15
    
    > [6] mailto:contributors@odoo-community.org
    
    > [7] https://odoo-community.org/groups?unsubscribe
    
    > [8] https://odoo-community.org/groups/contributors-15
    
    > [9] mailto:contributors@odoo-community.org
    
    > [10] https://odoo-community.org/groups?unsubscribe
    
    > [11] mailto:dreis@OpenSourceIntegrators.com
    
    > [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:james@lunelerp.com
    
    > [21] http://www.lunel.co
    
    > [22] https://odoo-community.org/groups/contributors-15
    
    > [23] https://odoo-community.org/groups?unsubscribe
    
    
    
    
    

    by Radovan Skolnik - 07:11 - 27 Jan 2022
  • Re: Manufacturing advice needed - materials of measured units being consumed partially
    Hello Radovan,

    First, to track your raw materials you should automatically be able to do it. Let’s say you buy rolls of cable every time to produce your own cables. The cable on hand quantity should get always be updated whenever you purchase new stock.

    The BOM will look like this:
    1. Certain amount of roll cable (maybe 50m for 50m final Ethernet cable)
    2. 2 connectors

    Now let’s say you have 21 manufacturing order or 21x50= 1050meter manufacturing order. But let’s say you have 1000m (1roll) in stock. The system in the MO will automatically show you that you don’t have enough stock to produce 1050m cable. If you have single MO, you can modify that or if you have 21 MO you can complete the extra MO later when stock arrives.

     If you want to automatically order the raw materials after certain quantity, you can use replenishment order.

    Secondly, use multiple UOM for sales and purchase. By that you can purchase in rolls but produce/sale in meters and consume accordingly.

    Regards,
    Md. Tanzilul Hasan Khan



    On Jan 27, 2022 at 2:37 AM, <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
    
    
    

    by ponkhi403 - 04:56 - 27 Jan 2022