Deleting All Suppliers

Just wondering if there is a way to delete all of the suppliers in Store Operations Manger. We have our Headquarters Manager with all of the correct Suppliers but one of our stores has to many suppliers. Want to know if there is a SQL Command or easy way to just delete all of the suppliers and then run Worksheet 206 to get the right suppliers back into the database. Also not sure if a supplier gets deleted do all of the items then lose the reference back to that supplier? Or will it still hold that supplier in item properties so when that supplier gets re-added all items will still have reference to that supplier. Sorry if sounding to confusing.

Reply to
nt8378
Loading thread data ...

To delete all Suppliers run this SQL statement: * MAKE SURE YOU DO A BACKUP FIRST DELETE Supplier DELETE SupplierList

The Worksheet 206 should re-reference all your items back to the appropriate supplier.

Rob

Reply to
Rob

Reply to
nt8378

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.