Organisation: Selecta PLC
Founded in 1957, Selecta is a Swiss-based vending and coffee services company with over 4,000 employees and trading in 18 European countries. Selecta serves 6 million consumers every day at 140,000 points of sale and addresses the growing need for out of home food and beverage services in the workplace and on the go.
THE EBASE CONNECTION
The LTO/AFI interface is an application developed by Selecta’s Shared IT Services that closely integrates with its OP-module and Movex ERP-system. Each sales point (vending machine) produces data that is collated both automatically and manually, utilizing different file formats and readout methods for each country of operation.
It is the job of the LTO/AFI interface to process information errors in this sales data.
Difficulties in providing continued support meant that Selecta needed to quickly and cost effectively migrate the LTO/AFI interface from its legacy RS400 technology to a modern web-based implementation. After an extensive assessment of software tools Selecta adopted Verj.io in November 2014 to provide the enabling platform.
Ebase were commissioned to deliver a solution that allowed input files to be processed against a set of rules that could be managed independently by the business, i.e. without requiring programming effort to make changes or add new rules. Any data failing a particular rule was flagged and then appeared in screen
reports visible to data administrators who were then able to ignore, correct or reject that data record.
The system needed to be fast and responsive, able to link records from multiple databases to a single sales point record, and display all related records for use when making administrative changes, showing which record in the group was in error.
HOW’S THAT WORKING OUT?
Ebase delivered a rules engine that allows business users to graphically design and maintain the business logic to be applied the input sales data. Workflow processes handle the different types of error that can be produced, automatically moving error data between different departments until the fault is fixed and the data can be re-submitted and successfully processed. The resulting system daily applies over 2,000 rules to 50,000 input sales records and was delivered into operation in October 2015.
The new system introduces a new level of visibility and manageability to the LTO/AFI processing, simplifies and automates the error resolution process, and replaces a legacy software technology with a modern web-based implementation.