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
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, 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!
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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.