Closing stores with EEE

From EnablerWiki

Created: 15 October 2009. Last Reviewed: 15 October 2009

Process for closing stores with EEE & Enabler

The following process should be followed when closing stores when you are using both EEE and Enabler.

1. Before removing the computers from the store, you should ensure that an export of Nibbler Messages and a Hostlog export have been performed and that a communication session has occurred with HO. This will ensure all data from Enabler has been transferred to EEE.
2. In EEE, there are a number of changes required to the branch record for the store. From Location Management->Branch, edit the store being closed and make the following changes:-(i) Place a tick beside “Exclude this branch from data exports” and “Do not resend data to this branch”. This will ensure that EEE Data Exporter doesn't continue sending master file data to this branch. The next time an export of unacknowledged records is performed, any unacknowledged records from this branch will be removed from the ExportMaintenance table. This change will also be exported to Enabler HO, resulting in the store appearing as offline in Enabler HO.(ii) Remove the ticks beside “Maintain Costs”, “Maintain Prices”, and “Maintain Min Max”. This will stop EEE generating cost/price/min max records for this store which are not required.(iii) Place a tick beside “Prevent stock transfers to this branch”. This will prevent other stores from attempting to transfer stock to this closed store.(iv) Remove the ticks from “Consider branch when re-ordering”, “Consider branch when re-plenishing” and “Allow purchase ordering for this branch”. This will stop Auto Suggested Re-Orders or Replenishments being created for this store, and will stop purchase orders being raised against this store.(v) If the option “Stock visible on website” is ticked, you may wish to remove this tick so any stock on hand quantities still in EEE are not shown on the website.
3. If stock wasn't transferred from the store when it was closed, there may still be inventory levels in EEE. To verify this, you can run a Stock Valuation for the store in EEE. If there are quantities still left in EEE, you may like to remove this. EEE has a stored procedure that can be used to zero all stock in a store. You may need to get your IT department to run this process if you don't have access to SQL Server Management Studio, or don't have SQL update permission.The syntax for the procedure is:-Execute ZeroBranchStock 'BranchCode','TillNo','Date','Time','Userid',ActivityNumbere.g.Execute ZeroBranchStock 'BBAY','01','20060329','14:00:00','Trevor',0