Inventory Linking to Inactive Product Record

When linking inventory records to a new product record that has a similar inactive product record, the system will still be linked to the old record because of the "Supplier Color" and "Private Color" fields.
 
In order to fix this issue, enter the inactive product record and add any text on these fields (we added "-Inactive".  After doing this, delete the line from the order and insert the line again, it will link to the correct seq num.