Skip to main content
Solved

Is there a way that I can create a generic Inquiry to estimate of how many of a particular sub-assembly can be made from the on-hand materials?

  • January 23, 2023
  • 5 replies
  • 187 views

This is what I’ve been able to build but I want to make section that gives me a final number of how many I can build. Not have it show me what the lowest number in stock that I have. I want to see a section that says I can only build 6.

 

Best answer by lauraj46

Hi @garcimig09 ,

To return the minimum value per BOM ID, you should group on the BOM ID and top level assembly fields on the Grouping tab.  Then specify MIN as the Aggregate Function on the “Qty Capable to Build” formula field.  You may need to add the Aggregate Function with the column selector if it’s not showing in the Results Grid of the GI builder.

Depending on your requirements, the Report Designer could also be an option to accomplish this.  

 

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

5 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 568 replies
  • Answer
  • January 23, 2023

Hi @garcimig09 ,

To return the minimum value per BOM ID, you should group on the BOM ID and top level assembly fields on the Grouping tab.  Then specify MIN as the Aggregate Function on the “Qty Capable to Build” formula field.  You may need to add the Aggregate Function with the column selector if it’s not showing in the Results Grid of the GI builder.

Depending on your requirements, the Report Designer could also be an option to accomplish this.  

 


nathantrauscht
Semi-Pro II
Forum|alt.badge.img

@garcimig09 out of curiosity, did you figure this GI out? This would be a helpful GI for us as well for planning stock production orders.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2750 replies
  • March 28, 2023

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


Forum|alt.badge.img
  • Jr Varsity II
  • 33 replies
  • January 26, 2025

@garcimig09 our scheduling department would be very interested in this. where you able to get it to work?


  • Freshman I
  • 1 reply
  • January 29, 2025

@garcimig09 where you able to have this figured out this would extremely helpful for us too 


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