web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Using system table con...
Supply chain | Supply Chain Management, Commerce
Answered

Using system table constraints to populate a Product Configuration Model BOM line

(0) ShareShare
ReportReport
Posted on by DPerko 417

I am in the process of building out a product configuration model and am looking for a way to add a BOM line (using constraints or calculations?) by retrieving an InventTable record based on a look up of another InventTable field. I have found no way of doing this using a system OR user defined table constraint. 

Does anyone have any experience or documentation on achieving this setup? I was able to do it in the old Product Builder but have not found a way to do it in the Product Configurator.

Thanks

Dan

I have the same question (0)
  • Verified answer
    DPerko Profile Picture
    DPerko 417 on at
    RE: Using system table constraints to populate a Product Configuration Model BOM line

    The trick to fixing this was to add a new field to the InventTable and then create a table constraint with the ItemId and the new field.

    I then created a new attribute to link the variable the user is entering to the new InventTable field. The item number is then mapped to an attribute that I am using as the BOM Item.

    It is a little convoluted but it works.

  • tabarret Profile Picture
    tabarret on at
    RE: Using system table constraints to populate a Product Configuration Model BOM line

    Thanks, Dan.  When you have a few minutes, would you be willing to share your solution for the community?

  • DPerko Profile Picture
    DPerko 417 on at
    RE: Using system table constraints to populate a Product Configuration Model BOM line

    Taylor -

    These links don't go into enough detail to provide the answer.

    I did stumble across what I needed to do in order to get my issue resolved.

    Thanks

    Dan

  • tabarret Profile Picture
    tabarret on at
    RE: Using system table constraints to populate a Product Configuration Model BOM line

    Hello DPerko,

    Can you refer to the documentation below, and let me know if it helps you to get this resolved?  Both docs have steps for adding BOM lines, but I'm not sure if it aligns to your need of using constraints or calculations.  

    docs.microsoft.com/.../set-up-maintain-product-configuration-model

    docs.microsoft.com/.../maintain-bom-product-configuration-model

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,020

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans