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...
Unanswered

Item Availability by BOM level - repeat lines are not calculated

(0) ShareShare
ReportReport
Posted on by 350

Hi there, I have a problem with the availability overview: availability BOM level

we have repeat lines in our BOM Structure, and those are not calculated in this report:

Results:

ItemNo Available top item Parte per top item Available Qty
TOP Item 1
  sub-assembly 1 50 1
    item 1 50 2 100
  sub-assembly 2 (blank) 1
   item 1 (blank) 2 (blank)

I would expect something like this:

ItemNo Available top item Parte per top item Available Qty
TOP Item 25 1
  sub-assembly 1 25 1
    item 1 25 2 100
  sub-assembly 2 25 1
   item 1 25 2 100

the problem is: how do i differentiate in this view:

  • Blank cells: is the part missing (0 available)
  • Blank cells: is it a subcomponent of a sub-assembly, but we have actually enough of the assembly already...
  • Blank cells: is it the case of a duplicate line



    and related to the Report:
    if i have multiple missing parts, th ereport shows only one of those parts as a bottleneck. Is there a way to actually mark all "blocking Parts" as bottlenecks, in this report?
  • Robert Jolliffe Profile Picture
    890 on at

    You are trying to do planning from an information report from the look of it - and really you should be looking at Requisition Worksheet or Planning Worksheet to help you with planning.

    You could write a custom report to get you the view you want, which is also (I am guessing) so that you can check if you have enough of an Item so that you can produce the Top Item?

  • benovic Profile Picture
    350 on at

    You are guessing right. We are using the planning worksheets, but this always takes into consideration all current products.

    We'd ideally like to take look at the Item+BOM and determine how many units we can build, and what we'd have to purchase to build more.

  • Jason Nicolaou @ Sikich Profile Picture
    120 on at

    The planning worksheet drills down into the BOM levels and so does the Item Availability by BOM Level (Item Card > Related > Availability > Item Availability by > BOM Level).  You might be able to use these pieces to build exactly what you are after.  If you strike out there, I would look into advanced planning ISV options like StockIQ or Demandworks.  They add all kinds of logic AND different views to accommodate requests like yours.  

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans