Calculated Component Quantities for Microsoft Dynamics 365 Business Central
When a product is sold by size, its components change with it: a longer desk needs a longer top, more trim, and maybe an extra leg. A fixed quantity per bill of materials (BOM) line cannot follow the size, so someone recalculates by hand. Product Configurator calculates component quantities from option values with formulas, such as a length plus an allowance.
The calculated quantity goes onto the configured item's BOM, so the build and the cost match the size ordered.
How Calculated component quantities works in Product Configurator
- A product manager sets up an option that captures a value, such as length.
- On each dependent choice, the product manager enters a Child Qty. Calculation Formula that uses that value.
- A salesperson enters the length and picks choices in the BOM Designer.
- Product Configurator calculates each component quantity from the formulas.
- The configured item's BOM carries the calculated quantities.
Key capabilities
Child quantity formulas
Each option choice can carry a Child Qty. Calculation Formula that works out the component quantity from option values. A documented example is Length * 1.1, which covers a waste and trim allowance.
Minimums and rounding
Formulas can use functions, such as max(3; length/2) to set a minimum of three, using the same formula language as rules and run times.
Scrap kept separate
Scrap is handled by a Scrap % on item choices, so the formula can stay focused on the quantity the design needs.
Limits on quantities
Choices can have minimum and maximum quantity settings, so an entered or calculated quantity stays within what the product allows.
Values from the parent
In a sub-configuration, a child formula can reach a parent value with a Parent prefix, as in ParentLength * 1.1.
Instant feedback
When the salesperson enters a value, dependent quantities are calculated as the configuration is made. In the demo desk, choosing a trim fills in a quantity of 19 from a length-driven formula.
See Calculated component quantities on screen
Real screens from Product Configurator, shown with demo data.
Details that matter on the floor
Size-driven products without size-specific BOMs
One configuration covers every length or width the product is sold in, because quantities follow the dimension instead of being fixed per item.
Allowances written once
Waste and trim allowances are part of the formula, so every order includes them without anyone adding them by hand.
Who uses Calculated component quantities
Manufacturing engineers
Write quantity formulas that reflect how material is actually used.
Product managers
Offer products in any size the business sells without maintaining a BOM per size.
Purchasing managers
Buy against BOM quantities that reflect the configured dimensions.
Questions about Calculated component quantities
Can BOM quantities change with the size a customer orders?
Yes. In Product Configurator, each choice can have a Child Qty. Calculation Formula that calculates its quantity from option values such as length.
Can I add a waste allowance to a component quantity?
Yes. Include it in the formula, for example Length * 1.1. Scrap can also be set separately with a Scrap % on item choices.
Can a formula set a minimum quantity?
Yes. Use functions such as max(), for example max(3; length/2). Choices can also have minimum and maximum quantity settings.
Which functions can formulas use?
Product Configurator uses a formula language with a documented function library, including rounding, minimum and maximum, powers, and conditional logic.
Related Product Configurator features
All Product Configurator features →Part of Product Configurator
Simplify creating BOMs and routing to make quote and order generation more efficient.
Have a question about Calculated component quantities?
Send us a note and the Product Configurator team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
