Help with SQL statement- Supplier List cost into cost field in Ite

Hi Tara - backup your db first....

first run select * from supplierlist order by cost asc

-- this will show you the contents in the supplierlist table first listing items with zero cost (or the lowest cost) - fix zero cost entries first by editing item properties and setting the correct cost in the supplier tab

then run update item set item.cost = supplierlist.cost from item inner join supplierlist on item.id = supplierlist.itemid

-- the inner join will only update items that are both in the item table and supplierlist table

to see items that are not in the supplier list table run select itemlookupcode, description from item where id not in (select itemid from supplierlist)

H> Hi, I've a customer who has a number of items in their HQ database at zero

Hi, thanks for that- it worked perfectly. There is just one snag however and I didn't think of it until I was testing. Many of the suppliers use specific currencies so the information I need copied from the Supplier tab is actually the Local Cost. When I view the SupplierList table, Local Cost doesn't appear as a column. Is it just a calculation based on exchange rates for information or does it actually exist somewhere within the database? Your help once again would be much appreciated.

T.

"c> Hi Tara - backup your db first....