Share
Report
2,085So, throughout the years we've built up quite a list of suppliers, and many of them we no long have active accounts with and don't plan on ordering from again. I know that in general deleting things in RMS is a little dicey because many records that reference the entry in the SQL table will come up empty if it is removed, but seeing as there is no "inactive" function for suppliers, I think deleting is going to be the best option for cleaning the list up.
If I go to Database-> Suppliers under HQ Manager and delete the selected suppliers, then run a style 206 (Update Suppliers) worksheet, I'm inclined to think that it will not actually remove the supplier from the various Store Ops databases, as the worksheet requires you to add the suppliers you wish updated to the contents tab before approving it, and I can't add a supplier that I've just deleted.
I'm guessing it's going to take either a SQL command or remotely logging in and deleting the supplier in Store Ops at each store. If I go the SQL command route, would the following course of action be sufficient?:
A) Change the SupplierID column to <NULL> for all entries in the item table with the selected Supplier's ID as the value
B) Delete all entries in the Supplierlist table with the select suppliers ID
C)Delete the supplier's entry in the Supplier table.
Are there any other places where a supplier would be referenced? If I instead remotely log in and simply delete the supplier through StoreOps manager, will it also remove entries in the Supplierlist table and SupplierID entries in the Item table? If not, what about in the HQ database?
I guess in short I'm asking what is the proper procedure for removing a supplier from Headquarters and all stores.
*This post is locked for comments
All responses (
Answers (
