Hello all. Not sure if this is the best channel for this question. Please let me know if it is not. We use Work Orders to build assemblies. I wanted to know if there is a native column field that shows the quantity needed for 1 build. e.g. If the Assembly X requires 2 components (3 of Component A and 4 of Component B), the quantity you are going to build of assembly x gets multiplied by the component quantity. So to build 12 of Assembly X, we get 12*3=36 (Component A) and 12*4=48 (Component B). What the users want to see is a column that is not dynamic, and will always display the quantity required to build 1 of Assembly X. Do I need to create a formula field to store this on the line or is there a native field? In example below, Quantity of Assembly is 20. So component quantity is 20*10=200. Native field to show the quantity 10.

if you are not looking to do any scripting, you could use a workflow to store the "quantity of assembly" at the line level with a sublist group and a Workflow defined field

Hi @daniel_w Thank you for the suggestion. Wanted to see if there was a native field before I added a custom field with a formula. Thank you.

Not that I am aware of. I did the above solution for a scenario with "fixed" components in a BOM, worked well for what I needed at the time

@daniel_w All of your suggestion would do the trick. I think I'll spin the wheel and give one of them a go. Thanks for your input! Much appreciated!!