How to check Items availability(CTP) for a multilevel BOM

@jeremyd45 - do you have a GI that addresses this request?

Hi @Pooya were you able to find a solution? Thank you!

Hi @Chris Hackett  not yet. I’m still using spreadsheet to do this complex calculation.

What about if you modify the report Multi Level Bom engineering so show stock levels? 

Hi, Multi Level BOM engineering  is a report and I cant access it through the GI because “PX.Objects.AM.AMMultiLevelBomData” is a Report In Memory DAC (Not an actual table). I would apricate it if you can share your idea on how to create Multi Level BOM as a GI.

HI

Why is this marked as solved? I don’t see a solution. 

Maybe in the report, place an icon with a weblink to Inventory Sry, for each item in Materials of the FInished Good BOM.

Thanks

Toon Six

HI @antoons60 questions will be marked with a best answer if the OP doesn't respond within a reasonable amount of time and a response may solve the issue. They can always be unmarked if the OP comes back to say it didn't work. 

+1

I would be REALLY nice if this basic functionality was exposed somewhere/somehow as a GI

Yeh the table only fills with data when you run the report, so a GI is difficult as a Parent BOM can have multiple children that can again have more children boms.  Hence why in the past I modified the report to show it here. 

It would be great if the Visual Bom screen could show Stock on hand / Stock available

Sorry, I missed that I was tagged here. We have created a few customizations and GI to pull the components and see the available items, but you have to do it at the item level. I am still trying to get a consolidated Critical Materials report that is exactly what I am looking for. 

Ideally there would be a report that would show you the critical materials for everything, and would help provide input into a decision about how to prioritize orders that have already been released.

This might be able to get you started @Pooya 

Hi @jamesh, 

Thanks for the GI. I aim to find the availabilities for the multi-level BOMs on one screen instead of running the GI for each level.

I generated this GI for a single level with the stock balance checker. It would be great if you could take a look and develop this for a multi-level calculator.

Thank you, Jeremy. But critical material report needs a production order. I'm trying to do an estimation of stock balance for a multi-level BOM in the sales quoting process.

Additionally, I recently found out that I can add a row in Forecast and then run MRP. However, it's affecting the MRP report and would only show the shortages, not the full availability for all items.

Yes. My comment was not very clear. You need to essentially look at a BOM and identify any shortages prior to releasing the Production order. There are a few ways to look at the multi levels deep, but in order to combine it to be a useable format you would need to do a sql query 

Did we get this function?  I am looking for this exactly.

This is now functioning in 25R1