Copy Bom for Excess Inventory Roll Up

I need an idea how to program a way for a bom to be inserted into a table so that we may do a comparison of on hand excess inventory. Has any one done this? And what would be the logic? Axapta 2.5 Market Pack

Myrl, Sorry but i am not able to understand your question. Please can u give an example. What exactly do you want to do? Please do clear it out with an example. Thanks & regards Vaibhav Pednekar