Disable (not uninstall) HQ Server and HQ Client everywhere (delete EXEs and shortcuts).
Uninstall will cause RMS install log corruption and require RMS reinstall (so don't do it).
Change any DRS apps connected to HQ to store db (except POP/HQ shortcut which can be removed). Example: DRS Linker-Setup
Reverse all security masks in POS and Manager configured during template deployment (see HQ deployment article for long list which takes about 30 minutes to complete).
Service Manager: To ensure prior workorders display in SM at Store 1 (change 3 to reflect store ID that needs to be changed to 0) --
UPDATE [Order] SET StoreId = 0 WHERE StoreID = 3
UPDATE [Order] SET StoreId = 0 WHERE StoreID = 3
UPDATE [DRS_O_Extension] SET StoreId = 0 WHERE StoreID = 3
UPDATE [DRS_OE_Extension] SET StoreId = 0 WHERE StoreID = 3
UPDATE [OrderEntry] SET StoreId = 0 WHERE StoreID = 3
UPDATE [OrderHistory] SET StoreId = 0 WHERE StoreID = 3
If cut and paste generates a syntax error upon Run copy to Notepad, remove any extra spaces at end of lines and CR at end of body text and try again.
Results will be "0 records affected" but WO's should now display in the list view including historical entries.
SUMMARY
This article lists the steps that are required to remove a store that has been synchronized with Microsoft Business Solutions Retail Management System Headquarters by using worksheet 101.
MORE INFORMATION
You may have to perform this task if one or more stores will no longer connect to Headquarters (HQ).
Follow the steps listed below to remove a store from HQ.
1. Open Store Operations Administrator.
2. Connect to your database by clicking File and then Connect.
3. Open a new query by clicking Query and then New.
4. Copy and then paste the following text into the Query window:
UPDATE Customer SET HQID = 0 UPDATE Department SET HQID = 0 UPDATE Item SET HQID = 0 UPDATE ItemClass SET HQID = 0 UPDATE ItemMessage SET HQID = 0 UPDATE ItemTax SET HQID = 0 UPDATE PriceRounding SET HQID = 0 UPDATE QuantityDiscount SET HQID = 0 UPDATE ReasonCode SET HQID = 0 UPDATE SalesRep SET HQID = 0 UPDATE Schedule SET HQID = 0 UPDATE ScheduleSegment SET HQID = 0 UPDATE Serial SET HQID = 0 UPDATE ShippingCarrier SET HQID = 0 UPDATE ShippingService SET HQID = 0 UPDATE ShipTo SET HQID = 0 UPDATE Supplier SET HQID = 0 UPDATE Tax SET HQID = 0 UPDATE Tender SET HQID = 0 UPDATE Accounting SET StoreID = 0 UPDATE AccountReceivable SET StoreID = 0 UPDATE AccountReceivableHistory SET StoreID = 0 UPDATE ARHistoryMirror SET StoreID = 0 UPDATE Batch SET StoreID = 0 UPDATE CalendarEvent SET StoreID = 0 UPDATE Cashier SET StoreID = 0 UPDATE [Check] SET StoreID = 0 UPDATE Configuration SET StoreID = 0 UPDATE Customer SET StoreID = 0 UPDATE DailySales SET StoreID = 0 UPDATE DropPayout SET StoreID = 0 UPDATE InventoryOffline SET StoreID = 0 UPDATE InventoryTransferLog SET StoreID = 0 UPDATE Journal SET StoreID = 0 UPDATE Message SET StoreID = 0 UPDATE NonTenderTransaction SET StoreID = 0 UPDATE OldJournal SET StoreID = 0 UPDATE [Order] SET StoreID = 0 UPDATE OrderEntry SET StoreID = 0 UPDATE OrderHistory SET StoreID = 0 UPDATE Payment SET StoreID = 0 UPDATE PhysicalInventory SET StoreID = 0 UPDATE PhysicalInventoryEntry SET StoreID = 0 UPDATE PoleDisplayMessage SET StoreID = 0 UPDATE PurchaseOrder SET StoreID = 0 UPDATE PurchaseOrderEntry SET StoreID = 0 UPDATE PurchaseOrderEntryDetail SET StoreID = 0 UPDATE Receipt SET StoreID = 0 UPDATE RecordDeletedLog SET StoreID = 0 UPDATE Register SET StoreID = 0 UPDATE Report SET StoreID = 0 UPDATE SalesRep SET StoreID = 0 UPDATE Security SET StoreID = 0 UPDATE Serial SET StoreID = 0 UPDATE Shipping SET StoreID = 0 UPDATE ShipTo SET StoreID = 0 UPDATE SignatureCapture SET StoreID = 0 UPDATE TaxEntry SET StoreID = 0 UPDATE TaxTotals SET StoreID = 0 UPDATE TenderEntry SET StoreID = 0 UPDATE TenderTotals SET StoreID = 0 UPDATE TimeCard SET StoreID = 0 UPDATE TimeClock SET StoreID = 0 UPDATE TimeStampLog SET StoreID = 0 UPDATE [Transaction] SET StoreID = 0 UPDATE TransactionEntry SET StoreID = 0 UPDATE TransactionHold SET StoreID = 0 UPDATE TransactionHoldEntry SET StoreID = 0 UPDATE VersionHistory SET StoreID = 0 UPDATE VisaNetAuthorization SET StoreID = 0 UPDATE VisaNetBatch SET StoreID = 0 UPDATE Voucher SET StoreID = 0 UPDATE VoucherEntry SET StoreID = 0
5. Press F5 to execute the query at one time against the Store Operations Database.
6. Open a new query by clicking Query and then New.
7. Run the following queries ONE AT A TIME:
UPDATE Configuration SET StoreID = 0 UPDATE Configuration SET SyncID = 0
8. Close Store Operations Administrator and do not save queries.
Dave J
Comments