Skip to main content
Solved

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


I need to advise the sales team regarding the availability of materials in the multilevel BOMs (Capable to Promise (CTP) multi-level BoM), which may include both Manufacturing and purchasing items at various levels. Any ideas on how to create a GI or even generate a report showing the INSiteStatus.QtyAvail using AMMultiLevelBomData?

Best answer by jamesh

Pooya wrote:

 

jamesh wrote:

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.

@Pooya - I think what you’re looking for would be included in this feature request that’s shortlisted…  Hopefully we’ll get it soon! Essentially, it’ll be an inquiry to see if there’s going to be enough available inventory to build something, and how many….  Please go hear and vote it up ;) 

https://community.acumatica.com/ideas/can-i-build-it-inquiry-14172

Thanks,

James

View original
Did this topic help you find an answer to your question?

15 replies

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • 791 replies
  • October 30, 2023

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2679 replies
  • December 11, 2023

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


  • Author
  • Freshman I
  • 4 replies
  • December 13, 2023

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


lbarker
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • 75 replies
  • December 13, 2023

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


  • Author
  • Freshman I
  • 4 replies
  • January 12, 2024

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.


antoons60
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 23 replies
  • January 15, 2024

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2679 replies
  • January 15, 2024

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. 


Forum|alt.badge.img
  • Jr Varsity II
  • 39 replies
  • January 20, 2024
Pooya wrote:

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.

+1

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


lbarker
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • 75 replies
  • January 22, 2024
Pooya wrote:

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.

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


jeremyd45
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 212 replies
  • January 26, 2024

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.


jamesh
Semi-Pro I
Forum|alt.badge.img+7
  • Semi-Pro I
  • 172 replies
  • January 26, 2024

This might be able to get you started @Pooya 


  • Author
  • Freshman I
  • 4 replies
  • January 29, 2024

 

jamesh wrote:

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.


  • Author
  • Freshman I
  • 4 replies
  • January 29, 2024
jeremyd45 wrote:

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.

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.


jeremyd45
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 212 replies
  • January 29, 2024

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 


jamesh
Semi-Pro I
Forum|alt.badge.img+7
  • Semi-Pro I
  • 172 replies
  • Answer
  • February 8, 2024
Pooya wrote:

 

jamesh wrote:

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.

@Pooya - I think what you’re looking for would be included in this feature request that’s shortlisted…  Hopefully we’ll get it soon! Essentially, it’ll be an inquiry to see if there’s going to be enough available inventory to build something, and how many….  Please go hear and vote it up ;) 

https://community.acumatica.com/ideas/can-i-build-it-inquiry-14172

Thanks,

James


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings