Case study | SAP

ERP systems data merging with a robotics solution

  • Client
    Large International FMCG Company
  • Industry
    Retail
  • Country
    Global
  • Solution
    SAP
  • Duration
    5 months

Overview

Merge & Acquisition of a company with leverage the new integrated stock transfer process development to ensure completeness and accuracy of data being transferred between the ERP systems.

In today’s world merge and acquisition of companies is a common way to gain financial benefits following their strategy for sustained growth
and market expansion. Operating reorganization might be a huge challenge due to natural systems differences, various releases, business habits
and maintenance level.

Background

Taking into account the potential benefits and risks from the reorganization, we consider the following operational company merge approach:

  • Transfer to (non)SAP solution of one the parties,
  • Joint-system solution with a combination of both.

While the first solution seems to be obvious then what if we need to combine two separate, operating SAP systems? Below, you’ll find out how we confronted that challenge and solved our client’s problem.

Challenge/Problem

Few years ago, our client bought a company which was using their own SAP system not only for sales, but fully enhanced production including all possible productive areas like production planning, inbound/outbound logistics, finance, controlling and quality. Once done – our client asked for one simple solution to keep the factories in the “old” system and move all market units into his own system.

The transformation program globally required to combine company A and company B business units into combined legal entities with a new company A name. Historically, company A units were running SAP system (A), and company B units are running SAP system (B). Transformation program scope included running all market business operations in the (A) system, while factory business operations will still be running in the (B) system. This would mean that the integrated factory-to-market process will be running in two systems and inventory will need to pass from one system (B) to the other (A).

 

Expected benefits:

  • Drive standardization, optimization and increase efficiencies via retirement of multiple company B legacy made-to-measure programs and elimination of manual adjustments in system (A),
  • Standardization of intra-unit process across both systems,
  • Ensuring transactional integrity of material prices,
  • Leading to a better data accuracy,
  • Identified robotic options to improve efficiency & user centricity,
  • Avoid long-term inconsistency,
  • Ensuring COPA reporting accuracy.

Solution

Leverage the new integrated stock transfer process development to ensure completeness and accuracy of data being transferred between the ERP systems, ultimately optimize Intra-Unit and Inter-Company Process to support company A globally via the hybrid model.

Finance statements, reporting and interfaces as well as reconciliation for period close processes were developed and aligned country specific gaps with global best practice to drive standard approach for factories and markets. Facilitate, both, cost and growth value unlock for the combined company A and company B segments.

Each of implemented solutions has great importance to the work of the project, however, solutions used robots were crucial:

  • Since factory is operating in SAP (B) and market plants are placed in SAP (A), costing is done in each system separately. To avoid differences, there is a need to monitor this on a period basis.
  • Since a new integrated stock transfer process is being developed for which, we require a report to ensure the completeness and accuracy of data being transferred between systems and ultimately the financial statements of the units involved.
  • To create a report/tool that will compare COPA summarization tables data between SAP (B) and (A) after sales data transfer between the systems.

What is a robot?

  • Robot is an automated process which is validating data accuracy between SAP (B) and SAP (A).
  • Robot works on a virtual machine, that in not accessible by any users. With that, users are not able to see any steps performed by the robot in the background.
  • Robot is verifying data accuracy for an agreed process and send a list of mismatches (reconciliation report) to an agreed address by email.
  • End user(s) need(s) to review the output generated report in order to analyze all possible reasons why processed
    and displayed data differ between both SAP systems.

 

Processes which are covered by robots:

  • Standard Cost Reconciliation,
  • Intercompany Price Reconciliation,
  • (A) system to (B) system Retrofit Reconciliation.

 

Benefits

  • Comparison reports created automatically
  • All found difference send to users based on the predefined table
  • Separate reports for each Country in the scope
  • No risk of mistake between systems
  • Short time of creating reports
  • Possibility to run report ad-hoc (i.e., when new material will be created or after fix)
  • Easy communication with Robot (via mail)
  • Confidential data additional security approach
  • Flexible solution (easy way to add new country to the process)
  • User-friendly guidance-book

What have we learned?

We dealt with many areas during the project, so that it was incredibly developing experience for us. At that time, we faced, among others:

  • Sales of products from (B) factories to (A) markets,
  • Transfer of goods inventory between factory to market within same legal entity,
  • Intra-Company Cost Transfer within same legal entity,
  • Sales Retrofit of 3rd party sales volume from (A) system to (B),
  • Automated factory revenue recognition for intra-unit shipments,
  • Inter Company Business Logistic Cost Handling (Russia),
  • Multiple Sourcing/ePlant (China & US).
ROBERT WACHOWIAK DELIVERY PARTNER AT BPX

We are glad that thanks to an innovative approach, we were able to help our client connect data in two SAP systems in real-time and take care of the integrated transfer process. This solution certainly translates into increased work efficiency and stable growth consequently. Working on the project was a really developing experience for us. Considering the complexity of this project, our team had a chance to prove themselves in many SAP areas. In particular, the implementation of robots is another confirmation of how important automation is in today’s world.

Here you will find expert support on SAP

Learn more

See other case studies

  • Replication of MRP Areas between SAP MDG and SAP ECC

    Replication of MRP Areas between SAP MDG and SAP ECC

    Read more

  • Implementation of the ERP system enova365 in many companies of the Opolgraf brand

    Implementation of the ERP system enova365 in many companies of the Opolgraf brand

    Read more

  • Implementation of the company’s acquisition process by merging and integrating systems

    Implementation of the company’s acquisition process by merging and integrating systems

    Read more

  • Report optimization in the FMCG industry

    Report optimization in the FMCG industry

    Read more

Discover our capabilities

  • 18+ years of experience

    Since 2006 we have been helping our clients implement and develop systems and applications that streamline business processes. Owing to our know-how, our Partners are able to fully utilize the technologies of the future.

  • 1000+ completed projects

    We approach each project individually. We employ technologies that improve the enterprise functioning and management. The joint implementation of each projects brings our clients closer to perfection in managing a modern organization.

  • 350+ employees

    We have an appropriate team of experiences and qualified experts in many fields. Consultants, analysts, programmers and PMs. We have been successfully implementing even the most complex projects that streamline the development of organizations around the world.

  • 50+ countries where we have carried out deployments

    Based on our unique skills, we implement innovative projects around the world. We conquer new markets and constantly enter new areas. A comprehensive approach allows us to ensure the development of companies from numerous industries and sectors.

Contact us!

Let’s talk! Are you interested in our solutions? Our experts are happy to answer all of your questions.




    The controller of your personal date is BPX S.A., please see the Privacy policy for more detailed information regarding the processing of personal data by BPX S.A.

    • SAP
    • Qlik
    • Infor
    • enova365
    • Teta
    • Visual Fabriq
    • RGM
    • Power BI
    • Semarchy
    • K4 Inphinity
    • Vizlib
    • Tricentis Tosa