This question has come up a few times recently.
Go to the Keyword search tab at the top of this page & type bom configuration[/b] (or similar) for some leads to this & related questions.
thread559-91341
thread559-66101
thread559-44762
Which BOM style are you using ... Excel or SW04 new & "improved"?