Skip to Content

Contributors

Mounting location of part upon production

Hello,

I'm dealing with a situation where upon production, the mounting 
location of the parts needs to be registered.

Imagine a chair with 4 identical legs, but it needs to be registered 
which leg is placed where: front right, front left, rear right or rear left.

Is there something for this case in Odoo? What I could come up with is:

- Requiring work orders for "leg mounting", and specifying the mount 
location on the work order

- Having separate products eg "Left rear leg" and producing these from 
"Leg" (seems a bit of a hassle)

- Adding a required field on stock move line in case certain products 
are produced, where the mount location is filled in; also enforce 1.0 as 
a quantity

- ...

-Tom


by Tom Blauwendraat - 12:57 - 5 Feb 2024

Follow-Ups

  • Re: Mounting location of part upon production
    Hi Tom,
    You should be able to have each of the items (specified legs) be on one BOM and when the Manufacturing order is created, you select the serial numbers being used on those individual line items.

    I might need to build up a test case to be able to show you, and I should check to see what modules I have running that are beyond standard to enable that.

    I would be happy to connect directly.  If I build a test case I could likely share a video or some images.
    I should add, perhaps I am wrong,  but this seems pretty doable.  If not doable, it should be.

    Landis

    Landis Arnold
    Nomadic Inc.
    Niwot, CO USA

    larnold@nomadic.net



    From: "Tom Blauwendraat" <notifications@odoo-community.org>
    To: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
    Sent: Friday, February 16, 2024 7:31:46 AM
    Subject: Re: Mounting location of part upon production

    On 2/16/24 15:17, Landis Arnold wrote:
    
    
    >
    
    
    > One way to accomplish some of this is to simply use "structured 
    
    
    > serialization".
    
    
    > If you were to apply  to your Chair use case, you might do the following:
    
    
    >
    
    
    > 200 Legs become 200 serialized items.
    
    
    > In your BOM you would apply a Top Down with Chair, Leg position 1, 2, 
    
    
    > 3 and 4, Other components
    
    
    > Focusing on the Leg Positions:  Basically a BOM for each would allow 
    
    
    > the Serialized Legs to be used for their source.
    
    
    > You would Select a Serial Number for each in the BOM positions for 
    
    
    > each (leg1, leg2, leg3, leg4)
    
    Hi Landis,
    
    this sounds exactly like what I need, but I'm not sure that I follow - 
    if you say you need a "bom for each", then you basically mean defining 
    each leg as a separate product, which you include in the main BoM; so 
    there's a production step in between where a leg becomes a leg1, and 
    then becomes part of the table. Am I right? Or are you talking about 
    some other kind of serialization, that I don't yet know about?
    
    

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



    by Landis Arnold - 06:51 - 16 Feb 2024
  • Re: Mounting location of part upon production
    On 2/16/24 15:17, Landis Arnold wrote:
    
    >
    
    > One way to accomplish some of this is to simply use "structured 
    
    > serialization".
    
    > If you were to apply  to your Chair use case, you might do the following:
    
    >
    
    > 200 Legs become 200 serialized items.
    
    > In your BOM you would apply a Top Down with Chair, Leg position 1, 2, 
    
    > 3 and 4, Other components
    
    > Focusing on the Leg Positions:  Basically a BOM for each would allow 
    
    > the Serialized Legs to be used for their source.
    
    > You would Select a Serial Number for each in the BOM positions for 
    
    > each (leg1, leg2, leg3, leg4)
    
    Hi Landis,
    
    this sounds exactly like what I need, but I'm not sure that I follow - 
    if you say you need a "bom for each", then you basically mean defining 
    each leg as a separate product, which you include in the main BoM; so 
    there's a production step in between where a leg becomes a leg1, and 
    then becomes part of the table. Am I right? Or are you talking about 
    some other kind of serialization, that I don't yet know about?
    
    

    by Tom Blauwendraat - 03:30 - 16 Feb 2024
  • Re: Mounting location of part upon production
    Perhaps related to your request Tom,
    I have worked through something "similar" to this recently.  My use case involved "halves" of a paddle tracked by incoming lots,  right and left side, weights and lengths, and quality.
    The objective of the process was to primarily match pairs, such that left and right side would be balanced,  we would know the combined maximum length of the two sides, and we would flush out any blemishes, and in fact also try to pair blemishes.

    I used Serialization of Incoming as well as BOM processes for this.
    In parallel I built a system in Filemaker which would allow quick sorting of weights/lengths etc.  That sorting allowed relatively simple processing of components into pairs.  Then at time of final build the pairs are combined to built paddle in specific length, twists and control hand specifications.
    Back in Odoo, the traceability report shows the full flow of components used in each paddle.  In the Inventory/Warehouse App, if you look at Serial Numbers. then unselect "product" in the filter/search box, you can then see all of the serial numbers and if used, where they have been used.  This would go "up or down" in terms of a flow from initial part, paired part, built part.

    -------

    But about your Chair and Chair Leg approach.

    One way to accomplish some of this is to simply use "structured serialization".  
    If you were to apply  to your Chair use case, you might do the following:

    200 Legs become 200 serialized items.
    In your BOM you would apply a Top Down with Chair, Leg position 1, 2, 3 and 4, Other components
    Focusing on the Leg Positions:  Basically a BOM for each would allow the Serialized Legs to be used for their source.
    You would Select a Serial Number for each in the BOM positions for each (leg1, leg2, leg3, leg4)  

    ----
    I have been doing this with Odoo 14  Community.    There could definitely be different/better reports for some of this, but if you look well enough, and jump to the correct app, most things are findable.

    I hope that some of this above may be helpful.

    Landis Arnold

    Nomadic Inc.
    Niwot, CO USA


    From: "Tom Blauwendraat" <notifications@odoo-community.org>
    To: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
    Sent: Tuesday, February 6, 2024 1:17:27 PM
    Subject: Re: Mounting location of part upon production

    That could indeed be a nice idea - based on where the leg is placed at the moment, we modify a field on the serial number indicating the position.
    That said, maybe it could then also be an extra field that we store the information on in stock.move or stock.quant table, to avoid write traffic on the lot table. Let me think about that some more.

    Thanks, Graeme!

    Therp - Open Source ERP solutions built on Odoo

    On 6 Feb 2024, at 12:22, Graeme Gellatly <notifications@odoo-community.org> wrote:

    Yes, but there is a second field on serials, I don't recall its name, but I use it a lot to store information and lot names are surprisingly accessible during manufacturing processes. I wouldn't discount the idea, it is a pretty simple workaround.

    On Tue, Feb 6, 2024 at 5:42 AM Tom Blauwendraat <notifications@odoo-community.org> wrote:
    On 2/5/24 16:02, Daniel Reis wrote:
    
    
    
    > Option 3 looks similar to Lot/Serial usage. What if you (ab)used Lot 
    
    
    
    > numbers for this?
    
    Good idea in theory, but in my case we're already using serial numbers 
    to track the parts
    
    

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: 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 Landis Arnold - 03:16 - 16 Feb 2024
  • Re: Mounting location of part upon production
    That could indeed be a nice idea - based on where the leg is placed at the moment, we modify a field on the serial number indicating the position.

    That said, maybe it could then also be an extra field that we store the information on in stock.move or stock.quant table, to avoid write traffic on the lot table. Let me think about that some more.

    Thanks, Graeme!

    Therp - Open Source ERP solutions built on Odoo

    On 6 Feb 2024, at 12:22, Graeme Gellatly <notifications@odoo-community.org> wrote:

    Yes, but there is a second field on serials, I don't recall its name, but I use it a lot to store information and lot names are surprisingly accessible during manufacturing processes. I wouldn't discount the idea, it is a pretty simple workaround.

    On Tue, Feb 6, 2024 at 5:42 AM Tom Blauwendraat <notifications@odoo-community.org> wrote:
    On 2/5/24 16:02, Daniel Reis wrote:
    
    
    > Option 3 looks similar to Lot/Serial usage. What if you (ab)used Lot 
    
    
    > numbers for this?
    
    Good idea in theory, but in my case we're already using serial numbers 
    to track the parts
    
    

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


    by Tom Blauwendraat - 09:16 - 6 Feb 2024
  • Re: Mounting location of part upon production
    Yes, but there is a second field on serials, I don't recall its name, but I use it a lot to store information and lot names are surprisingly accessible during manufacturing processes. I wouldn't discount the idea, it is a pretty simple workaround.

    On Tue, Feb 6, 2024 at 5:42 AM Tom Blauwendraat <notifications@odoo-community.org> wrote:
    On 2/5/24 16:02, Daniel Reis wrote:
    
    
    > Option 3 looks similar to Lot/Serial usage. What if you (ab)used Lot 
    
    
    > numbers for this?
    
    Good idea in theory, but in my case we're already using serial numbers 
    to track the parts
    
    

    _______________________________________________
    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" <graeme@moahub.nz> - 12:20 - 6 Feb 2024