Number of users:
Microsoft Power Automate
Purpose of the project
The aim of the project was to create a file ready for posting, containing mapped data from the German and Romanian branches, which have different ERP systems and, consequently, a different chart of accounts. The mapping concerned G / L accounts, partner companies and segments.
Until now, the process was handled manually, which posed the risk of making a mistake, and additionally took the time of employees.
The analysis of Netwise consultants showed that the best solution would be to use the Robotic Process Automation class technology based on the Microsoft Power Automate platform. As a result of the implementation, an application was created – a robot that collects input data in the form of Excel files and configuration data from Sharepoint lists. The robot processes and maps the input data from business units and then saves the data transformation result in one unified file, which is ready for posting and requires no additional actions.
Thanks to the use of Microsoft Power Automate, the robot application is flexible and ready for changes that can be introduced in a short time. Thanks to the configurator available in Microsoft Power Automate, the robot can be modified and extended directly by trained and technology-familiar CIECH employees.
Collaboration and record duration
During the implementation of the project, it was necessary to use a flexible approach to incorporate changes in the application. The CIECH team was able to test and modify both the scope and flow implemented in Microsoft Power Automate on an ongoing basis. The fully operational robot was ready 2 months after the start of cooperation between CIECH and Netwise.
About the CIECH Group:
CIECH is an international, developing chemical group with a strong position on global markets. It is the second producer of soda ash and baking soda in the European Union, the largest producer of evaporated salt in Poland, the largest supplier of sodium silicates in Europe, the largest Polish producer of plant protection chemicals and a leading producer of polyurethane foams in Poland. It has factories in Poland, Germany and Romania and employs over 3,000 people throughout the EU.
Since 2005, the company CIECH S.A. is listed on the Warsaw Stock Exchange, and since 2016, simultaneously, on one of the largest stock exchanges in Europe – Börse Frankfurt. The development of the Group is supported by the strategic investor – Kulczyk Investments.
As one of the largest Polish exporters, CIECH sends its goods to almost all continents. They are used to produce articles necessary in the everyday life of millions of people around the world, which is why the Group is an important element of many sectors of the economy – construction, automotive, agriculture, chemical, food and pharmaceutical industries.
CIECH combines a modern approach to business with care for sustainable development. Since 2020, he has been a member of the United Nations Global Compact – the world’s largest initiative that brings together socially, environmentally and economically responsible enterprises.
More information about the CIECH Group can be found at www.ciechgroup.com and www.ciechdlagospodarki.pl
"The project carried out together with Netwise allowed us to automate the process of mapping and aggregation of accounting data in Ciech S.A. Robotization not only eliminated the risk of human error, but also accelerated the entire process. In cooperation with Netwise experts, we highly appreciate their knowledge and experience, but also a flexible approach and putting our business needs first "
- "As a result of close cooperation and openness of the CIECH team to our recommendations, a supporting robot in data transformation and mapping was created in a short time. It is worth emphasizing that the technology used and the approach adopted allowed during the project to make changes in the established processing process very flexibly and in a short time. This is particularly important in the adaptation of new solutions in the organization and in the standardization of business processes"