Hello everyone,
We had an existing Excel sheet for a product where 3 batch sizes were maintained in separate columns, and the required quantity of each raw material was calculated by formula for each batch size.
We converted this structure into ERPNext by creating separate BOMs for each batch.
As a result, what used to be 33 BOMs has now become around 300 BOMs, and whenever the formulation changes, the team has to manually update all related BOMs.
What I need is a better way to keep all product BOMs in one place/page and avoid maintaining so many separate BOMs.
Is there a recommended approach in ERPNext for this scenario?
For example:
-
one master BOM with batch-size-based formula rows
-
a separate matrix or mapping table for quantities by batch size
-
or another standard design pattern to manage this cleanly
Any suggestions or best practices would be greatly appreciated.
