Overview over on Hand inventory for Bill of Material- Components

(2) Share

Report

Posted on by simonschulte

109

Hey Guys,

my customer is a fast paced retail company. They have items, wich they are selling, that have to be assambled first. (Assambly is not a big deal and done within a few hours) Therefore there are Bill of materials. When Items, wich have to be assambled, are put in a sales order, they need to see the on-hand inventory of the components of this item as fast as possible. Is there any way, you can look for the availability of the components of the BOM right from the sales order, without having to filter the on hand list to maybe 4 Items?

Thank you for your help.

Kind regards

Simon

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

CA Neeraj Kumar 1,859 on at

Like (0)

Report

Overview over on Hand inventory for Bill of Material- Components

Hi @simonschulte,

You can achieve this using below steps:

1) Create a sales order.

2) Click on Add Lines button.

3) Click on Filter > Advanced Filter or sort

4) You need to add joins below InventTable (items) > BOM > BOMTable > BOMVersion

5) Some ideas on how to add the table

a) Select Items , Click on Add table Join

b) Click on Show details, Filter with word "BOM" in last column, Select the BOM Lines, and click on button "Select".

c) This will add BOM table below the InventTable,

d) Similarly add more tables ...

6) Then give the filter for Main Item for which you want to see the components:

7) Save this query at the top: For the next time

8) Click Ok button. You will get list of those items which are part of BOM lines along with the inventory dimensions let say Site 1, Site 2. Here you can use display dimensions option to validate at site/warehouse/batch/size/color .. and filter for particular site as well.

Next time, you need not to add these joins again, just go to filter, select your query "BOM_Lines_Details_OnHand". Then give the item id for which you want to see the BOM Line items On-hand.

You can validate from the BOM versions: Only these items are used above.. also you can play around the filter option for more accurate filteration.

Hope this answers your question. In case of any further queries, please let me know.

If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified

Regards,

Neeraj Kumar

Was this reply helpful? Yes No
CA Vijay Krishna 99 on at

Like (1)

Report
Overview over on Hand inventory for Bill of Material- Components

Yes — you can surface BOM component availability directly from the sales order line in D365, without manually jumping back and forth to the on-hand list. It’s not “out-of-the-box” in the same way as standard on-hand inquiries, but there are a few standard features and some common extensions that retail/assembly clients use for exactly this scenario.

Standard Options

1. Explosion / On-hand inquiry

Go to Sales and marketing > Sales orders > All sales orders.

Open your order → line for the BOM item → click Product and supply > Explosion.

This shows the full breakdown of components with pegging, availability, and shortage highlights.

From here you can also navigate to the on-hand for each component with a single click.

Pro: No customization needed, immediate visibility.

Con: It’s a pop-up, so you don’t see all shortages “inline” with the sales order unless you drill down.

2. Available to promise (ATP) with BOM check

ATP runs for the sales order line but can also consider BOM explosion.

Navigate to the sales order line → Product and supply > Available to promise.

With proper coverage settings, ATP can calculate if enough sub-components exist and show earliest possible ship date.

Pro: Aligns with MRP and delivery date promises.

Con: Retail “same-day assembly” cases may find it heavy compared to a quick stock check.

Was this reply helpful? Yes No