• Omnis web solution •
Omnis Studio enabled a smooth migration to SAP Business One
and adds functionality, flexibility and a better user experience
Challenge 1 : We needed to migrate as much data from the previous ERP solution as .csv files in a format compatible with the SAP Data Transfer Workbench. For this we needed to convert the existing data structure following the SAP requirements.
Challenge 2 : We needed to merge data from the previous ERP FrontBase solution and the SAP solution into a MS SQL Server data warehouse. Data retrieval is done using PowerBI and Omnis.
It was decided to use SQL Server as a back-end and to continue using Omnis Studio as the development tool for future SAP related interfaces. Even before the implementation of SAP Business One, most of the Omnis Studio code was already written for the first SAP test database.
This way Royal Botania has been able to achieve a smooth migration to SAP and to add functionality to SAP in an extremely short time frame to meet requests of their users and to ensure a better user experience. Details about these solutions are available in the screenshots on the right.
Apps & Screenshots
Transport Cost Calculator
Print item label
They can sort on a variety of item properties (collection, model, colour, subgroup).
It changes language on-the-fly for the languages used in SAP (Dutch, French, English, German).
Getting stock for stock items in SAP is quite easy. But for production items we need to calculate the virtual stock based on its components. The Bill Of Material in SAP is retrieved for this purpose.
The stock level is presented in red (no stock), yellow (limited stock) and green (plenty of stock).
Accessibility is taken into account: The user can choose between several colour themes and f.i. switch light green to dark green or blue bullets.
Online item labels
The Print button generates a PDF form using the “showpdf” client command in the browser. The result is 2 A5 labels per A4 sheet. This way, typing errors can no longer occur.
Initially the focus of Royal Botania was to combine superb quality and refreshing designs made out of teak wood. The company very soon became internationally synonymous for luxurious quality and design. The reputation and brand name gained worldwide recognition. This success led to new outdoor furniture collections being designed as well as to the launch of outdoor lighting lines. The team expanded and soon introduced lines made of new materials such as stainless steel, aluminum and synthetic fibers. There is also a 100,000 m3 large warehouse that stores all of the products before they are carefully sent out to many happy customers worldwide. Over the years, Royal Botania has earned an acclaimed reputation for creating the most refined, diverse choice of outdoor collections in the world.
“Using Omnis Studio we are able to create forms and reports with a high level of user-friendlyness in a fraction of the time it would require using other development tools. It allowed us to create a clear and neat layer on top of SAP Business One,“ said Geert Landuyt, IT Manager of Royal Botania.