I need to set the base up to reduce the SUPPLY inventory when I sell a Jewelry inventory item, so that I can keep track of when to reorder supplies. I guess for now I’m thinking I need to create some kind of rollup formula field in the supply inventory from USAGE that reduces inventory. But I don’t know if this is possible with multiple supply items that compose the jewelry item.
Maybe I need to go about it differently but I can’t work it out.
If I need to provide more information please let me know!!