Sql query to Update Supplier Cost

Be careful before you do this. The system is set so you can have multiple suppliers for each item. Supplier A Cost might be 10.99 but Supplier B charges 14.00. You normally buy from Supplier A, but they sometimes run out, so you need to order from Supplier B.

If you update Supplier Cost from Item Cost, both suppliers would display the same cost. Your scenario is >

The supplier cost at the store level will be updated from a received purchase order if you set the check box in File/Configuration/Options/Purchase Order Options/Update supplier cost and tax rate from purchase order. This is in Store Operations Manager. Stores in various regions may have different costs for the same item and from the same vendor so I do not think that the local supplier cost will get pushed back up to HQ, however, I have not tested this out so I'm not sure.