BOM report how to create

I would like to create a BOM report wherein when I get an order for a product, I can view in the report which products I need to order from the BOM.
Consequently when there is a sale and purchase the BOM quantities should get updated.
Can someone please help me

Have you checked the production planning? It won’t work automatically. You have to select the orders and system will show you how much raw materials required to purchase.