Implementation of an RPA System for Master Data Management in the Manufacturing Industry
Category: Dx Promotion
Sub Category: Support for improving management skills, Business automation
Industry: manufacturing industry
Background
・Each product was managed in a separate Excel file, and registration into the production management system was done manually, one entry at a time. As a result, the registration process was extremely time-consuming, and master data maintenance could not progress.
・Managing data in Excel made version control and history tracking difficult, leading to challenges in maintaining accurate information.
Solution
We developed a custom RPA solution that automatically registers data into the system using the existing Excel format already in use on-site.
With our proprietary RPA technology, we were able to flexibly implement complex registration logic that would be difficult to handle with conventional RPA tools.
Results
・By leveraging the existing Excel-based management, we achieved master data maintenance with minimal burden on on-site operations.
・Manual registration into the system was no longer necessary, making it possible to register multiple master records per day.
・With master data being consolidated into the system in real time, this initiative marked a significant first step in advancing digital transformation (DX) in production management.