We need to generate BOM of assembly automatically. BOM should include dimensions, weight, material, part code, drawing number, pricelist. The price should be selected from the excel pricelist. e.g if we have steel plate in assembly then software should automatically pick steel plate price for excel list. Is it possible. Also we need to see size/dimension and weight of each component in BOM.
Currently the method we know is defining parameters individually for each part in Creo which is manual labor and time consuming. Can't we generate BOM automatically with all the required fields. Currently we cannot even generate weight in BOM.
I think the only chance how to get your specific BOM quickly and easily is to create user application with requested functionality. You can try to find a company, which is able to make such application for you.