- Mailing Lists
- Contributors
- Manufacturing advice needed - materials of measured units being consumed partially
Archives
- By thread 1419
-
By date
- August 2019 59
- September 2019 118
- October 2019 165
- November 2019 97
- December 2019 35
- January 2020 58
- February 2020 204
- March 2020 121
- April 2020 172
- May 2020 50
- June 2020 158
- July 2020 85
- August 2020 94
- September 2020 193
- October 2020 277
- November 2020 100
- December 2020 159
- January 2021 38
- February 2021 87
- March 2021 146
- April 2021 73
- May 2021 90
- June 2021 86
- July 2021 123
- August 2021 50
- September 2021 68
- October 2021 66
- November 2021 74
- December 2021 75
- January 2022 98
- February 2022 77
- March 2022 68
- April 2022 31
- May 2022 59
- June 2022 87
- July 2022 141
- August 2022 38
- September 2022 73
- October 2022 152
- November 2022 39
- December 2022 50
- January 2023 93
- February 2023 49
- March 2023 106
- April 2023 47
- May 2023 69
- June 2023 92
- July 2023 64
- August 2023 103
- September 2023 91
- October 2023 101
- November 2023 94
- December 2023 46
- January 2024 75
- February 2024 79
- March 2024 104
- April 2024 63
- May 2024 40
- June 2024 160
- July 2024 80
- August 2024 70
- September 2024 62
- October 2024 121
- November 2024 117
- December 2024 89
- January 2025 59
- February 2025 104
- March 2025 96
- April 2025 107
- May 2025 52
- June 2025 72
- July 2025 60
- August 2025 81
- September 2025 124
- October 2025 63
- November 2025 22
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 terms1. 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 handleif found decrement counter.if not found: buy some, breakb.if all lots < <some_length>: orderc. 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 connectorsNow 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 KhanHello, 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
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by ponkhi403 - 04:56 - 27 Jan 2022