I'm in the same industry and need the same solution, but take a slightly different perspective. I would call r15k5p our own part number, and manage a 1:many relationship to a manufacturer part number specified by the designer (e.g. a Panasonic part number), and another 1:many relationship to a vendor part number for purchasing (e.g. Digi-key's part number for the Panasonic part).
This is standard practise in electronics product manufacturing, but everyone else seems to only care about the purchased part number. I would much rather use or adapt an existing module, but if one isn't available I would be very interested in helping to develop one. --- Dale dalescott.net - Transparency with Trust Oct 10, 2013 03:37:11 PM, [email protected] wrote: Hello All, > > Wondering if someone has come up with this solution via a module already. > Company I work for is a manufacture of electronic products. Our stock is comprised of hundreds of electronic components. Over the yrs some of them become obsolete but we still need to keep > the components as a stock-able item but we have newer components that are alternates that are linked back to the original component number. Some of the products we make here go back almost 20 yrs and those part-lists still reference the original part. To prevent us from having to update a old parts list(20 yrs old) we maintain those > older part numbers and our current system, that I'm working to replace, we can look up the replacement for it. The current system is just a mess, and I'm not putting that lightly, I wasn't the one who developed it :). > > So we are now at a stage that we need to start almost from the beginning. We also deal with lots, in the sense that if a package of resistors is received by us today we, mark it with today's date as a lot number. r1k5p (original 20 yr old part number) > |___ Digi1k (alt part) > | |______ Lot 09012013 (10 pieces in inventory) > |___ Mouser1k (alt part) > |______ Lot 06162013 (6 pieces in inventory) > When I'm building the parts list. I want to refer to the original part "r1k5p", If I create a MO for say 15 units (and say part - r1k5p is used once). It would create a picklist (BOM) > that would show up something like this: > r1k5p Total: 15 > |______ Lot 06162013 6 > |______ Lot 09012013 9 > (I have attached a screen show of this layout in-case the formatting messes up.) I know what I'm asking is very likely not been developed already, but no harm in asking. Or if it's even possible doing with some(or A LOT) of coding in OpenErp. > >_______________________________________________ >Mailing list: https://launchpad.net/~openerp-community >Post to : [email protected] >Unsubscribe : https://launchpad.net/~openerp-community >More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~openerp-community Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp
