Help

Inventory of kits that when added depletes inventory of each item needed

Topic Labels: Base design
349 3
cancel
Showing results for 
Search instead for 
Did you mean: 
filmpedler
4 - Data Explorer
4 - Data Explorer

I am looking at a way to deplete inventory of items when adding a kit to inventory. For example:

I have 1 kit that contains 2 A's 4 B's, and 1 C. SO when I add a kit to my inventory, it removes 2 A's, 4 B's, and 1 C. 

How would I make this work? Thank you for any help.

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

You're going to need a junction table where each record represents a single item linked to a single kit, and contains the quantity of the item in that kit

After that, it depends on how you're tracking your inventory, really.  Personally I favour having a "Movements" table where each record represents a single item, the quantity moved, direction (in or out) and linked to the item's record in an "Inventory" table, and then I use rollups to sum up the quantity

With that method, I have an automation that'll look for all the records in the junction table that are linked to the kit and create one record for each of them to the "Movements" table, which updates my "Inventory" count appropriately

filmpedler
4 - Data Explorer
4 - Data Explorer

Thanks, still not clear on the "Movement" table though.