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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to generate BOM ca...
Microsoft Dynamics AX (Archived)

How to generate BOM calculation report with all BOM levels?

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Everyone,

I generated a BOM calculation report for some selected items.  I could see all BOM levels (all sub levels) in the report for some items and only levels 0 and 1 for some items(although levels 2, 3 exists for the item). I also looked into BOMCalcTrans table and it has the same entries as the report.

When i googled related to this problems, i found few links https://community.dynamics.com/ax/f/33/t/45041 , http://objectmix.com/axapta/793317-bom-calculation-ax2009.html i followed that but no luck. I also did a BOM calculation for an item multiple times, but the report shows only levels 0 and 1 for some items. Is there any configuration involved to restrict BOM levels to a certain limit or and additional steps involved to get all BOM levels in a report?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    In addition to that, i also noted that for a Multi level BOM, some level 1 BOM's sub items are written in the report and the for some level 1 BOM's sub items are not written in the report. What is causing this? Why some multi level BOM's are generated correctly and why some are not?

    Any knowledge sharing would be greatly appreciated. Thanks in advance.

  • manikumar Profile Picture
    manikumar 1,623 on at

    public void processReport()

    {

       QueryRun        queryRun;

       BOMVersion      bomVersion;

       BOM             bom;

       Query           query;

       query = this.parmQuery();

       queryRun    = new QueryRun(query);

       ttsbegin;

       while (queryRun.next())

       {

           insertMain = true;

           salesTable = queryRun.get(tableNum(SalesTable));

           salesLine = queryRun.get(tableNum(SalesLine));

           inventTable = InventTable::find(salesLine.ItemId);

           select * from bomVersion

               where bomVersion.ItemId == salesLine.ItemId;

           {

               while select bom

                   where bom.BOMId ==  bomVersion.BOMId

               {

                   insertMain = true;

                   this.bomChild(bom);

                   if(insertMain)

                       this.insertTmp(bom, NoYes::No);

               }

           }

       }

       ttsCommit;

    }

    this is what i have written. it may help you

  • Community Member Profile Picture
    Community Member on at

    Thanks for your reply Manikumar. But i wanted to know the reason why for some items all BOM levels are shown and for some it doesn't.

  • manikumar Profile Picture
    manikumar 1,623 on at

    Nope, i did not faced this issue, but i faced some thing else and i don't remember now

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    I found the solution. In my case, the BOM calculation group for each item makes the difference. Each item belongs to different BOM calculation group. In Calculation group level, there is a Stop Explosion checkbox. If that is checked in, the BOM calculation will not  perform for further items in that BOM. If that is not checked in, then BOM calculation will perform for all further levels.

    BOM calculation group form is located in -> Inventory Management -> Setup -> Bill of materials -> Calculation group -> select your calculation group -> setup tab -> Stop explosion. That's it. Then the system will handle all BOm calculations.

  • manikumar Profile Picture
    manikumar 1,623 on at

    i was talking about 2012 r2, not 2009. now i have checked your tags

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans