Business Solutions & EPOS
Pilot
The numbering system and labelling style were tested and approved prior to roll-out. A dummy data set was introduced to allow for training of key personnel, who would then train the next level of employees. This would also allow for testing of the database links and final accounts processing.
The dummy data was taken from the customers existing inventory database (via .CSV importing), during this process errors were found. These needed to be corrected as it was intended to use this data when the system was made live. As with all database systems if errors are introduced these will remain indefinitely. This was an ideal opportunity to correct these anomalies and standardise the numbering & naming conventions. Once the structure had been decided upon the correction process for the 3200 individual items of stock was relatively quick. The structure was now ready and would set a precedent for the future.
At this point a “fail-safe” data acquisition process was setup that would guarantee the latest valid sales figures would always end up in the head office accounting database. This was in addition to the structured process already built into the RMS software and achieved using DOS batch files running SQL commands and run by a scheduled service. It was felt necessary by the customer to add this to ensure the remote stores data could never be lost, even if a stores remote access link was lost for an extended period.
