Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
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 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

  • Verified answer
    DPerko Profile Picture
    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
    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
    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
    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

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans