Solved

BOM Total Cost

  • 22 September 2021
  • 4 replies
  • 316 views

Userlevel 5
Badge

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!!

icon

Best answer by kristianharianja 23 September 2021, 06:10

View original

4 replies

Userlevel 5
Badge +1

@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! 

 

Userlevel 5
Badge +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.

 

 

Userlevel 5
Badge

@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. 

Userlevel 5
Badge +2

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved