Skip to main content
Solved

BOM Total Cost

  • 22 September 2021
  • 4 replies
  • 381 views

xkylewrightx
Semi-Pro I
Forum|alt.badge.img

Hi,

Wondering if anyone knows how I can access the fields that contain the cost data of a BOM?

I would like to access the fields inside the BOM Cost Summary popup, either via a generic inquiry, API endpoint, or even just a BQL statement, to use elsewhere

Any help is much appreciated!!

Best answer by kristianharianja

Hi @xkylewrightx,

It actually runs Cost Roll process below. I suggest to just run this and export to excel if you like. You will get the most updated cost of goods that you included in the process with several options to whether include fixed cost or not etc like you see below.

 

 

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

4 replies

Forum|alt.badge.img+3
  • Acumatica Employee
  • 98 replies
  • September 23, 2021

@xkylewrightx, the fields that are displayed in the BOM Cost Summary popup are part of the Data Access Class (DAC) AMBomCost and can be accessed via generic inquiry. 

A quick way to find out information about a field is to use the Element Inspector. This will let you view the following reference information for any visual element on a form:

  • Control type
  • Data access class (if applied)
  • Data field (if applied)
  • Data view (if applied)
  • Business logic controller
  • Action name (if applied)

You can activate the Element Inspector from the Customization Menu or by pressing Control-Alt which is useful for pop-up/smart panel screens.

Hopefully this information helps! Please feel free to reach out with any more questions! 

 


kristianharianja
Semi-Pro I
Forum|alt.badge.img+3

Hi @xkylewrightx,

It actually runs Cost Roll process below. I suggest to just run this and export to excel if you like. You will get the most updated cost of goods that you included in the process with several options to whether include fixed cost or not etc like you see below.

 

 


xkylewrightx
Semi-Pro I
Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 77 replies
  • September 23, 2021

@kristianharianja 

Thank you Kristian, this is the piece I was missing. 

 

@andrestamour43

I really appreciate your response as well. I had gotten that far by referencing the DAC as you stated, but was not running Cost Roll so the fields were never being updated.

 

I am now able to successfully use the Cost Roll API endpoint to perform the Roll Costs action, then $expand=Results and get that cost. 


Forum|alt.badge.img+3
  • Varsity I
  • 205 replies
  • September 28, 2021

If you archive the cost roll results you can access the data via a GI/RD - AMBOMCostHistory


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