Report for missing cost on BOM?

[chloe5763]

Hi there!

Is there a way to find any purchased items on a costed BOM that have a zero standard cost? When I do a simulated cost roll, I need to validate that all of it's lower level components have a cost. Short of viewing the indented BOM for each and every one, is there a report or a way to extract this from the databrowser?

Thanks! K

 

[peterban]

Hi,
you dont mention your platform, but if your on SQL then this should give you a starter for 10.

select ibmcu,IBLITM,COUNCS from F4102 left outer join F4105 on IBLITM=COLITM and IBMCU=COMCU
order by COUNCS

cheers

Peter