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
copy item cost to supplier cost field
Nov 01, 2006
1 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required