Skip to content
Product Configurator app iconProduct ConfiguratorConfigure

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

  1. A salesperson configuring a product opens an option's choice lookup in the BOM Designer.
  2. The lookup lists the choices that rules allow, with on-hand inventory for item choices.
  3. The salesperson picks a choice, taking availability into account.
  4. 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.

Product Configurator app icon

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.

Ask a product question

Product Questions