Keeping track of your inventory in 4 steps.
Hoe have list of components used in your products and you sell a product, this has an impact on your component inventory. Below how this works.
Below the tables we generated and which show the basic principles of any inventory management system you would like to set up in
The table sales tells how many of each products got sold. The volume is a text field and can be filled-out manually or via a button or even an automation.
The Bill Of Materials (BOM) shows per products the components and we link these components to the stock we have.
The calculation
We follow a few not too difficult steps, starting with relating the volume of products sold to the components, thus the BOM table. It is simple filter and in case the sales does not cover all products (like our product 3 in this example) we go with a zero via IfBlank(). To turn it into a negative number we simply multiply by -1. It is an easy and often applied trick to make your summation work.
