Case Study

Automobile Ancillary supplier to OEMs

Real-world reporting automation and analytics outcomes — built on ERP-connected data.

Automobile Ancillary supplier to OEMs

Company Snapshot

Company

Automobile Ancillary supplier to OEMs

ERP

Navision

Industry

Chemical

About Company

This company was Established in 1941, an independent Automotive component maker and Automotive wire harness and manufacturer of meters electronic component. Also involved in production of a variety of items including air conditioning equipment, solar thermal conversion equipment, gas equipment, household electric wiring unit with presence in 45 countries.

Challenges and Objectives

  • Time consuming and logic intensive Daily Finance Reporting.
  • Accurate and correct reports analysis to reduce potential losses.
  • Reduced redundant and repetitive tasks from a person sparing her for other important tasks.
  • Humongous time was consumed to fetch the Z-report from SAP which affected the system and server performance.

How the Solution Helped

  • MyReport along with VirtDB (SAP Mass Data Extractor) helped to automate end MIS and Reporting along with considerable reduction on user dependency.
  • All the complex data transformations required for financial reports which were done manually were automated and scheduled as a routine job for the incremental data load.
  • This resulted in removing the data errors permanently giving more accurate numbers. Moreover, the updated reports were available to end users on a single click.
  • By reduction in report generation time MyReport helped them to become more efficient and productive.

Results

  • They transfer up to 6 crores (60 million) rows per hour from SAP without manual intervention and accurate too, which was a major concern.
  • Users now invest their time in more productive activities than just the mundane and repetitive tasks of data collation and manual reporting.
  • This company could now actually spend 80% time on analysis and decision making and just 20% time on data extraction, report & dashboard creation, and any other activities around it.
  • The complexity in Financial Reporting was minimized to a nil and Reports are now available on a single click.
  • Financial report (Expense Report, PNL report, etc.) completes in just 1 day which formerly took 8 to 9 Man days to create.

Let’s talk about your ERP reporting

Want to automate MIS and financial reporting from SAP without stressing your system?