On-Hand Inventory in Option Lookups for Microsoft Dynamics 365 Business Central
A salesperson can promise a configuration with a component that is out of stock, and nobody finds out until production plans the order. Product Configurator shows on-hand item inventory directly in option choice lookups, so the person configuring sees what is actually available while choosing.
The salesperson can pick a choice that is in stock, or set expectations with the customer before the order is confirmed.
How On-hand inventory in option lookups works in Product Configurator
- A salesperson configuring a product opens an option's choice lookup in the BOM Designer.
- The lookup lists the choices that rules allow, with on-hand inventory for item choices.
- The salesperson picks a choice, taking availability into account.
- The configuration continues with the next option.
Key capabilities
Inventory in the lookup
When the salesperson opens the list of choices for an option, item choices show their on-hand inventory alongside the choice, so availability is part of the decision.
Fewer surprises downstream
Choosing an in-stock component at quote time reduces the orders that planners later find blocked by a component nobody has.
Only relevant choices
Rules can hide or show option choices in the lookup based on the configuration so far, so the list shows choices that fit. See configurable interface rules.
Sorted the way you set it
Option choices and choice set choices can be reordered in the lookup to match the page's current sort order.
Quicker lookups
Option choice lookups load faster, which matters for options with long choice lists.
Details that matter on the floor
Availability at the point of promise
The salesperson sees stock while still talking to the customer, which is the moment an alternative is easiest to offer.
Who uses On-hand inventory in option lookups
Sales representatives
Choose components with stock in mind before promising a configuration.
Supply chain managers
Reduce orders configured around components that are not on hand.
Questions about On-hand inventory in option lookups
Can I see stock levels while choosing options in Product Configurator?
Yes. Option choice lookups can display on-hand item inventory, so the person configuring sees what is available.
Does the lookup show every choice for an option?
Not necessarily. Rules can hide or show choices in the lookup based on earlier selections, so the list can be limited to choices that fit the configuration.
Does Product Configurator reserve the stock I see?
The sources describe on-hand visibility only. Reservation and availability on the sales order follow standard Business Central behavior; ask your Microsoft Partner how that fits your process.
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 On-hand inventory in option lookups?
Send us a note and the Product Configurator team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.