I have an idea, and want to know the best approach using Odoo to do it. I am a solid python programmer, and also controls engineer. So I can manage hardware and software integration for this I believe.

I have 2 problems as a supply chain guy

- Assemblers are not trained properly and grab serialized inventory willy-nilly

- I don't have traceability as to what parts go into a machine

My thought is- I consign material to manufacturing, so that I know when they build a machine, exactly what serial # is in it.

Here's the thing - if I setup a barcode station, and ask the assemblers to do 2 things:

- Scan the id of the machine they are working on

- scan / enter the serial # of the part they are using

And then could I query my manufacturing orders table in Odoo - and check against the MO assigned to this machine, and verify that the serial # that I originally consigned to them, is the one they should use.

Otherwise - I flag and tell them "serial # not assigned to this machine"

Does this make sense, and is there a way in Odoo I would better perform this integration instead? I  can do it all in python I think, but I would much prefer an out of box solution instead...