The Fruberica case study below is translated from a case study published by RPO ICT Solutions, a LANSA and IBM business partner in the Netherlands. RPO is an all-round ICT services provider and has been a leading software solution provider in the fruit and vegetable distribution for over 25 years. Initially RPO offered AGF/ng, as an IBM i and RPG-based ERP solution extended with LANSA for web access. Now called Freshng, the solution has been completely redeveloped in Visual LANSA and is available on IBM i, Windows and Linux servers or as a Cloud solution. Freshng is used by nearly 100 organizations in the Netherlands, Germany and Spain.
Fruberica, who is using the ERP solution on IBM i, was one of RPOโs first customers to extend its implementation with a mobile app for quality inspectors. The mobile app, developed with LongRange from LANSA, allows inspectors to use their iPads to view real-time ERP back-office data about the batches of produce that have been received in the delivery hall. They then use their iPads to enter their inspection findings for these batches. The inspection result is immediately validated and updated in real-time to the ERP system on the IBM i and available to sales staff.
Fruberica, based in the Netherlands, imports greenhouse vegetables from Spain and Morocco, such as tomatoes, eggplants, zucchinis and peppers. From Frubericaโs distribution center, located in De Lier, these products are then delivered to customers in the Netherlands and elsewhere in the world. The companyโs peak period is in the winter, when there are less greenhouse vegetables being harvested in the Netherlands. Frubericaโs annual growth has been around 10% for several years in a row. To continue to support its strong growth, Fruberica decided to digitalize the flow of information, starting with its paper-based quality inspection reports. Frubericaโs quality inspectors are now equipped with custom developed mobile apps on iPads to carry out their work. This has resulted in efficiency gains and more effective communication with customers.
The purchased vegetables are delivered by truck and are, immediately after unloading, assessed on a range of quality characteristics, such as ripeness, weight, color, temperature, size and firmness.
โEach batch is different,โ says General Manager Michael Holslag. โThere are quality differences between the pallets, and sometimes even between the packed units on a pallet. It is of the utmost importance in the fresh industry that we promptly classify the produce we receive, in order to be sure we can swiftly deliver the right product to the right customer. This effectiveness of delivery has significantly contributed to our success. Ten years ago we were relatively small, but today weโre one of the major players in our industry.โ
Until recently, Frubericaโs quality inspectors recorded their findings on notepads and order forms. Communication between the inspectors, who carry out their work in the receiving hall on the ground floor, and office staff, located on the top floor, was mostly verbal. Due to Fubrericaโs continuous growth, that way of working came under pressure.
โIt happened regularly that when a customer called with a question about a batch of produce that had arrived earlier that day, I had to put that call on hold and run downstairs to find out the details about that batch. Especially for large orders, you need to need to provide the right price and details straight away, because you will not get a second chance,โ explains Michael.
During the winter peak of 2011/2012, Frubericaโs team had a hard time keeping up with the volume of business. Karel Holslag, father of Michael and consultant to the company, called in RPO ICT Solutions, Frubericaโs regular ICT provider, to collaborate with the team and come up with a solution to improve efficiency on the warehouse floor. Together the two organizations came up with a plan.
It is of the utmost importance in the fresh industry that we promptly classify the produce we receive.
As a first step, Fruberica upgraded its digital network in order to provide a solid infrastructure for further automation and innovation. Secondly, cameras were installed to provide office staff with a direct view of the unloading trucks and the produce on the floor. The cameras can zoom in to the smallest level of detail.
Next, Fubrerica and RPO explored what options were available to replace the paper-based inspection reports with digital recordings. Their decisions was to use iPads to capture and transmit quality inspection data. Karel Holslag, explains โThe intuitive nature of the iPad was the main decision factor. Everyone knows how to use them. The challenge was how to make the Apple iOS talk with our IBM i-based Freshng ERP solution from RPO. Fortunately that turned out to be straightforward.
In the summer of 2012 RPO developed a quality inspection app, based on the 14 quality control criteria that Fruberica uses. RPO used the LongRange development tool for this. LongRange is a native mobile app builder from the LANSA organization. The solution consists of a server-based component (LongRange Server) and a native mobile App that runs on the mobile device. LongRange server calls the associated program on Frubericaโs IBM i server (such as an RPG, COBOL, CL or LANSA program). The program performs its processing and issues a send screen command. LongRange Server sends the screen to the mobile app, together with instructions as defined with LongRange Studio. The mobile app interprets the instructions and presents the data on the mobile device. LongRange supports both Apple and Android devices.
Using this LongRange bridge, inspectors can use their iPad to view real-time Freshng ERP back-office data about the batches of produce that have been received in the delivery hall. They then use their iPads to enter their inspection findings for these batches of produce. The inspection result is immediately validated and updated in real-time to the Freshng ERP system on the IBM i.
The intuitive nature of the iPad was the main decision factor.
Michael says, โThe inspection App touches the heart of our business. Thatโs why weโve spent sufficient time to make sure we define the right criteria, using pick-list and checkbox fields. There is also a free format field, which allows the inspectors to express their opinion in words. This is only needed if the available pick-lists and checkboxes cannot capture the inspectorโs assessment. Often half a word is enough to qualify a product.โ
Fruberica also changed its business procedures. Upon arrival of a batch, the inspectors now use their iPads to take two photos: a photo to document the overall quality of the batch and a presentation photo with a more commercial purpose. In the past, photos were taken only occasionally and it was a manual task to associate the photos with the actual batch of produce. Today the photos have become an integrated part of the inspection procedure and a link to the photos is automatically stored in the ERP system. The iPads are also used to take and store a picture of the CMR-delivery note.
Once an inspection report its finalized, it is immediately transmitted from the iPad through WiFi to the IBM i ERP system and so is available to sales and admin staff. There is no running up-and-down any more to get inspection reports from the warehouse to the office. Frubericaโs inspection cars (battery-powered inspection platforms on wheels from Robur) have also been adjusted and are now equipped with a power socket, so that the iPads are continuously charged.
Once an inspection report its finalized, it is immediately available to sales and admin staff.
Since October 2012, all inspections have been carried out using the iPad App and Fruberica is very pleased with the results of the project. โAt first I was hesitant about using iPads, because my top priority is to protect the chemistry my team has with the product and the company. Using iPads could have resulted in putting up a barrier. But the implementation went smoothly and the results exceeded our expectations,โ says Michael.
โThe team very quickly got used to the iPad app. It may seem a huge transition, but we are using the exactly the same inspection criteria as before. We just moved the data entry from paper to the iPad. One of our part-time inspectors, the father of the current owner, is 81 years old and he was productively using the app within a week.โ
โThe inspection team can now handle a much bigger workload, without any sacrifice in the quality of their work or team spirit. Communication is now not only faster and more accurate, it has also contributed to a calmer atmosphere in the workplace. No one has to run up and down anymore to get the inspection reports and photos from the warehouse to the office.โ
โWhen a customer enquires about the quality of a specific batch of produce they are considering to order, it now only takes a few seconds to email the relevant inspection report and photos,โ concludes Michael.
When a customer enquires about the quality of a specific batch of produce, it now only takes a few seconds to email the relevant inspection report and photos.