Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Stock control based on BOM and amount produced

Topic Labels: Automations
159 1
cancel
Showing results for 
Search instead for 
Did you mean: 
PedroFernandes
4 - Data Explorer
4 - Data Explorer

I have a BOM for each model we produce in our factory. I want to develope a database that allows us to control de actual stock we have based on the quatity and model of our production. 

Is it possible to do so without using a script and by introducing only a forms with the quantity and the model procuded? 

Just to understand my problem, each model uses at least 30 different components, with different quantities.

Thank you

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

Yeap, you'd have these tables:
1. Models
2. BOM
3. Inventory
4. Production Log
5. Movement


For example, if you have Model 1 and it needs 2 of Part A and 3 of Part B:

Screenshot 2024-09-23 at 9.53.03 PM.png


Then Inventory will contain two records: Part A and Part B
Screenshot 2024-09-23 at 9.53.15 PM.png
And "Bom Recipes" will contain two records:

Screenshot 2024-09-23 at 9.53.12 PM.png

Link to base

You'd then use the "Production Log" table to key in the number of each model you're producing, and then the "Movements" table that's linked to the "Inventory" table helps you do the math of "Number of models produced" multipled by quantity of that part required

To populate the "Movements" table you'd use an automation that'd trigger when a "Production Log" record is created, and its action would be to loop through the BOM for the model and create one record each with the quantity of the model produced.  This would allow you to use a rollup field to sum up the current stock levels of each part in "Inventory"