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!!
jewelry inventory|700x134
![usage usage](/t5/image/serverpage/image-id/5295i5A80EC08271AD5DD/image-size/large?v=v2&px=999)