@Jeff_Owens Simple kind of depends on how deep your boms are. We are 99% single level with a handful of 2nd level so I was able to go PartRev - PartMtl - PartCost and add a getlist routine to check if the MtlPartNum was a PartMtl.PartNum and add them in. If you are multilevel it gets harder,
I think that is standard does not get updated without a rollup, but average is for all transactions that go thru Inventory. If you purchased direct I am not sure average gets updated. I assume last would always
This has examples of getting to all levels of a bom.