raw material report

SUGGESTED

We sell a lot of products that have a lot of common assemblies so to capture WIP we have all our products made up of multiple levels deep assemblies.  Now we have been inundated with orders and I was hoping for a easy way to show if we had enough raw materials on hand to cover all orders. I cannot see how to break a product down past one sub assembly so I cannot get a snapshot of purchase parts required to build orders in house.

Any suggestions?