Small and medium business | Business Central, N...

Part - BOM - Part availability by event report to confirm part availability

(1) Share

Report

Posted on by RM-12091124-0

Hi,

I am new to D365, so looking for some help / advice.

When we get a new order in for a part (ex. H126) which has a BOM containing items which we purchase. I am looking for a quick way to check all purchase parts in the BOM, to see if there is enough stock available to produce the quantities of the H126

Is there a report that you can use to check each part under the BOM, looking at each part by EVENT based on stock and other item demands in the system, if there is enough stock to make the parts for the designated dates in the system.

Top Part -> BOM -> Purchase Parts -> Item - By Event -> [Is stock available?]

Thanks

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 92,429 Super User 2025 Season 2 on at

Like (1)

Report

Part - BOM - Part availability by event report to confirm part availability

Hi, The method mentioned by Valentin is fastest.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 29,517 Super User 2025 Season 2 on at

Like (2)

Report

Part - BOM - Part availability by event report to confirm part availability

You can also try the Item Availability by BOM Level which you can open from the top part. This page will tell you how many units of the top part you can make and which components are the bottleneck.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,182 Super User 2025 Season 2 on at

Like (0)

Report

Part - BOM - Part availability by event report to confirm part availability

agree with ben's suggestions for this question. To run planning worksheet, the parameters need to be set up properly.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 23,574 Most Valuable Professional on at

Like (1)

Report

Part - BOM - Part availability by event report to confirm part availability

Hi

To add some interesting links.

The Requisition Worksheet and Planning Worksheet uses the same engine and performs the same job - Dynamics 365 Business Central (usedynamics.com)

How to perform Shortage control and to print Shortage lists - Dynamics 365 Business Central (usedynamics.com)

Production Reports and Analytics - Business Central | Microsoft Learn

About Planning Functionality - Business Central | Microsoft Learn

Best

GR

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,370 Super User 2025 Season 2 on at

Like (2)

Report

Part - BOM - Part availability by event report to confirm part availability

The two out-of-the-box solutions are creating the Production Order and running the BOM Shortage Report (paper based) or using the Planning Worksheet to get the suggestions on what to make/purchase.

The Planning Worksheet is the proactive approach, it uses the demand date of the Sales Order to create the Production Order (suggestion) which triggers the demand for its BOM and suggests purchases for any BOM components that are missing or meet specific planning parameters. The concept is to run the Planning Worksheet run daily or at least a couple times per week.

The BOM Shortage report is a reactive approach, where you create a Prod. Order and then look to see what is missing. Then you either manually make your Purchase Orders or run the Planning Worksheet to generate those orders.

You can also go the customization route and add some fields to your BOM which calculate the Material Availability, make them turn red if they are short or can't hit the need date based on lead times, etc.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No