Contributors mailing list archives

contributors@odoo-community.org

Avatar

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

by
Open for Small Business, Graeme Gellatly
- 27/01/2022 08:15:41
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

Reference