1. Home
  2. Point-Of-Sale Software
  3. copy item cost to supplier cost field

copy item cost to supplier cost field

I have customer that has an item cost in each item, but has no cost in supplier tab. Is there a sql statement that will copy the item cost into the supplier cost field? Thanks for the help Dave

Reply to
DCR
Loading thread data ...

here it is

************************** UPDATE Supplierlist set SupplierList.Cost=Item.Cost FROM Item WHERE Item.ID=SupplierList.ItemID

--AND Item.SupplierID=SupplierList.SupplierID

************************** if u execute it as it is, it will update the cost for primary suppliers only, if u remove the comment (--) from the last line, it will update the cost for all the item's suppliers (primary & not primary)

Nashat

Reply to
Nashat

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.