Then this sounds like something a fairly common problem discussed on multiple threads.
Unfortunately I have never heard of a way to do everything automatically. but I’d definitely like to be proven wrong on this.
Some links I could find…
and I remember another thread but could not find that one
It explored different ways to store/track the raw material. Unique part numbers/lots for “partials”… where the potential problem was ending up with a LOT of part/lot numbers to keep track of the raw material.