New Supplier, Same Item Info

We are adding a new supplier/distributor (Primo) to RMS. This supplier uses the exact same item information (reorder #, cost, min. order, mpq) that we have from our current supplier (Color). We may continue to use Color in the future, so the KB Article about merging suppliers does not apply.

Is there a way, probably in SQL, to change all of the Items with Color set as the "primary supplier" and have Primo be the new "primary supplier" and Color remain as a secondary supplier? If not, I'm looking at having to go manually into each item and manually add the supplier and the copy all of the supplier info.

Thanks.

Reply to
Eddie
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.