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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Exploding BOM to its lowest level

(1) ShareShare
ReportReport
Posted on by 4
Hi, 
 
I am working on a report that needs a BOM to be exploded for each Item No/Variant Code. 
I am looking for any base code/function which would explode the bom to its lowest level. 
 
If you know about a sample base code that does this, I can refer to that and develop the report. 
 
Thanks in advance.
Jp
I have the same question (0)
  • Suggested answer
    Shauna Langley Profile Picture
    899 Moderator on at
    Hi,
     
    Would the Quantity Explosion of BOM report give you what you need?  The output will display as follows:
     
    The level shows that it is multi level.  SP-BOM2000 has a BOM itself which is why those are labelled as level 2.
     
    Hope that helps,
    Shauna
  • Ben Baxter Profile Picture
    6,827 Super User 2026 Season 1 on at
    If you want to see the information on screen, use the "Structure" page to view a treeview of the BOM and Routing of each level in a build.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,055 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans