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 / Microsoft Dynamics AX (Archived) / BOM relations
Microsoft Dynamics AX (Archived)

BOM relations

(0) ShareShare
ReportReport
Posted on by Ganriver1 1,559

Hi Friends,

Looking at the BOM tree structure, how's tree built, in other words, how table records are linked together?

I am trying to retrieve records for all BOM items, child items.

Many thanks!

*This post is locked for comments

I have the same question (0)
  • Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: BOM relations

    Hi,

    Could you let us know the form name are you referring to.Is it BOMDesigner or something else.

    Thanks,

    Chaitanya Golla

  • Ganriver1 Profile Picture
    Ganriver1 1,559 on at
    RE: BOM relations

    BOMDesigner, for 2009.

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,699 Moderator on at
    RE: BOM relations

    Here is a small overview of the BOM related tables:

    BOMTable table - a header of the BOM list. It contains a unique BOMId, that will be used by BOM lines to refer to the header.

    BOM table - lines of the BOM list. They are using BOMId of the BOMTable record to refer to the header.

    BOMVersion table - this table connects an item and a BOM (header). It allows to have many-to-many relations between an InventTable and BOMTable. It means that many items have the same BOM, and many BOMs can be assigned to the same item. However, only one BOMVersion record will be selected and its BOM Id is used on the order line during the order creation and this selection is based on the criteria specified on the BOMVersion record (e.g. order quantity, order date) and the respective data on the order line (sales or production). This table is not mandatory and actually maybe disabled in the configuration key. If it happens, then there will be always 1-to-1 relation between an item and a BOM and it won't be possible to setup automatic selection based on criteria.

    These three tables are enough to build the entire BOM structure.

  • Ganriver1 Profile Picture
    Ganriver1 1,559 on at
    RE: BOM relations

    Thanks Sukrut, BOM could have many levels/layers, how's that handle between these 3 tables?

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,699 Moderator on at
    RE: BOM relations

    I don't have ax 2009 environment but I think there is table called BOMLevel

  • Ganriver1 Profile Picture
    Ganriver1 1,559 on at
    RE: BOM relations

    Sukrut,

    There is no table call BOMLevel, or similar.

    Thanks

  • Ganriver1 Profile Picture
    Ganriver1 1,559 on at
    RE: BOM relations

    Thanks a lot! Sukut, finally figured out, I have to use recursive query on BOM  and BOMVersion tables to retrieve the BOM tree structure

  • micano Profile Picture
    micano 60 on at
    RE: BOM relations

    Hi Ganriver,

    I'm very interested in the recursive query you implemented to build a BOM tree structure based on BOMTable, BOM, and BOMVersion.

    Would you kindly share this query with me?

    Thanks!

    MJC

  • Ganriver1 Profile Picture
    Ganriver1 1,559 on at
    RE: BOM relations

    MJC,

    Sorry,  I changed job, don't have the query anymore. But, it's not hard, you should be able to figure out.

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#3
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans