Skip to main content

Hi guys,

Just trying to achieve the following. No luck so far.

It’s a way to reduce inventory numbers of products based on the available qty of the parts that make up that product. I’d like for this to be nested. So if we have a wheel that is made of tyre,tube,rim] and a bike that is made of 2 x wheel,1 frame etc], if we increase the qty of tyres, we will increase the qty of the wheels which will increase the quantity of the bikes buildable.eg.


Table 1. (Products)


Tyre

Tube

Rim

Wheel

Frame

Seat

Handlebars

Bike


Table 2 (Bill of Materials)

Wheel - 1 x tire, 1 x tube, 1 x rim.

Bike - 2 x wheels, 1 x frame etc.


I can get it to work with one level of BOM. So if I had it as

Bike = 2 x tires, 2 x tubes, 2 x rims, 1 x frame etc it works well.


I’ve tried countless things to try have it work with nesting but I haven’t solved it yet.

Any tips of the method to use would be great.


Obviously, it has to have the formula of MIN(values) as we can only build a bike if ALL the components are available.


Any help much appreciated.

Thanks

Jason


Hi @Jason_Ure,


Welcome to Airtable Community! :grinning_face_with_big_eyes:


I think you need a 3rd table called Buildable, in this table you use the Rollup function with the argument Min() to check what is the minimum number you can build.


Alternatively, you can use the Group By option and in the summary field choose the Min value.


If this helps you, please mark the answer as Solution so others can benefit from it 🙂


BR,

Mo

A nested BOM (Bill of Materials) enhances inventory tracking by detailing the hierarchical structure of components and subcomponents.  wheel alignment shops in kakkanad  This approach provides a clear view of all parts required for manufacturing, from high-level assemblies to individual items. Implementing a nested BOM helps streamline inventory management, ensures accurate stock levels, and improves overall efficiency in production and procurement processes.

Reply


Terms & Conditions