Convert item type - item setup incorrectly


We have a large number of items in our inventory that were setup incorrectly.

The items have activity posted against them.

Is there any way in the data tables to flip a raw material item to a finished good?

For example, our BOM pulls together the raw materials to create a finished good which we then sell to our customers.

However, the person who setup the Finished Good item number in Sage 500 chose "Raw Materials" from the Item Type drop down box.

Suggestions? Thank