Item Cost Profile was not generated

Summary:

Item Cost Profile was not generated

Content (please ensure you mask any confidential information):

1. An item was created wrongly with Inventory Asset Value flag as No.
2. Two inventory transactions i.e. Misc. transaction and PO Receipt was performed for the item.
3. When Create Cost Accounting Distribution was run , it went into warning with error as - "The item cost profile was not generated. " Reason being we have only created Asset Cost Profile.
4. We have now updated the Inventory Asset Flag as Yes for this item.

I understand we would have to create expense cost profile to process and account these transactions. Just looking for any other way, if this transaction can be processed correctly like purging interface table and re-running Transfer transactions from Inventory to Costing process.