We are working with bundle items, where each bundle is made up of multiple subcomponents defined using a Bill of Materials (BOM). We are looking for an out-of-the-box way (or minimally customized approach) to calculate and display the on-hand quantity for the bundle item, based on the available inventory of all its BOM components.
Use Case:
We want to:
Dynamically determine how many units of a bundle item can be assembled based on current on-hand inventory of its subcomponents.
Use this calculated bundle quantity to display available stock on retail sites or e-commerce platforms
Example Scenario:
Bundle Item: XXXX
BOM Configuration:
BOM Line 1: Item YYYY – Required Qty: 1 – On-hand Qty: 50
BOM Line 2: Item ZZZZ – Required Qty: 1 – On-hand Qty: 50
In this case, we want the system to show that bundle item XXXX has 50 units available, as both components are available in sufficient quantity to assemble 50 bundles.
Thank you
